go to first cell of inserted row

[Dave]

Hello all,

I have a macro that inserts a new row.(normally don't need a macro but
I have formatted cells that need to be copied etc). But after the
insertion it leaves the active row highlighted. I would like to go to
(or select) the first cell of that new active row.

What code should I insert at the end of my macro to do this?

Thanks in advance,

Dave

 

[Per Jessen]

Hi Dave

Try this:

Selection(1, 1).Select

Regards,
Per

 

[Dave]

That worked!

Thanks very much.

Dave