Hi
I have recorded the below code, is it possible to adjust this so that instead of using "USD" the macro will reference whatever currency the user inputs into say sheet1 cell A1?
thanks
Please Login or Register to view this content.
Hi
I have recorded the below code, is it possible to adjust this so that instead of using "USD" the macro will reference whatever currency the user inputs into say sheet1 cell A1?
thanks
Please Login or Register to view this content.
Last edited by somesoldiers; 07-14-2009 at 10:51 AM.
Yes
becomesPlease Login or Register to view this content.
If you don't want the reference within the formula then create a variable to store the value and alter the formula accordingly, ie:Please Login or Register to view this content.
Please Login or Register to view this content.
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
works a treat, will use the second one in my macro, thanks a lot
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks