|
|
#2
09-19-2018, 12:35 PM
|
|||
|
|||
Excel doesn't automatically reset the used range until the workbook is saved.
This is untested but you might get a reset on the fly with one of these two instructions right ahead of putting in the boarders and fonts. Code:
ActiveSheet.UsedRange
X = ActiveSheet.UsedRange.Rows.Count
'Put borders around new rows.
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Template with background colors has extra blank page that will not delete. | jspinelli27 | Word | 1 | 03-11-2018 02:27 PM |
| Section Break Inserts an Extra Blank Page | Nathan8752 | Word | 3 | 12-09-2015 07:03 AM |
 Delete blank rows between the two rows that contain data
|
beginner | Excel Programming | 5 | 12-26-2014 12:29 AM |
| Extra lines in directroy when field is blank | redzan | Mail Merge | 5 | 05-23-2014 06:40 PM |
|
Count rows and add blank rows accordingly
|
Hoochtheseal | Word VBA | 1 | 01-29-2013 09:23 PM |
Windows 7 64bit 
Office 2010 64bit
Threaded Mode