Hi,
I currently have a macro for a spreadsheet where it automatically adds a row (after copying a master row that is hidden) above the last line in a spreadsheet, works perfect!
Now, I want to be able to write a macro that will copy that same master row but insert it in a row that is currently the active cell, however once the macro copies the master row that is hidden i assume that it loses what the active row is. Is there a way to do this or possibly set a paramter to ask the user to enter in the row that they want to insert?
Thanks!
-J
Bookmarks