•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
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]
Want to read more?
Check out the full article on the original site
Tagged with
#row zero
#rows.com
#Excel compatibility
#Excel alternatives for data analysis
#financial modeling with spreadsheets
#no-code spreadsheet solutions
#delete row
#workbook
#Excel
#cell value
#different workbook
#vertically merged cells
#select cells
#merge cells
#code
#row selection
#failed
#approaching
#data manipulation
#automation