Vlookup contained within VBA code.

[galvinpaddy]

Hello happy campers,

I have the following code

Please Login or Register  to view this content.

When i run the code i have a 'Run-time error '424: Object required'
Highlighting the following line in yellow

Please Login or Register  to view this content.

Could someone pelase let me know what im doing wrong?

kind regards, galvinpaddy

[JapanDave]

Post a sample workbook.

[galvinpaddy]

Hello,

Thanks, workbook attached, took longer as had to remove personal details.

In the VBA screen i have added the info to show where i wanted the vlookup, but by all means please correct me

Regads, galvinpaddy

[JapanDave]

What are you trying to lookup? And I want to clean the rest of you code up, so what are you trying to achieve?

[galvinpaddy]

The range is N:O on sheet 2, and by all means, if you can clean up my code it would be great!! would be good to learn how to clean it up.
thanks

[JapanDave]

What are you trying to do. The code does nothing at present. And what are you trying to lookup?

[galvinpaddy]

Hi,
Without the vlookup part in the code, it works fine,
Sheet2 - contains the numbers 1-4(column N) and the type of absence (column O).
On sheet 2 after the original codes pastes the values, i then want the code to lookup the value in column E and return the value matching that into Column F.
regard.

[jason.b75]

Please refer to your other thread.

Also refer to the forum rules with regard to duplicate threads. There is nothing more annoying than wasting time on a thread that has been resolved elsewhere.

[galvinpaddy]

hi, apologies, i did not intend to duplicate posts.
as you were good enough to help i didnt exactly want to say "instead of doing that here, please go there", although you are correct with your statement.

I appreciate the help from all so far.