Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I avoid copying data from hidden rows/columns? | Excel Discussion (Misc queries) | |||
Counting Values Across Columns | Setting up and Configuration of Excel | |||
counting rows with same values for multiple values | New Users to Excel | |||
Counting rows, then counting values. | Excel Discussion (Misc queries) | |||
Counting Rows Then Counting Values in Columns | Excel Programming |