[b22smith]

I am programming in VBA how to insert a row into a spreadsheet, then adjusts formulas accordingly above and below the inserted row, and copies a range into the blank row.

The only way I can make it work is to make sure the user starts in a cell in the the far left Column A. However, if you try to pick a cell in somewhere to the right of column A, then it causes problems with reference errors for the equations.

What I want to do is after inserting the blank row, I want the macro to return to the far left column A position, then proceed with the remaining macro instructions. Can this be done? Is there a macro equivalent to the "Home" key on the keyboard?

Brad

[Advertisements]

Brad,
Try the following

Range("A1").Select



regards
dsm

[dsm]

Brad,
Try the following

Range("A1").Select



regards
dsm