Please Help...How can I do this? Select a cell

Z

zoombr

How can I do this?

Select a cell
A(1+any value) ... for example: If any value = 2, the select cell will be
A3.
 
R

Ron de Bruin

Hi zoombr

You can't select with formulas

With code you can do this

Try this with a number in B1
Range("A" & Range("B1").Value + 1).Select
 

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

Top