Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
I recorded a macro to input a number, move right 3 spaces, enter a number,
ect ....... when I recorded it I intended to go back and replace the numbers I put in to record with whatever I need like a question mark. Here is the macro as it is now: Sub Macro1() ' ' Macro1 Macro ' ' Keyboard Shortcut: Ctrl+a ' ActiveCell.FormulaR1C1 = "123" Range("E64").Select ActiveCell.FormulaR1C1 = "123" Range("H64").Select ActiveCell.FormulaR1C1 = "123" Range("K64").Select ActiveCell.FormulaR1C1 = "123" Range("B65").Select End Sub What do I replace the 123 with???? -- Thanks, Pat |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How can i memorise the Macro Commands? | Excel Discussion (Misc queries) | |||
How do I call MS DOS commands from Macro. | Excel Discussion (Misc queries) | |||
Macro Commands | Excel Discussion (Misc queries) | |||
macro commands | Excel Discussion (Misc queries) | |||
invisible macro commands? | Excel Worksheet Functions |