Technowolf
Board Regular
- Joined
- Aug 28, 2014
- Messages
- 181
Hello! I'm looking for a better way to do this. Here's what I've got:
I have it just selecting everything right now since it can be anywhere from 50 rows to 250+ rows of data depending on the day and I run this a lot. It works fine but naturally it leaves me with a a ton of zeros after the last row of data entered to row 500. Rather than selecting G2:G500, how do I select just G2:Last cell with data?
Hopefully that made sense...
Code:
Range("G2:G500").Select
For Each xCell In Selection
xCell.Value = CDec(xCell.Value)
Next xCell
I have it just selecting everything right now since it can be anywhere from 50 rows to 250+ rows of data depending on the day and I run this a lot. It works fine but naturally it leaves me with a a ton of zeros after the last row of data entered to row 500. Rather than selecting G2:G500, how do I select just G2:Last cell with data?
Hopefully that made sense...