GaryB
09-21-2007, 03:58 PM
Hi.
I am trying to do a global change for a specific column in a workbook. I have a modificatoin to a code that was given to me that does the entire sheet.
Sub increase()
For Each cell In ActiveSheet.UsedRange
cell.Value = cell.Value * 1.05
Next cell
End Sub
But I need this to apply to only one column on the sheet. Thanks for any help with this.
Gary
I am trying to do a global change for a specific column in a workbook. I have a modificatoin to a code that was given to me that does the entire sheet.
Sub increase()
For Each cell In ActiveSheet.UsedRange
cell.Value = cell.Value * 1.05
Next cell
End Sub
But I need this to apply to only one column on the sheet. Thanks for any help with this.
Gary