•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Deleting an entire row from a different workbook
Our take
Struggling to delete an entire row from a different workbook, especially when dealing with vertically merged cells, can be frustrating. You might feel like your code is on track until it fails at the last hurdle. Fortunately, it's possible to streamline this process effectively. In this guide, we'll explore the steps needed to remove those rows based on specific cell values, even when working across workbooks. Stick around to discover practical solutions that will transform your approach to managing your spreadsheets.
I thought I got my code in order. But when I tried it, it failed miserably.
My question is, how do I delete an entire row with a given cell value from a different workbook.
The catch is, the rows have vertically merged cells.
I tried approaching it via select cells but to no avail. I can't select a row from a different workbook
[link] [comments]
Read on the original site
Open the publisher's page for the full experience