Hello All,
I know it's something really basic, but I'm having trouble using a range at the start of my macro. It's something to do with the way I'm referencing it I just can't seem to see the answer at the moment. I get a 'Run-time error 1004: Application-defined or object-defined error' on the final row of the code below. Any help would be very gratefully received.
Many thanks in advance for any help,
C Jones
Please Login or Register to view this content.
Last edited by CJ944; 01-12-2012 at 10:52 AM.
I think it's because you're not qualifying the Cells used in the range with a context, so you're trying to set a range on the Manugistics sheet that is a range of cells on the activesheet.
Try:
Please Login or Register to view this content.
Hi CJ944
This line of code should workPlease Login or Register to view this content.
John
If you have issues with Code I've provided, I appreciate your feedback.
In the event Code provided resolves your issue, please mark your Thread as SOLVED.
If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.
Many thanks for these solutions, they were very helpful.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks