-
XLD >> That is interesting.
MDMackillop >> Why aren't we just using something like this?
[VBA]Public Function GetBottomRow(ByRef ofWorksheet As Excel.Worksheet) As Long
Const lngOffset_c As Long = 1
Dim rngUsed As Excel.Range
Set rngUsed = ofWorksheet.UsedRange
GetBottomRow = rngUsed.Rows.Count + rngUsed.Row - lngOffset_c
Set rngUsed = Nothing
End Function[/VBA]
Cordially,
Aaron
Keep Our Board Clean! - Please Mark your thread "Solved" if you get an acceptable response (under thread tools).
- Enclose your code in VBA tags then it will be formatted as per the VBIDE to improve readability.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules