Quick question - is there an easy way to find which row is the last with data?
I've got a spreadsheet that's set up with (for example) 1000 rows (with
properties set for those 1000 rows). But likely only a few hundred of those will actually contain data (the rest will be blank). Is there an easy way (in VBA) to find which row has the last non-blank data? At first I thought I'd use: ActiveSheet.UsedRange.Rows.Count Unfortunately, that seems to be returning my 1000 rows every time (even if the "real" data is only up to row 200). I'd rather not build a for...next loop to find it, as that'd be horrifically slow. Any ideas? Thanks! -Scott |
Quick question - is there an easy way to find which row is thelast with data?
Go to
http://groups.google.com/advanced_group_search and search for Last cell in range Alan Beban Scott Lyon wrote: I've got a spreadsheet that's set up with (for example) 1000 rows (with properties set for those 1000 rows). But likely only a few hundred of those will actually contain data (the rest will be blank). Is there an easy way (in VBA) to find which row has the last non-blank data? At first I thought I'd use: ActiveSheet.UsedRange.Rows.Count Unfortunately, that seems to be returning my 1000 rows every time (even if the "real" data is only up to row 200). I'd rather not build a for...next loop to find it, as that'd be horrifically slow. Any ideas? Thanks! -Scott |
All times are GMT +1. The time now is 04:17 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com