Hi All
Was wondering if anyone knows why I would be getting this error (Method 'Range' of objects'_worksheet' failed) when I try and run this code?
The code works fine on the first sheet (Sheet1) but not on any of the remaining sheets (Sheet7 - Sheet 13)
Please Login or Register to view this content.
Last edited by grantastley; 01-29-2013 at 04:31 AM.
With code like this you need a worksheet reference for Cells as well as Range.
Here's a couple of ways you can do that.Please Login or Register to view this content.
You'll need to add a worksheet reference for Cells wherever you have code like this.Please Login or Register to view this content.
Last edited by Norie; 01-29-2013 at 03:24 AM.
If posting code please use code tags, see here.
You need to qualify each Cells object.
i.e
Otherwise, it assumes ActiveSheet.Cells....Please Login or Register to view this content.
Thanx guys works like a treat now
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks