Hi,
Can anyone tell me why this won't work? I'm getting an error at Selection.EntireRow.Delete that says "Cannot shift cells in a filtered range or table."
Thanks!Please Login or Register to view this content.
Hi,
Can anyone tell me why this won't work? I'm getting an error at Selection.EntireRow.Delete that says "Cannot shift cells in a filtered range or table."
Thanks!Please Login or Register to view this content.
Is this being run on a sheet that is a table?
1N73LL1G3NC3 15 7H3 4B1L17Y 70 4D4P7 70 CH4NG3 - 573PH3N H4WK1NG
You don't have to add Rep if I have helped you out (but it would be nice), but please mark the thread as SOLVED if your issue is resolved.
Tom
Yes, it's a table
The way I understand it, you cannot shift cells on a filtered sheet (Table). You have to un-filter the range first.
Hi AstToTheRegionalMGR
Try this
Please 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.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks