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