| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macro subprocedure
Hi All
Could anyone please help me to write a subprocedure wich replace the cell with the error note #VALUE! with the comment "No Info" I have the below If ActiveCell.Value = numero (I don' know how to tell the computer that any number is valid) Then ActiveCell.Offset(1, 0).Select Else ActiveCell.Value = "No Info" End If Thanks, Orquidea |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| need help to update macro to office 2007 macro enabled workbook | Excel Discussion (Misc queries) | |||
| Macro Help Needed - Excel 2007 - Print Macro with Auto Sort | Excel Worksheet Functions | |||
| My excel macro recorder no longer shows up when recording macro | Excel Discussion (Misc queries) | |||
| Hyperlink to a subprocedure in an other workbook | Excel Worksheet Functions | |||
| Macro needed to Paste Values and prevent Macro operation | Excel Discussion (Misc queries) | |||
Threaded Mode
