Hi,
Is anyone able to convert the following into VBA code?
I'm lost!Please Login or Register to view this content.
Regards!
Hi,
Is anyone able to convert the following into VBA code?
I'm lost!Please Login or Register to view this content.
Regards!
Last edited by Alternsti; 07-14-2010 at 07:43 AM.
Hello Alternsti,
I hope I have all the parentheses correct in this. Here is the VBA version...
Please Login or Register to view this content.
Sincerely,
Leith Ross
Remember To Do the Following....
1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.2. Thank those who have helped you by clicking the Star below the post.3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
Hello Leith Ross,
Thanks for your time. I've done a macro with your code but I'm always having "Run-Time error '9': Subscript out of of range". Can you look at my code and give me some hints?
Best Regards!Please Login or Register to view this content.
You didn't actually open the workbook specified in the GetOpenFilename call...
Remember what the dormouse said
Feed your head
Hello romperstomper,
Thanks for your time too. I'va resolved the error code now but I got nothing as result (shall be a string value from X (see below):
Best Regards!Please Login or Register to view this content.
If you got no error then a match was found, but it appears one of your match ranges is incorrect:
Please Login or Register to view this content.
Still no string coming from X.
Please Login or Register to view this content.
Seems like a data issue then. If you are not getting a run time error, then the code is finding a match and returning a value.
is this right?
Match(W12 ?
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
romperstomper, thanks for your patience. I did a test using Workbook_Activate and it's working (see below)
Please Login or Register to view this content.
Good spot - I assumed W12 was a variable.
Please Login or Register to view this content.
Thanks to all...It's working. Final result is below.
Best Regards!Please Login or Register to view this content.
See you next time!
[SOLVED]
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks