| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to get date to move down to next cell & other referances, macr
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Display "Last updated date" for the Workbook (without using a macr | Excel Worksheet Functions | |||
| Formular for refrencing two referances | Excel Worksheet Functions | |||
| how to move data from a cell to another one without using any macr | Excel Worksheet Functions | |||
| Adjusting Referances | Excel Worksheet Functions | |||
| How do I convince the cursor to select a given cell when in a macr | Excel Discussion (Misc queries) | |||
Hybrid Mode
