Cell Range to Length of Column.

[Trevasaurus]

Hi.
I'm using the formula to format a column. I'm trying to figure out a way to just make it run to the bottom of the spreadsheet with out going all the way to 1000+. Sometimes the data sets are that long, but sometimes they're only a dozen lines or so. Does anyone have any ideas?

Please Login or Register  to view this content.

[6StringJazzer]

I have no idea what the code is that you posted but here's how to find the last row of data. w is the worksheet. This assumes that data is in column 1.

Please Login or Register  to view this content.

[Trevasaurus]

@SixStringJazzer

Thanks a lot. That was exactly what I was looking for.