Hello
Looking for VBA code to delete entire rows for the rows between Table1 and named range "Del"
Hello
Looking for VBA code to delete entire rows for the rows between Table1 and named range "Del"
Last edited by Undo; 08-07-2022 at 08:48 AM.
cannot locate range "Del" Need a better explanation and example.
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
Try this code.
NOTE: This will change the "Del" range depending on how many rows are deleted.Please Login or Register to view this content.
Last edited by kvsrinivasamurthy; 08-07-2022 at 09:32 AM.
Pl note
Array formula should be confirmed with Ctrl+Shift+Enter keys together.
If answere is satisfactory press * to add reputation.
While runing the code and there is no rows between the table and named range, named range will be deleted
maybe if we select the named range and offset -1 row, then if selected range is in table1 range then exit sub, else delete entire row, and loop until u get in table1 range
I think this may work
your code also work, but will face problem if there no rows between the two ranges
Revised code:
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks