Need help writing what i thought was a SIMPLE Macro

[Guest]

I have a cell i want to multiply by 9. I have a lot of them. So I'd like a
macro with a shortcut to do it for me. For Example: cell c62 has a value of
177. I want it to have a value of 1593. Instead of manually editing each
cell (F2, home,=,end,*,9,enter) each and every time, a macro here would save
lots of time. Unfortunately when I write the macro, it works on the first
cell I wrote it on, but when I execute it on other cells it gives me the same
value of 1593 for each cell i try it on. It just inserts the formula =177*9
and the value 1593. Can anyone please help?? I'm stuck and it would sure
help. Thanks.

 

[Guest]

I have a cell i want to multiply by 9. I have a lot of them. So I'd like a
macro with a shortcut to do it for me. For Example: cell c62 has a value of
177. I want it to have a value of 1593. Instead of manually editing each
cell (F2, home,=,end,*,9,enter) each and every time, a macro here would save
lots of time. Unfortunately when I write the macro, it works on the first
cell I wrote it on, but when I execute it on other cells it gives me the same
value of 1593 for each cell i try it on. It just inserts the formula =177*9
and the value 1593. Can anyone please help?? I'm stuck and it would sure
help. Thanks.

 

[Ken Snell \(MVP\)]

You've posted your question in a newsgroup for ACCESS software, not EXCEL
software. I recommend that you post in an EXCEL newsgroup.

 

[Steve Schapel]

Sharon,

The focus of this newsgroup is Macros in Microsoft Access, the database
product. You will have a better chance of a good answer if you re-post
to an Excel-related newsgroup.

 

[Guest]

You've posted your question in a newsgroup for ACCESS software, not EXCEL
software. I recommend that you post in an EXCEL newsgroup.

--

Ken Snell
<MS ACCESS MVP>





I know. Thanks. i did post it in the excel area.