adding vlookup formula from a vba button press

**murray83** · 03-11-2018, 08:39 AM

this is my code for adding a new line to sheet in excel

Please Login or Register  to view this content.

but i have the following vlookup i wish to be put in to column A

Please Login or Register  to view this content.

have tried a macro and then copy and paste it into the vba but had no luck

any help most welcome and grateful, cheers

**jeffreybrown** · 03-11-2018, 08:57 AM

This seems to work perfectly fine...

Please Login or Register  to view this content.

**murray83** · 03-11-2018, 09:01 AM

Thanks a million

**jeffreybrown** · 03-11-2018, 09:48 AM

You are very welcome. Glad it worked out for you and thanks for the rep.

Re: adding vlookup formula from a vba button press