Microsoft Office Forums - View Single Post - [Solved] Macro not Performing Formula Update as Expected

Thread: [Solved] Macro not Performing Formula Update as Expected

View Single Post

Old

06-25-2014, 10:58 AM

charlesdh

charlesdh is offline

charlesdh uses Windows 7 32bit

Windows 7 32bit charlesdh uses Office 2010 32bit

charlesdh uses Office 2010 32bit

Office 2010 32bit

Expert

Join Date: Apr 2014

Location: Mississippi

Posts: 382

charlesdh is on a distinguished road

Default

Hi,

Change all of your pastspecials

Code:

Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
        :=False, Transpose:=False

to

Code:

Selection.PasteSpecial Paste:=xlPasteAll

If you use "PasteValue" it will just place the value and not the formula.

Reply With Quote