Ark68
Well-known Member
- Joined
- Mar 23, 2004
- Messages
- 4,564
- Office Version
- 365
- 2016
- Platform
- Windows
I am using this code to delete a series (rtdel) of rows starting at the row defined by fma_lorow+1
In testing, cnt_row = 6 (delete 6 rows), and fma_lorow = 39. So looking to delete rows fma_low+1 (40) to fma_low +1 + cnt_row (45).
I am getting a "Type Mismatch error with the line in red. I suspect my approach to doing what I want to do is wrong? I'm open to support.
In testing, cnt_row = 6 (delete 6 rows), and fma_lorow = 39. So looking to delete rows fma_low+1 (40) to fma_low +1 + cnt_row (45).
Rich (BB code):
cnt_row = fma_hirow - fma_lorow
If cnt_row > dflt_row Then 'delete rows
rtdel = cnt_row - dflt_row
.Rows("fma_lorow+1:fma_lorow+1+rtdel").EntireRow.Delete
Else
...
I am getting a "Type Mismatch error with the line in red. I suspect my approach to doing what I want to do is wrong? I'm open to support.