Using declared range in .SetRange
Afternoon all,
I've got a range declared using the following:
...and now I want to use that named range to limit how far a sort can be applied.
Please Login or Register to view this content.
The sort code I'm using is:
...which gives me a Run-time error '1004': Method 'Range' of object '_Global' failedPlease Login or Register to view this content.
Can someone tell me where I'm going wrong here please?
Many thanks as always,
Peter
Hi. MisterPan,
instead of
use eitherPlease Login or Register to view this content.
orPlease Login or Register to view this content.
Please Login or Register to view this content.Ciao,Please Login or Register to view this content.
Holger
Use Code-Tags for showing your code: [code] Your Code here [/code]
Please mark your question Solved if there has been offered a solution that works fine for you
Late entry:
Please Login or Register to view this content.
Regards, TMS
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks