Change value of each cell in selected range by percentage
 

Hello,

Is there an easy way to select a range of cells and change the value of each
cell by the same percentage without adding formula columns? I'd like the
code to ignore blank or non-value cells that are in the selected range. What
I have in mind is a pop-up box that shows up by clicking a macro button that
asks for the value to multiply all cells in the range by and then change
those cells. Any help would be much appreciated.

Thank you,
Aaron

Change value of each cell in selected range by percentage
 

Hi
see your post in Excel.misc
P.S.: please don't multipost

--
Regards
Frank Kabel
Frankfurt, Germany
"Aaron" schrieb im Newsbeitrag
...
Hello,

Is there an easy way to select a range of cells and change the value of
each
cell by the same percentage without adding formula columns? I'd like the
code to ignore blank or non-value cells that are in the selected range.
What
I have in mind is a pop-up box that shows up by clicking a macro button
that
asks for the value to multiply all cells in the range by and then change
those cells. Any help would be much appreciated.

Thank you,
Aaron