Unable to get the VLookup property of the WorksheetFunction class

Maybe:

Please Login or Register  to view this content.

HTH,
Jason

Is srcRng at least 4 columns wide?

Also, what is ("A" & src) referring to?

Thanks, I changed rCell to Varient, and yea i had src as Long dont know why I said int before.

Still no joy though.

yes srcRng is currently A1:D10

("A" & src) is a cell reference src is a long variable that is counting up so that it will check each cell.

Ok, then you definitely need to use:

Please Login or Register  to view this content.

As I suggested above. I think you also need to fully qualify the range, something like:

Please Login or Register  to view this content.

Or

Please Login or Register  to view this content.

Try it out.

Oh, and since you are using srcRng solely as a Range variable, then it is fine to declare as a Range than Variant.

THANK YOU SOOOO MUCH!!!

but now I get the error Object doesn't support this property or method.

Can you post what your code is at this point?

Originally Posted by protonLeah

You said:

Show the code that sets destRng

here it is

Please Login or Register  to view this content.

I know the destination range is right because I have had the formulas paste into those cells just not the values.

Originally Posted by jasoncw

Can you post what your code is at this point?

Ok but um, just to warn you, it does alot more than just this part, and it's really ugly. this is the first time I have ever done any kind of programming ever and have been teaching myself as I go.... so I'm sorry.

Please Login or Register  to view this content.

So you can essentially ignore most of the code the problems are just the last little bit of it. (Oh and I tried it as both a Range and Variant and got the same error)

Hahahaa, yea it's a mess I know, no one wants to touch it with a 10 ft pole now. hahahaha

Don't be embarrassed about learning. Showing what you are doing will only help you here.

Some questions I have regarding the code:

1. From which workbook should srcRng come? I think you need to change this line of code:

Please Login or Register  to view this content.

2. From which workbook should NumofRows come? I think you need to change this line of code:

Please Login or Register  to view this content.

3. I think you can get rid of the Do Loop. Actually, delete from the Do Loop to the end, and replace it with (assuming I have the correct workbooks listed):

Please Login or Register  to view this content.

Hopefully that helps. It's hard to tell without actually seeing the workbook. Be sure to post back.

The first two I have the correct workbooks listed. src is source and dest is destination. The destination will have 86 rows and the source each time will have fewer rows than that, up to 85 but realistically never even close to that many.


I am gonna check out the other code you have there now. I am hesitant to take anything out that is currently working... hahaha

What I have going on now is that i get raw data from an id swiper as a csv file then i compare the swipe data and match them up deleting the duplicates that are within a few minutes of each other (like the werent sure if it registered or not) and then calculating how long they were there and rounding it to the quarter of an hour.

Now I am opening the master list of students hours, and trying to get it to compare that day's list of hours with the master list and insert a new row to put that day's hours in when it finds matching student id numbers. I'm just not able to get it to compare and insert the data.

So I just took out everything from the do loop and put in your code but at the set cell line it game me the application-defined or object-defined error message.

I dont really understand everything that is going on in your code with Cell. I want the destRng to be only the column that I had just inserted and only as many rows as there are student numbers in.

Originally Posted by protonLeah

I'm hoping to see a sample WB...

Ok so I have attached a raw data set from the swiper, and I have attached a cleaned version (I took out all the personal information and all but the last few columns of manually entered data) of the master spreadsheet. The the raw data actually comes in a csv file, but I had to convert it to upload it.

Here is another file, it is the spreadsheet, of the raw data after it has been treated with the first part of the macro, so I guess it is a spreadsheet of the treated data. This is the spreadsheet format that I am trying to compare to the master list spreadsheet I uploaded before to insert the new column in the master and then insert the total hours from column D in the treated data to the corresponding rows in the new column in the master spreadsheet.

I hope this helps.

And THANK YOU AGAIN FOR ALL THE HELP! I SINCERELY APPRECIATE IT!!!

So I guess it's just not possible?

Thanks,

This is getting really close, and I've been playing with it trying to get it to work. The problem I'm running into is that it doesn't seem to actually be running the lookup for each cell in the master list, it is only running it on the first however many rows I have in the source data from that day. So if I have 10 rows of data it will only check the first 10 rows of the master list for matches. It doesn't look like it should be doing this, but it is. Any ideas?