selecting a range in vb

  • Thread starter Thread starter jws217
  • Start date Start date
J

jws217

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
 
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)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA set thick borders around non empty cells in range 0
Excel VBA 1
Make Macro Work On A Different PC 5
Applying Variables to SORT 4
How to Select A Cell in VBA with a Variable Row Number? 3
Variable Range, selecting/copying 1
Range Reference Problem 2
Number and names of courses may change later 3

Back
Top