Range % Increase
untested, but you shouldn't have to select the range.
just
for each cell in rng.Name
cell.value = cell.value*(your%)
next cell
--
Gary
"Steve C" wrote in message
...
I want to be able to select any given range of cells in my spreadsheet as
necessary and increase the numbers already in them by a percentage that I
type into an InputBox. I'm familiar with the code for an Inputbox, but
I'm
struggling with how to tell Excel to move to each of the selected cells
and
perform the increase. The selected cells won't usually be in the same row
or
column, but rathered scattered about. Thanks!
Steve C.
|