activating cells

  • Thread starter Thread starter Ryan H.
  • Start date Start date
R

Ryan H.

Hi,

I have an active selected cell in a worksheet. I want to be able to select
the cell that's three rows down. How can I address that cell so I can modify
it?

Thanks
 
Hi Ryan,

One way:

Dim rng as Range
Set rng = Activecell.offset(3)
 
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

I want to make One Cell mandatory if another cell has a specific value , can anyone help me? 0
ActiveCell on inactive sheet 8
VBA code for for telnet 1
Choosing a drop-down menu selection returns value to another cell 2
clear all sheets code 4
Conditional listbox cell populating 4
Selecting a range relative to an active cell 2
Excel VBA help: Text file formatting 19

Back
Top