Offset Question

C

Craig McK

Hi

have the following line in a macro, but now need it to go to column "A" all
the time to pick up some data, how do I force it to a specific column, but
stay on the same row?

Just to confirm the "rng.Address" could be anything from column B ~ X

Range(rng.Address).Offset(rowoffset:=0, Columnoffset:=2).Activate
 
D

Dave Peterson

Here are a couple of ways:

rng.entirerow.cells(1).activate
or
cells(rng.row,1).activate

If rng is on the activesheet, then there's no reason to use range(rng.address).
 

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