Maybe a selection change event macro would have been a good idea.

Or not, now that I think about it a little more!

Biff

"T. Valko" wrote in message
...
Maybe a selection change event macro would have been a good idea.

Biff

"AKphidelt" wrote in message
...
Glad I could help!!

"MS" wrote:

YOU ARE A GOD-SEND. It worked. It has saved me hours of work.

Many many thanks
M Shroff

"AKphidelt" wrote:

Alright do this...

Go to Tools--- Macro--- Visual Basic Editor

In the Visual Basic Editor

Go to Insert--- Module

Then copy and paste this formula

Sub DoubleVal()
ActiveCell.Formula = ActiveCell.Value * 2
End Sub

Then go back to your Excel Spreadsheet

Go to Tools--- Macro--- Macros (w/ little green play button)

Then click on the Macro and go to Options
There you can place your keyboard shortcut

Let me know if this helps

"MS" wrote:

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