Solved how to find block boundaries with spaces included

January 12, 2015 at 03:31:56
Specs: Windows 7, core i5 / 8Mb RAM
I frequently have to find the boundaries of a block of data in an Excel s/sheet within an Excel macro. Several methods exist.
I now have a situation where the block of data may have blank row or rows within the block and the number of rows in the block may change - e.g. rows 14, 15 and 21 may be deleted and row 41 added to previous 40 row block. I now need to return information indicating 41 rows in the block (even though some are blank)
Any pointers to achieving this?

See More: how to find block boundaries with spaces included

Report •

#1
January 12, 2015 at 04:32:40
✔ Best Answer

Report •

#2
January 12, 2015 at 05:12:17
Yes - that looks interesting. Not a tool I've used very much so will have a play around. Many thanks

Report •
Related Solutions


Ask Question