I have a vba code which I want to run after someone expands on the workbook.. Does anyone know how I should write this?
The code is pasting formulas from one place to another.
ActiveWindow.ScrollRow = 44
ActiveWindow.ScrollRow = 66
ActiveWindow.ScrollRow = 87
Selection.PasteSpecial Paste:=xlPasteFormulas, Operation:=xlNone, _ SkipBlanks:=False, Transpose:=False