Inserting duolicate lines with a macro

Posted by DCP on February 01, 2002 10:20 PM

I have written a macro for inserting a line at an active cell of my choice,I want to then write code that will then insert a line at the same cell reference on another sheet.

Any advice on getting VB to remember the cell address

Posted by Bill Spearshaker on February 02, 2002 12:36 AM

Dim cell As String
Sheets("Sheet1").Activate
cell = ActiveCell.Address
Sheets("Sheet2").Activate
Sheets("Sheet2").Range(cell).Select

Posted by DCP on February 02, 2002 3:18 PM

Thanks!!!