You don't usually need to select a cell to work with it.

Option Explicit
sub testme()
dim myCell as range
set mycell = activesheet.range("b99") '<-- how do you find the cell to start

mycell.offset(0,1).select
'.offset(x,y) means go x rows (up or down or 0)
and y columns (left or right or 0)

.....your code
end sub






Tom M wrote:

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

--

Dave Peterson