return column

[messsp]

I'm running a loop through rows and columns in a spreadsheet. the purpose of the loop is to highlight certain cells that fulfill a specific criteria. Now I want to copy and paste into a different spreasheet those columns whose cells are highlighted.
If I use .Adress for each highlighted cell I get something like $A$2. However if I want to use Columns().Select I need to obtain only the letter referring to the specific column. Any idea how I can do this? thanks for your help

 

[SkipVought]

Hi,

Range(TheAddress).EntireColumn.Copy

Skip,

_{[red]Be Advised![/red] Dyslexic poets...
write inverse!}