View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
L. Howard Kittle L. Howard Kittle is offline
external usenet poster
 
Posts: 698
Default 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