Thanks for the rep' added !
Originally Posted by
roose
error "Invalid use of Me keyword".
Your bad : no issue if you have followed the dark red direction just before the code !
But well done as you understand what Me refers to …
Originally Posted by
roose
you are calculating the number of cells that are not blank, is that correct?
Almost yes : as you can check on Excel side with its help of the SUBTOTAL worksheet function
this worksheet formula counts the visible cells not blank …
Originally Posted by
roose
Why does the C needs to be equated to zero, not just add zero instead?
No, C does not need to be equal to zero, it's just a condition like If C = 0 Then R = R - 1
as according to your attachment no need to insert a row if the table has no row.
Without this codeline, instead of keeping 2 blank rows between the tables
another blank row is added according to your attachment …
Bookmarks