how to use lookup string in VBA code?

[stefanp]

Hi
I need to incorporate lookup in my code but don't know how:

Please Login or Register  to view this content.

Can anybody help?

[abousetta]

Are you trying to put a vlookup formula into a cell or putting the results of the vlookup into the cell.

For vlookup to work in vba, you need the following

vlookup is Application.Vlookup

Named Ranges have to be quantifies like this:

Please Login or Register  to view this content.

[stefanp]

I want to put a formula into the cell. The names of the ranges I defined through the Excel's Insert command. Please specify the exact line in my code if possible

[abousetta]

Try this:

Please Login or Register  to view this content.

[stefanp]

Thanks, it's working

[abousetta]

Thanks for the feedback.

Good luck.

abousetta