do something to the cell two columns over from curent cell

  • Thread starter Thread starter sumGirl
  • Start date Start date
S

sumGirl

Hey all. I have a scrap of code that executes when a user doubleclicks
a cell (based on 'Target.Address' thanks to another poster in this
forum!). What I need to do is take that cell address and do something
two cells over based on it. I cant figure out how to add two cells (or
whatever) to the cell address...does this make any sense!?!?
 
You can use Offset

Offset (rows,columns)

Target.Offset(5, 1).Value = "H1"
 
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

Reference the same cell based on tab name 1
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Copy corresponding cell in Column B if cell in A contains certain text? 1
Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Default Cell Values at Change 2
Splitting Text from single cell in column across multiple Columns 3
resettable, over-ridable, default cell values 0
Hide columns based on row values 2

Back
Top