how do I get a new row to add to a column automatically?
Press Alt + F11, do insertmodule, paste it into where the cursor defaults
to
press alt + Q to close the VBE and save the workbook, then press alt + F8
and double click the macro to run it
If you are trying the event macro you need to paste it into the sheet
module, right click sheet tab and select view code and paste it there
--
Regards,
Peo Sjoblom
(No private emails please)
"mht53nyc" wrote in message
oups.com...
I've tried copying and pasting the insrtow row macro code and am unable
to get excel to recognize it. It does not show up in the macro list
whether I put in a regular workbook or personal.xls.
I also reviewed the macro overview on the website. But no luck.
Security is set to medium and I also tried low. Other macros I recorded
work.
Any suggestions. Thanks in advance.
Thanks
Mike
|