Range selection help!

I am using the following code to select all of the cells and then fix the font, etc.

Problem is there is sometimes non-continguous data past what it is selected as the last column....

Sample i am working on selects all of the data from A1 to U35.... but there is data in v1:y4 that is not being captured.

how do i get it to grab the data that is in v1:y4 also? If it helps, i do have column Y defined elsewhere as long

Please Login or Register  to view this content.

Cells.Select does work, but it then grabs ALL of the cells on the sheet, rather than a1:y35 (the row counts and column counts do change based on the sheet... but the last column is always called "apptcol"

Thank you so much!!!!