Hallo everybody,
I need some help regarding macro-programming.
I've got an excel-formula: =VLOOKUP($C$7,'Sheet2'!U4:AA219,7,0)
...and I want to achieve the same result by macro.
Can somebody help me?
Many thanks in advance
Hallo everybody,
I need some help regarding macro-programming.
I've got an excel-formula: =VLOOKUP($C$7,'Sheet2'!U4:AA219,7,0)
...and I want to achieve the same result by macro.
Can somebody help me?
Many thanks in advance
You will need to provide more info... what is the Macro to do exactly ?
The more info you provide the more likely you are to achieve a satisfactory (and efficient) resolution.
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
Halo,
my aim is to replace that excel-funcion via a macro-code.
=VLOOKUP($C$7,'Sheet2'!U4:AA219,7,0)
i.e. I would like to give back that value, which corresponds with a certain criteria.
Can you give me an idea / example?
thanks in advance
Still not much to work with... in basic terms
you can then assign vResult variable to a cell etc if that's your intention.Please Login or Register to view this content.
Thanks DonKeyOte!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks