Go to Column A
 

This seems like a dumb question, but...

I'm trying to write a macro that will insert a row and then go to
column A of that row before executing the rest of the code. What I've
used at the beginning is:

Selection.EntireRow.Insert
Selection.Columns("A:A").Select

This successfully inserts a row, but doesn't return to column A. How
can this be done properly?

Go to Column A
 

one way
Range("A" & Selection.Row).Select

--


Gary


wrote in message
oups.com...
This seems like a dumb question, but...

I'm trying to write a macro that will insert a row and then go to
column A of that row before executing the rest of the code. What I've
used at the beginning is:

Selection.EntireRow.Insert
Selection.Columns("A:A").Select

This successfully inserts a row, but doesn't return to column A. How
can this be done properly?

Go to Column A
 

Maybe one way:

Range("A" & ActiveCell.Row).Select

HTH,
Paul

wrote in message
oups.com...
This seems like a dumb question, but...

I'm trying to write a macro that will insert a row and then go to
column A of that row before executing the rest of the code. What I've
used at the beginning is:

Selection.EntireRow.Insert
Selection.Columns("A:A").Select

This successfully inserts a row, but doesn't return to column A. How
can this be done properly?