need to change a whole column by 10 %
Posted by Dave Hyndman on February 02, 2002 3:51 PM
Can I increase a column of currency by a percentage
with a formula or does the sum have to go into a new column
Posted by Chris D on February 02, 2002 3:56 PM
type 1.1 in a spare cell
copy
right click desired column
paste special
multiply
will multiply the whole column by 1.1 (ie 110%, ie adding 10%)
hth
Chris
Posted by Jacob on February 02, 2002 4:41 PM
Or
Hi
Try this in VB
Sub ChangeWidth()
Columns("B:B").ColumnWidth = Columns("B:B").ColumnWidth + .1* Columns("B:B").ColumnWidth
End Sub
HTH
Jacob
