Counting Number of Rows Between Data Range

eusanpe · September 8th, 2006, 11:04 AM

Hello all:

I am trying to perform a count of rows between a data range.
I have A:2 which has "attending" in the cell. I have A:1455 that
has "officer" in it. A:2566 is the last data cell and A:2567 is empty. I would like to count from Row 3 to Row 1454, the number of rows and then from Row 1456 to Row 2566, the number of rows. No matter what I try, it fails.

Any insight would be appreciated.

Thanks,
Tony

eusanpe · September 14th, 2006, 06:58 PM

Any ideas?

jrogers · September 15th, 2006, 05:44 AM

try the following

Code:

dim longAtending as long
dim longofficer as long

'assuming there is an empty cell before "Officer"
longattending = cells(3,1).end(xldown).row - 3 

'-3 because whole list starts at A3, and -2 because one blank row then Officer 
longofficer = cells(longattending + 2,1).end(xldown).row -(longattending-3-2)

air coded so forgive any mistakes.. if there is no blank row before officer, then you need to alter the code a bit

eusanpe · September 16th, 2006, 02:03 PM

eusanpe · September 16th, 2006, 02:05 PM

Excuse my last blank post. I hit the touchpad with my thumb by accident.
It is a touchy devil.

Thank you for the advice. I will give it a try.

kotaiah · September 18th, 2006, 06:18 AM

http://www.dotxls.com/excel-security...rotected-sheet

go through this url u can find solution
do r&d def u can get

Thanks&Regards
Kotaiah.K
91+9867814180

kotaiah · September 21st, 2006, 07:17 AM

ekkadannakuttakanipistepoinakumundakodakapukuloelu pettukoranakodaka