inserting rows and columns
The UK's Number 1 for Microsoft Office Training Add this page to your favourites/bookmarksBookmark page
 
View printable version of pagePrintable version
Plus One Google
Customer: Sign in
Delegate: Sign in
Trainer: Log in

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

replyReply Wed 3 Aug 2011, 09:12Delegate Lynn said...

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?

For upcoming training course dates see: Pricing & availability

replyReply Fri 5 Aug 2011, 09:17Trainer Mark said...

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

 

Please browse our web site to find out more about
excel advanced training and other Microsoft training courses.

Excel tip:

Checking formulas with multiple operators

When dealing with formulas containing more than one operator (+, -, /, *), Excel follow standard BEDMAS order of operation rules. These rules specify the order that calculations will be performed in, regardless of how the formula reads left to right:

B = brackets
E = exponents
D = division
M = multiplication
A = addition
S = subtraction

It should be noted that multiplication and division are considered equal; as are addition and subtraction.

If you would like to check the order in which Excel is performing calculations in a formula, simply click on the cell containing the formula. Then go to Tools - Formula Auditing and select Evaluate Formula.

In the Evaluate Formula dialogue box that appears on your screen, click the Evaluate button to see how Excel calculates the formula result.

View all Excel hints and tips


Microsoft Certified Partner Accredited Training Provider: Institute of IT Training Institute of Leadership and Management - Certified Courses Security Seal verified by visa, mastercard securecard