200+ Video Lessons
50+ Hours of Video
200+ Excel Guides
Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)
I am using the
Range("U2"), Range("U2").End(xlDown)).NumberFormat = "#,##0"to format column U in a 15K row report. It works on everything except for 4 non-consecutive rows. Row 2788, Row 2792, Row 5480, Row 11916
The numbers not formatted are 12840, 3054, 1455, and 3295. All of the other rows containing a number in the thousands are formatted correctly. There are numerous blank rows.
I am at a loss as to why the code does not work for the whole column.
Hi Rappj and welcome to the Forum.
Try this instead:
Range("U2:U" & Range("U" & Rows.Count).End(xlUp).Row).NumberFormat = "#,##0"(Where the bit in bold finds the last used row in column U)
It should format all the used cells (and any blank or non-consecutive cells in between). If the column was previously formatted as General, cells below the last row will remain General.
If instead you want to format the entire column, you can use:
Columns("U").NumberFormat = "#,##0Hope this fixes your problem. If so, please be sure to mark this Answer as Selected.