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