I am very new to VBA which seems a lot more complicated than the old XL Macro Language so I will need to do a lot more studying to understand your advice.
I am very grateful that you have pointed me in the right direction for this study & I will do as you suggest
Thanks again
Tony
tonyP
Last Activity: Jan 17 '08, 02:16 PM
Joined: Oct 4 '07
Location:
-
I would still prefer a Macro that I can share with collegues. The original xlm that I wrote allowed you to match data contained in different workbooks, I understand that as a functionn this would be difficult to achieve. However, your suggestion has given me another option & I will read up about Public Functions.
I am very grateful for this lead & your quick response.
Thank you very much.
TonyLeave a comment:
-
Converting XLM macro into VBA
I am very Experiences in Excel but very new to VBA & I am struggling to convert an old XLM macro into Visual Basic
The Macro helps you to compile the INDEX/MATCH formula (very similar to Vlookup but much more adaptable.
The FORMULA is =INDEX(Column(s ) where data to be selected is held,MATCH(cell containing info to be matched,column where matching data is held,0),1)
The XLM code used =
...
No activity results to display
Leave a comment: