John Colby
jwcolby at ColbyConsulting.com
Thu Feb 2 11:00:56 CST 2006
Does anyone know how to determine how many rows of a range are actually populated with data? I have a range with Doc DocDescr Otherstuff etc 1A Some Desce Etc Etc 1Ai Other Descr Etc Etc The range is potentially up to a hundred and some rows. Doc and DocDescr will always have data in it, but the other columns might not. Is there any property of the range that says what the last occupied row is? Are there iterators for ranges, i.e. "for each row in Range" kind of thing? John W. Colby www.ColbyConsulting.com