-
lol Well mostly because it's not always "1". Create some test data in a worksheet and then insert several empty rows above it. The start of the used range will be the first row with data.
I know, I know... "Who in their right mind would that?"
hehe I can only say I have seen it done
(It's usually the same people who think that color is great way to show if an account has been paid or not.)
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