How do I select a range in vb macro by using a variable as the ro
number

my prototype looks like this:
range("Az").select

where A is the column and z is a variabl

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

Range("A" & Castro(z)).Select

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"jws217" wrote in message
...
How do I select a range in vb macro by using a variable as the row
number

my prototype looks like this:
range("Az").select

where A is the column and z is a variable


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