Counta Followup

brucew · Mar 24th, 2002, 07:04 PM

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 · Mar 24th, 2002, 07:08 PM

Bruce, did you try a dynamic range?

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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 24th, 2002, 07:04 PM	#1
brucew New Member Join Date: Mar 2002 Posts: 4	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!!

Mar 24th, 2002, 07:08 PM	#2
Dave Hawley Banned Join Date: Feb 2002 Posts: 1,582	Bruce, did you try a dynamic range? You also say you would like the first cell to be a variable, but on what condition?