You're welcome. Thanks for the feedback!

Biff

"RLR" wrote in message
...
Thanks, learned something new.

"T. Valko" wrote:

Try this:

Enter your multiplier in an empty cell.
Copy that cell
Select the range of cells to multiply
Then do EditPaste SpecialMultiplyOK

Biff

"RLR" wrote in message
...
I have a spread sheet of repair cost for 34 different plan types, each
column
is a different plan type of home with repair costs for that plan type
in
each
column. I want to multiple each column by the number of homes in each
of
the
plan types. I don't want to enter a formula in each cell of the column
(total
of 225 costs per column). There must be a simpler way. Using Excel
2003.