Hi!
I've got a large table with cells that contain formulas like this;
=IF(Sheet1!E2="";" ";Sheet!E2)
I want to find the range of this table by counting rows and columns using:
ActiveSheet.Cells(Rows.Count, "A").End(xlUp).Row
ActiveSheet.Cells(1, Columns.Count).End(xlToLeft).Column
However, these Counts include all cells that contain the above formula. I just want to count those that display a value as specified in the IF statement.
Help much appreciated!
Bookmarks