Tim,

Good point.

Please ignore my susggestion, using "Chr".

regards,

John in Brisban


"Tim Zych" wrote in message
...
What if j refers to column 200?

"mudraker " wrote in message
...
one way

Range("a19:" & Chr(j + 64) & "26").Select


---
Message posted from http://www.ExcelForum.com/