Need help writing what i thought was a SIMPLE Macro

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
sharon said:
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.
Click to expand...
 
You've posted your question in a newsgroup for ACCESS software, not EXCEL
software. I recommend that you post in an EXCEL newsgroup.
 
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.
 
Ken Snell (MVP) said:
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.
Click to expand...
 
Back
Top