Private Sub Worksheet_Change(ByVal Target As Range)
'Declare Variables
Dim FR As Long, LR As Long
Application.EnableEvents = False
Application.ScreenUpdating = False
'Find first and last row
FR = Sheets("Output3").Cells(Rows.Count, "J").End(xlUp).Row
LR = Sheets("Output3").Cells(Rows.Count, "A").End(xlUp).Row
If FR = LR Then Exit Sub
'Autofill
Range("J" & FR & ":" & "R" & FR).AutoFill Destination:=Range("J" & FR & ":" & "R" & LR)
Application.EnableEvents = True
Application.ScreenUpdating = True
wtorek, 22 września 2015
Autofill a column next to my pasted data.
After I paste new rows into my data I need to fill down some formulas in an adjacent column.
What if I would like to make it automatic?
I came up so far with this code (in Worksheet module). I paste in my data to columns A through I and the formulas to be pulled down are in columns J through R:
Subskrybuj:
Komentarze do posta (Atom)
Brak komentarzy:
Prześlij komentarz