ExcelBanter - spreadsheet commands in macro

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - spreadsheet commands in macro (https://www.excelbanter.com/excel-programming/306695-spreadsheet-commands-macro.html)

Glen Mettler[_3_]

spreadsheet commands in macro

I want to use Vlookup in a macro. Is that possible?

Thanks,
Glen

Chip Pearson

spreadsheet commands in macro

Glen,

Yes, you can use worksheet functions in VBA code. You access them
via Application.WorksheetFunction. E.g.

Res = Application.WorksheetFunction.VLookUp(....)

--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

"Glen Mettler" wrote in
message ...
I want to use Vlookup in a macro. Is that possible?

Thanks,
Glen

Frank Kabel

spreadsheet commands in macro

Hi
application.worksheetfunction.vlookup(...)

--
Regards
Frank Kabel
Frankfurt, Germany

Glen Mettler wrote:
I want to use Vlookup in a macro. Is that possible?

Thanks,
Glen

All times are GMT +1. The time now is 07:41 PM.