Skip to Content
0
Former Member
Oct 02, 2012 at 08:37 PM

Vba code

37 Views

Hi All,

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.

Sub Macro1()

Macro1 Macro

Range("AE52:AG65").Select

Selection.Copy

ActiveWindow.ScrollRow = 44

ActiveWindow.ScrollRow = 66

ActiveWindow.ScrollRow = 87

Range("S77:U90").Select

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

End Sub

Thanks