| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Long Macro
I am looking for help with a macro that will enter in every cell in a
workbook the contents I am a winner so that every row in every column is filled with these contents until Excel cannot create any more worksheets to store these contents and then at that point the macro will stop. Can you help me with that? Here is what I am starting with. Sub Macro1() Range("A1: ").Select ActiveCell.FormulaR1C1 = "I am a winner" Range("A2").Select A3:IV65535 then ActiveCell.FormulaR1C1 = "I am a winner" Range("IV65536").Select ActiveCell.FormulaR1C1 = "I am a winner" End Sub |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| http://CannotDeleteFile.net - Cannot Delete File? Try Long Path ToolFilename is too long? Computer Complaining Your Filename Is Too Long? TheLong Path Tool Can Help While most people can go about their businessblissfully unaware of the Windo | Excel Discussion (Misc queries) | |||
| Long Long Long Nested If Function | Excel Discussion (Misc queries) | |||
| Macro line too long? | Excel Programming | |||
| HELP - Too long coding for Macro | Excel Worksheet Functions | |||
| Macro too long | Excel Programming | |||
Threaded Mode
