Counta Followup

[brucew]

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!!

 

[Dave Hawley]

Bruce, did you try a dynamic range?

You also say you would like the first cell to be a variable, but on what condition?