Determine Last Row And Column With Data In Sheets With Merged Cells

[chergh]

I am using the following functions to determine the highest row and column that contain data:

Please Login or Register  to view this content.

Please Login or Register  to view this content.

I've just inherited a spreadsheet which contains merged cells and it would seem these merged cells cause the above functions to fail, on the lines in bold, with a Run-time error '91' "Object variable or with block variable not set".

The real problem is the spreadsheet, I've just started a new job and the spreadsheet I've inherited is horrible, 90+ sheets filled with all sorts of crap. However redoing the spreadsheet in a sane fashion isn't really an option at the moment and I need to get on with identifying all the cells with errors and fixing them so does anyone know of a way in which to deal with merged cells when trying to determine the highest column and highest row to contain data?

[royUK]

As you have found out merged cells can be a nightmare. I think a different approach is needed, are the errors formula related?

[royUK]

You might be able to use this

Please Login or Register  to view this content.

[chergh]

Many thanks that seems to work nicely

For anyone else who is going to use it, you need to add an "end if"

[royUK]

You don't need the End If, it's one line split