Thread: Go to Column A
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] ian.montano@gmail.com is offline
external usenet poster
 
Posts: 3
Default 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?