| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
macro to divide by zero
Greetings.
I believe there is a way in VBA to have a macro divide by 1000 by specifying a range? Would it be possible for one of the Excel gurus to provide some sample code, it would be greatly appreciated. Thank you. I cannot have a formula in that cell for various reasons. regards, Chris |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
macro to divide by zero
Turn on the macro recorder
Find an empty cell (I'd use ctrl-End, then down arrow to find an empty cell) put 1000 in that cell edit|copy select the range to adjust edit|Paste special|check divide Clear that cell with 1000 in it Stop the recorder LetMeDoIt wrote: Greetings. I believe there is a way in VBA to have a macro divide by 1000 by specifying a range? Would it be possible for one of the Excel gurus to provide some sample code, it would be greatly appreciated. Thank you. I cannot have a formula in that cell for various reasons. regards, Chris -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| divide by zero | Excel Discussion (Misc queries) | |||
| Divide By help? | Excel Worksheet Functions | |||
| divide cells using macro | Excel Programming | |||
| Divide one row over other row I dont wont to divide one number | Excel Discussion (Misc queries) | |||
| Divide Expression stops in Macro when Can't divide | Excel Programming | |||
Linear Mode
