How to get date to move down to next cell & other referances, macr

P

paintbrush

Excel 7, need the Macro to move down each day with other field changes to
keep track of work and cost per day
--
paintbrush: Range("G3").Select
ActiveCell.FormulaR1C1 = "=TODAY()"
Range("J3").Select
ActiveCell.FormulaR1C1 = "=RC[-1]*7"
Range("K3").Select
ActiveCell.FormulaR1C1 = "=R[7]C[-5]"
Range("K3").Select
Selection.Copy
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone,
SkipBlanks _
:=False, Transpose:=False
Application.CutCopyMode = False
Range("E2:E9").Select
Selection.ClearContents
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Macro 3
Macro moving with daily date 2
Macro to run on hidden sheet 4
copy paste values macro 5
Macro - very slow run in 2003 3
Filename Problem In a Macro 4
End Down a second time 1
Macro Problem 1

Top