inserting rows and columns

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel VBA Training and help » Inserting rows and columns

Inserting rows and columns

resolvedResolved · 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 courses

 

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
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.


 

Excel tip:

Quick Absolute Cell References

When 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).

Note that the F4 key outside of editing a formula is the Repeat key to repeat a previous action.

View all Excel hints and tips


Server loaded in 0.08 secs.