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!