| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Ignore Command in VBA
I am trying to use a macro that uses this same formula for different columns
approximately 50 times- but in some of the columns there will be no constants and I want it to ignore that command if there are no constants. How can I do this? Range("I3:I10").Select Selection.SpecialCells(xlCellTypeConstants, 23).Select Selection.FormulaR1C1 = "=R2C9" |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| One command in one cell initiating another command in another cel. | Excel Worksheet Functions | |||
| command code ( GOTO command) in formula | New Users to Excel | |||
| Pivot Table Error Message - "Command Text not set for command obje | Excel Discussion (Misc queries) | |||
| Print an excel file from command line or "cron" type command ??? | Excel Programming | |||
| Excel to load COMMAND and type a Run Command? | Excel Programming | |||
Threaded Mode
