Go to Column A

  • Thread starter Thread starter ian.montano
  • Start date Start date
I

ian.montano

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?
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Go To Column A 6
Changes in How Code Acts After Upgrade of Excel 2
Insert Row also adds formulas and moves cursor 2
Mid column sum formulas with varied ranges to sum 17
Macro to Insert a row and copy Formulae 3
Conditional Row insertion problem 4
Macro to Group andor Ungroup rows and/or columns 3
Auto Fill Equations in VBA 5

Back
Top