| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
how to run a macro only if a cell contains a certain value
I have written a macro to divide a large spreadsheet into 5 smaller ones based on single character in one of the columns. One of the letters only appears on every other report which causes the macro to crash if it doesn't find the letter.
Is there any way to have Macro5 run only if the letter K is found in a cell in a specified column? I have tried and tried but cannot figure out how to get the macro to read a character in the cell - only a number. Any help would be greatly appreciated!!!!! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro to transfer contents of 'Selected' cell to alternate cell. | Excel Worksheet Functions | |||
| 'IF' Macro to insert cell contents to alternate cell if cell not e | Excel Worksheet Functions | |||
| Macro to Insert Current Date into cell - Macro to "Save As" | Excel Worksheet Functions | |||
| using a cell value to control a counter inside a macro and displaying macro value | Excel Worksheet Functions | |||
| Question: Cell formula or macro to write result of one cell to another cell | Excel Programming | |||
![KJ[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
