Getting --unable to get the findnext property of the range class ERROR

[DeanJS]

Hey All,

I am new to the forum - dabble in VBA

I am receiving the following ERROR --unable to get the findnext property of the range class

My problem is this findnext has worked in this macro no problem till I get 2500 odd records into the file.

i have included my macro i Hope I have made the FINDNEXT bold lol

Sorry for how bad it is lol


Please if any 1 can see why please help me

thanks Dean

Please Login or Register  to view this content.

[StephenR]

The FindNext range is not identical to the original Find range and I think that will cause an error if one of your found values is in the missing range.

[DeanJS]

Thanks Stephen

that got it working

worked out that record was out side the range of the find next