1004 Error with Set Range

[Steve_Courts]

Hi,

I've written a macro, but the following is giving me an error. I'm only just starting out with VBA, so some help/explanation would be great! Have just included an excerpt from the beginning of the code.

Please Login or Register  to view this content.

It's the last two Set lines that are giving me the error... Any ideas?
Cheers
Steve

[JBeaucaire]

The problem may lie in the data itself. Can you post the SUMMARY sheet you're trying to run this on?

Also, what's the goal of this macro? You may be setting more "ranges" than you need to. It looks like you're getting ready to copy the range of data in A3:A??? to B3:B??? Can you explain what your goal is?

Click GO ADVANCED and use the paperclip icon to post up a desensitized copy of your workbook.

[royUK]

Have you got a sheet named Summary?

Is there data in at least A3 of that sheet?

This ia better way to write the code, note by using the With Statement & qualifying the references the code will be using Sheet summary,

Please Login or Register  to view this content.

Try this code

Please Login or Register  to view this content.

[Steve_Courts]

Hi All,

There was data in at least A3 of the sheet as suggested by Roy.

This was part of a larger macro, I set something early on that clears the summary page to prepare for re-loading the data, and it seemed to work fine!

Thanks for the help.
Steve