macro to divide by zero

  • Thread starter Thread starter LetMeDoIt
  • Start date Start date
L

LetMeDoIt

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
 
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
 
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
Click to expand...

Many Thanks Dave. Your help is greatly appreciated.
regards, Chris
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Divide by zero 3
divide cells using macro 2
Divide By 6
Divide by zero error 3
divide by zero error 5
Dividing by Zero value 3
Divide Value in Cell by worksheet count 2
Range or Selection Divided by "1000" 3

Back
Top