HI,
Please Login or Register to view this content.
Above is the code that I am trying to enhance so I don't have to select the actual range to delete it. I am having a hard time figuring out how to do that. In this case, where Range("PO Check") (think open ended number of records within an ever changing range) = 0 then delete that entire row. Can you help me out?
Thanks,
Hi,
Presumably (if within the With .Worksheets(strDataWorksheet) )block
Please Login or Register to view this content.
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
Thank you! That worked exactly the way I had hoped. I hope this is not a stupid question, but the command implies that the entire range is deleted. I know I previously filtered it. Is there a way to know what the rule is regarding how Excel understands the command?
Hi,
Yes you are quite correct. As written it ignores any filtering and will delete all rows in the range whether they are hidden or not.
If you want it to operate on a filtered range and only delete the rows that are visible then modify it to:
Please Login or Register to view this content.
Thank you!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks