Avoid counting rows/columns with formula but no values
 

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!


--
magnuc
------------------------------------------------------------------------
magnuc's Profile: http://www.excelforum.com/member.php...o&userid=37862
View this thread: http://www.excelforum.com/showthread...hreadid=574111