error using variable over multiple worksheets

[RichTea88]

Good Afternoon All,

Getting an error on the highlighted line, it works for the first sheet it scans through but once it gets to an encounter on the 4th sheet its kicking up a fuss. Any ideas would be much appreciated.

Please Login or Register  to view this content.

Thanks,

R

[Andy Pope]

you should really fully qualify references

Please Login or Register  to view this content.

As that code is within the required WITH statement you should be able to use

Please Login or Register  to view this content.

[RichTea88]

Cheers Andy,

Whats odd is that I originally had something along those lines but the range was still pulling values through form the first sheet and causing errors.

Just replaces the line and its working perfectly now though!

Thank you kindly chap!

R