98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel VBA Training and help » Inserting rows and columns
Inserting rows and columns
Resolved · Low Priority · Version 2007
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
Training information:
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Quick Absolute Cell ReferencesWhen entering cell references in a formula you probably click the cell, or you may type in the cell reference. If you require any of the 4 variations, press the F4 key now before you press Enter to toggle around the relative and absolute entries ($signs). |