Run Time Error 1004 and I can't Find the Issue

**tracymickeyd** · 06-07-2013, 01:05 PM

I am trying to search for a name in a very long list and record the sick, vacation, and personal hours that are listed for each employee. Everytime I try to run this code I get a Run Time 1004 Application or Object not Defined error. Where am I going wrong?

I keep encountering the error on the first line of the Do Until Loop.

Please Login or Register  to view this content.

**BigBas** · 06-07-2013, 01:22 PM

Just at a quick glance, I don't think that .Range("xRow,1") is what you are looking for here. Think about that without the variable. If xRow = 1 for example, that would be the equivalent of saying Range("1,1").

I'm not sure exactly what the code is looking to do, but you may need a bit of code more akin to .Cells(xrow, 1) (Note: no "quotation marks")

**tracymickeyd** · 06-07-2013, 01:40 PM

Ok. So I have changed the cell locations to use Offset instead so that OffRow is an integer that offsets the cell the loop looks in by 1. I also changed the .find function to .match. I'm still receiving the same error though.