Why use
[vba]
GetBottomRow = rngUsed.Rows.Count + rngUsed.Row - lngOffset_c
[/vba]
isn't rngUsed.Row always 1, so you could just use
Why use
[vba]
GetBottomRow = rngUsed.Rows.Count
[/vba]
but usedrange has the leftover bug, which spoils it anyway.
Why use
[vba]
GetBottomRow = rngUsed.Rows.Count + rngUsed.Row - lngOffset_c
[/vba]
isn't rngUsed.Row always 1, so you could just use
Why use
[vba]
GetBottomRow = rngUsed.Rows.Count
[/vba]
but usedrange has the leftover bug, which spoils it anyway.
____________________________________________
Nihil simul inventum est et perfectum
Abusus non tollit usum
Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
James Thurber
Posting Permissions
Reply With Quote