WednesdayC
Board Regular
- Joined
- Nov 7, 2010
- Messages
- 201
- Office Version
- 2016
- Platform
- MacOS
Hi Team
Sorry to post twice in one day - I am having a hard time with a workbook!
The following formula works fine in my VBA code for output to the cell:-
wsOutput.Cells(r, 3).FormulaR1C1 = _
"=XLOOKUP(" & strID & ", " & strCell & "!RC10:R1000C10," & strCell & "!RC12:R1000C12)"
Where StrCell is the name of a different worksheet - say "TEMP_1" for now.
I cannot workout how to convert this function so that the output is to a VBA variable instead, which I need.
Please can some help me.
Thank you in advance
Wednesday
Sorry to post twice in one day - I am having a hard time with a workbook!
The following formula works fine in my VBA code for output to the cell:-
wsOutput.Cells(r, 3).FormulaR1C1 = _
"=XLOOKUP(" & strID & ", " & strCell & "!RC10:R1000C10," & strCell & "!RC12:R1000C12)"
Where StrCell is the name of a different worksheet - say "TEMP_1" for now.
I cannot workout how to convert this function so that the output is to a VBA variable instead, which I need.
Please can some help me.
Thank you in advance
Wednesday