LinkBack URL
About LinkBacks
Probably a very simple macro, but what i wish to do is fill my formula down JUST ONE ROW every time i run the macro. any help?
alternatively, the macro runs untill one of the cells in a certain colum = 10.
Probably a very simple macro, but what i wish to do is fill my formula down JUST ONE ROW every time i run the macro. any help?
alternatively, the macro runs untill one of the cells in a certain colum = 10.
Sub Macro1()
ActiveCell.Range("A1:G1").Copy
ActiveCell.Offset(1, 0).Range("A1").Select
Selection.PasteSpecial Paste:=xlFormulas, Operation:=xlNone, SkipBlanks:= _
False, Transpose:=False
Application.CutCopyMode = False
ActiveCell.Select
End Sub
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
,
Bookmarks