Activecell address

[Patty2005]

Code
-------------------
Do... delete columns ................loop until(Activecell.address= "$B$ "
-------------------


In place of # I want to use a variable called "R" which a Value 16

I know I can directly write $B$16 but the objective is to find th
number of rows and dynamically checking for address.

Any help would be appreciated!!Thanks!!!

 

[Bob Umlas]

Loop Until Activecell.address = "$B$" & R

Bob Umlas
Excel MVP

 

[Patty2005]

Thanks!!!! :rock