Paste Special generating Error Type 1004

[Ochimus]

Following code copies all the data in 'Schedsheet' range A4 - EN(lastrow), finds the cell in 'DBSheet' Col A matching A4 on the 'SchedSheet', and defines that cell as "Found".

Should then paste the copied data to that FOUND cell.

But it throws Error 1004 (Method 'Range of object' _Worksheet failed), and I can't see why?

Please Login or Register  to view this content.

Hopefully someone can see the error?

All solutions, pointers or alternatives welcomed

Ochimus

[Arkadi]

Hi

DBSheet.Range("FOUND"). suggests there is a named range, called FOUND. Instead, FOUND is just a range so:

replace:

Please Login or Register  to view this content.

with:

Please Login or Register  to view this content.

Better yet, since technically the item might not be found, FOUND could still be nothing so I'd actually put:

Please Login or Register  to view this content.

[Ochimus]

Arkadi,

Many thanks for prompt solution.

Having "Dim"'d 'FOUND' as a Range, I always assumed it would be treated as a "Named Range", so that's a key lesson learned!

Now marking this as Solved

Ochimus

[Arkadi]

Glad I could help Ochimus It is always great learning something new.

Thanks for the rep, and marking the thread as solved.