Atholl
Active Member
- Joined
- May 19, 2002
- Messages
- 436
Hi all,
I have a sheet containing data in the column range B5:L??. The data is automatically pasted in by VBA as values only. Trouble is the amount of rows can vary from a one to a maximum of 12,000. I have formatted the entire range B5:L12000 which adds a big chunk to the file size and also causes the workbook to be very slow on opening.
I need to find a way I can format only the cells that are needed and not the full 12,000 rows?
I tried using the Selection.End(xlDown) and Selection.End(xlToRight) commands, but the problem is that the data in column B and the first Row (5) may not necessarily be continuous all the way down and across, although column C would always be continuous to the end row.
Does that make any sense?!
Atholl
I have a sheet containing data in the column range B5:L??. The data is automatically pasted in by VBA as values only. Trouble is the amount of rows can vary from a one to a maximum of 12,000. I have formatted the entire range B5:L12000 which adds a big chunk to the file size and also causes the workbook to be very slow on opening.
I need to find a way I can format only the cells that are needed and not the full 12,000 rows?
I tried using the Selection.End(xlDown) and Selection.End(xlToRight) commands, but the problem is that the data in column B and the first Row (5) may not necessarily be continuous all the way down and across, although column C would always be continuous to the end row.
Does that make any sense?!
Atholl