Macro to double values in a cell
Give this a go.
Select the cells you want to double and run this macro.
Sub DoubleIt()
Dim cell As Range
For Each cell In Selection
cell.Value = cell.Value + cell.Value
Next
End Sub
HTH
Regards,
Howard
"MS" wrote in message
...
I have a worksheet with values in one column. I need to go back to some of
those values and in the same cell, double them. Can anyone please help me
with a macro to do that? I tried it but when I run the macro I get the
same
value as the one in the cell where the macro was made. I realise this has
to
do with absolute and constant values but am not competent enough to
correct
my macro.
Any help will be very appreciated. Many thanks
M Shroff
Canada
|