need to get column letter for an active cell - ie: "DZ"

[lakers8175]

I have a looping copy/paste macro that runs through a certain # of rows and a certain # of columns.

I'd like to figure out how to know what column I am on and stop the macro at a specified column, ie: column "DZ"

Since this macro is used on spreadsheets of varying lengths, I was planning on setting a variable with the column letter, and then checking in the loop until I reach my variable.

Does someone have a snippet of code that may be useable?

Thanks.

 

[SkipVought]

Hi,

Please post VBA questions in VBA Visual Basic for Applications (Microsoft) forum707.

Skip,

_{[red]A palindrome gone wrong?[/red]
A man, a plan, a ROOT canal...
PULLEMALL!}