| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macro to clear contents and put an X
I can get a macro to work on one row but I want to be able to use on any row.
Here is what i have so far: Range("E19:N19").Select Selection.ClearContents Range("P19").Select ActiveCell.FormulaR1C1 = "X" Range("P20").Select I want to be able to be on any row, whether it be Row 19 or Row 700 and be able to run this. The column will stay the same. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Clear Contents | Excel Discussion (Misc queries) | |||
| Macro to clear contents of unprotected cells AND drop down boxes | Excel Discussion (Misc queries) | |||
| HOW DO I PROTECT VALUES WHEN CREATING CLEAR CONTENTS MACRO? | Excel Discussion (Misc queries) | |||
| Clear Contents Macro | Excel Worksheet Functions | |||
| Clear Contents But Not Formula | Excel Discussion (Misc queries) | |||
Threaded Mode
