>I adding data to a spreadsheet and have to scan through the rows. What's the best way to determine the number of rows in an excel spreadsheet.
>
>Thanks,
>Larry

*-- Find total # of columns and rows
				lnCols = .UsedRange.columns.count
				lnFinalCols = m.lnCols
				lnRows = .UsedRange.rows.count
				lnFinalRows = m.lnRows

from Re: Saveas: do not keep incomp. functions, do not keep chang Thread #1243150 Message #1243237