View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Chip Pearson Chip Pearson is offline
external usenet poster
 
Posts: 7,247
Default selecting adjacent cells

Try something like

ActiveCell(1,2).Select


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com



"Tom M" <Tom wrote in message
...
I have searched help for the proper usage of cell commands but
have not been
able to identify anything that allows me to select a cell, and
by means of a
macro, select the adjacent cell and invoke an insertion macro I
created.
It's the selection of the adjacent cell that is driving me
crazy. On a macro
level scale of 1 to 10, with 1 being beginner, I am probably a
two. I can
create some macros but nothing fancy. Thanks in advance for
your help.

Tom M