Lynn has attended:
Excel VBA Intro Intermediate course
Inserting rows and columns
When I record a macro to insert columns it seems to sometimes insert 2 rows even though I have only asked for one. I insert say in column B which works fine, then insert one column after column E and end up with 2. Any ideas?
RE: Inserting rows and columns
Hello Lynn,
Thank you for your question regarding columns and rows.
I have tried to replicate your problem and cannot get Excel to do what yours does! Can you please give an exact description of what your doing during the recording process.
I have never heard of this problem before, so if you give me more detail then I'll look deeper at the issue.
If you require further assistance, please reply to this post. Or perhaps you have another Microsoft Office question?
Have a great day.
Regards,
Mark
Microsoft Office Specialist Trainer
