a few are contigous but others are here and there.

"Wondering" wrote:

Are you multiplying a bunch of numbers one after another down a column or
just here and there in the spreadsheet?

"sharon" wrote in message
...
Thanks, I'll try this, too as soon as i figure out what a module is and
where
they live (not being sarcastic, just don't know). Peo's solution worked
as
well, but obliterated the original number (i.e. no formula to see what i
did)
Thanks Peo that made short work of many many manual edifications.


"Wondering" wrote:

You could put the following code in a module and assign it a shortcut key
such as Ctrl+m then select a cell and press Ctrl+m. If the cell is
numeric,
the code multiplies the cell by 9.

Sub Multiply_by_9()
If IsNumeric(ActiveCell) Then
ActiveCell = ActiveCell * 9
End If
End Sub

"sharon" wrote in message
...
I have a cell i want to multiply by 9. I have a lot of them. So I'd like
a
macro with a shortcut to do it for me. For Example: cell c62 has a
value
of
177. I want it to have a value of 1593. Instead of manually editing
each
cell (F2, home,=,end,*,9,enter) each and every time, a macro here would
save
lots of time. Unfortunately when I write the macro, it works on the
first
cell I wrote it on, but when I execute it on other cells it gives me
the
same
value of 1593 for each cell i try it on. It just inserts the formula
=177*9
and the value 1593. Can anyone please help?? I'm stuck and it would
sure
help. Thanks.