Who is the most efficient programmer!! HElP VBA

[marvinabou7890]

Hello everyone,
I hope you all are doing well. So I have a macro which I will post below designed to change the formatting of a whole workbook as well as convert all currency constants between differetn currencies and it works GREAT ;-) ... However it is extremely inefficient and in a big work book say 20 sheets or so it runs very very slow in fact too slow fro comfort and I admit I am not the best programmer mostly the code I write is extremely inefficient. So hopefully some here can help reduce its run time. First some background this macro is meant to view 2 cells "currentcurrency" and "desiredcurrency" which contain the name of the currency your in and the currency you want. It then finds the constant you need to multiple by via Vlookup and multiples all currency formatted cells by the consatant. Also what you may find confusing is why I repeat operations the point is to say go from dollars to euros then from euros to pounds then from pounds to dollars and have it be the accurate figure as you first started with. Let me know is anyone has any questions.
Thank you,
your friend

Please Login or Register  to view this content.

[marvinabou7890]

Hey guys,
Update I made a shorter version of the macro yet it is still waaay to slow,.
Thank you,
Your friend

Please Login or Register  to view this content.

[Norie]

Any chance you could upload a sample workbook?

Click on GO ADVANCED, scroll down and click Manage Attachments.

[protonLeah]

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution.

Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.

To change a Title go to your first post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)