Hi, more detail on the counta question from earlier...
I would like to use counta to count the number of cells containing data in a specific row. I know to use lets say:
counta(A1:H1) to return the value, however, I would like to use variables to substitute for A1 and H1. I would like for the value to dynamically change as I change add or delete cells in the range. I have tried many different ways, but none of them work... I came close with:
application.counta(range(cells(1,2),cells(1,8)))
but it doesn't dynamically change as I input or delete data from cells. Thanks in advance for the help!!
I would like to use counta to count the number of cells containing data in a specific row. I know to use lets say:
counta(A1:H1) to return the value, however, I would like to use variables to substitute for A1 and H1. I would like for the value to dynamically change as I change add or delete cells in the range. I have tried many different ways, but none of them work... I came close with:
application.counta(range(cells(1,2),cells(1,8)))
but it doesn't dynamically change as I input or delete data from cells. Thanks in advance for the help!!