I am writing a macro where it starts off with a (startrow) reference that is
a value in an active cell. The macro inserts new rows and formatings. At
the end I want it to enter a value into the cell two columns to the right of
the (startrow). I am having trouble getting it to select the right cell - it
keeps selecting the (startrow) cell and changing that value.

How do I get it to move to another column with only specifying how many
columns over to move and not an exact column.

As ALWAYS, post your code for comments but

activecell.offset(,8).value="yeah"

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"BLW" wrote in message
...
I am writing a macro where it starts off with a (startrow) reference that
is
a value in an active cell. The macro inserts new rows and formatings. At
the end I want it to enter a value into the cell two columns to the right
of
the (startrow). I am having trouble getting it to select the right cell -
it
keeps selecting the (startrow) cell and changing that value.

How do I get it to move to another column with only specifying how many
columns over to move and not an exact column.

Hi BlW,

Try using the Range's Offset property.

For example, try someting like:

Dim myVal as Long

myVal =20

Range(StartCell).Offset(0,2).Value = myVal



---
Regards.
Norman


"BLW" wrote in message
...
I am writing a macro where it starts off with a (startrow) reference that
is
a value in an active cell. The macro inserts new rows and formatings. At
the end I want it to enter a value into the cell two columns to the right
of
the (startrow). I am having trouble getting it to select the right cell -
it
keeps selecting the (startrow) cell and changing that value.

How do I get it to move to another column with only specifying how many
columns over to move and not an exact column.