View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
MS MS is offline
external usenet poster
 
Posts: 26
Default Macro to double values in a cell

Thank u AKphidelt. But you will have to bear with me (I am a total beginner)
when I ask where do I input the code? When I create a macro, I create a
short cut key and then perform the keystrokes to record the macro.

Thank you
M Shroff

"AKphidelt" wrote:

Im kind of wondering what you mean by "Some of those Values"?

Because if you just want to create a Key Shortcut... start up a Macro and
input the code...

ActiveCell.Formula = ActiveCell.Value * 2

This way you can click on the cell you want to multiply by two and either
run the macro or use the keyboard shortcut you created.

If you want to double all the values or theres a certain criteria you need
to meet in order to double the values, I will have to know what it is to
write up the code... but its very possible.

"MS" wrote:

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