Getting debug error when trying to do a "find"

**KA_Analyst** · 07-24-2007, 09:11 AM

Can anyone help me and show me where I am going wrong in my code:

Please Login or Register  to view this content.

What I am trying to do is look in the Backing Data sheet to see if a trainee in a certain week is there, if it is, some of the data needs to be amended, If it isn't, data needs to be inputted.

I'm getting a run-time error '1004'
Application-defined or object-defined error on the If Sheets(2).Cells(1, x) line

(You'll be glad to know that they are sending me on training next month so I will stop asking so many questions!)

Also, have I done this in the best way?

Thanks in advance

**royUK** · 07-24-2007, 09:32 AM

Don't use a Loop, it is unnecessarily slow. Your Rows count will always be over 2500 and also keep your Dims at the top for neatness. Also, you appear to be checking column 1 for both Trainee & date. Test this

Please Login or Register  to view this content.

**mudraker** · 07-24-2007, 09:34 AM

format for cell command is
cells(rownumber, column number or column letter)
your command is going from column 2 to 2500

try reversing your 1 & x

Please Login or Register  to view this content.

suggest you declare all your variables correctly & also look at adding other code to find last used row

Please Login or Register  to view this content.

Please Login or Register  to view this content.

**KA_Analyst** · 07-24-2007, 09:41 AM

Thanks Roy - but I get a run-time error '13' Type mismatch with that data on the

Please Login or Register  to view this content.

Thanks for your help mudraker as well

(Edited as had put the wrong line in)

**KA_Analyst** · 07-24-2007, 09:49 AM

Mudraker - thanks muchly, just switched the x & 1 and it now brings up the data entry form

**KA_Analyst** · 07-24-2007, 10:15 AM

Next problem

I have now got that working smoothly. However, when I have the data in there, it is recognising the name but not the date so bringing up the TraineeDetails form. If I take out the

Please Login or Register  to view this content.

then the AmendData form appears.

Thanks for your patience

**KA_Analyst** · 07-24-2007, 10:58 AM

Argh - it was something as simple as changing the '&' to 'And'

Getting debug error when trying to do a "find"

LinkBack

Thread Tools

Rate This Thread

Display

Getting debug error when trying to do a "find"

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions