Summary Of Maximum Rows Used Across Each Sheet In A Workbook

[Rick Rothstein]

I filled entire column B with some value with all the other columns empty.

Hmm, I never thought about that possibility (don't know why, I just didn't). Unfortunately, it is back to the drawing boards for me since a completely filled columns screws up two parts of the method I used.