mbrill
09-04-2018, 05:55 AM
Hi,
One quick question, I am writing VBA code to make a dynamic array. In order to get the number of row I am using
row4 = Range("O8", Range("I7").End(xlDown)).Cells.Count - 1
This code, the question is: Is it true that it will also count the blank cell that blanked because of the formula?
I mean, in the cell I have the formula of Iferror that the error value will be blank. I wonder if there is a way to overcome this issue.
Thanks in Advance.
One quick question, I am writing VBA code to make a dynamic array. In order to get the number of row I am using
row4 = Range("O8", Range("I7").End(xlDown)).Cells.Count - 1
This code, the question is: Is it true that it will also count the blank cell that blanked because of the formula?
I mean, in the cell I have the formula of Iferror that the error value will be blank. I wonder if there is a way to overcome this issue.
Thanks in Advance.