|
|
#6
12-22-2016, 07:22 PM
|
|||
|
|||
Looks to me like you may have missed the red part of this line
Code:
.Range(Cells(EndRow + 1, StrtCol), Cells(EndRow + 1, EndCol + 1)).Interior.Color = _
.Cells(EndRow - 1, StrtCol).DisplayFormat.Interior.Color
It would be far easier to be sure if you would post the sheet with the code rather than a picture of the sheet and no code. (This isn't MrE. Excel files can be posted here.) On second thought that's not right. The new row being added is not always immediately below "the table". I'll have to adjust for that.... I'll be back shortly. Last edited by NoSparks; 12-22-2016 at 07:29 PM. Reason: second thoughts 
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| proper | snoforlife | Excel Programming | 0 | 01-26-2016 02:16 PM |
 Hyperlinks Not Linking to Proper Sections of Doc
|
MoiraB | Word | 2 | 08-26-2015 07:13 PM |
| Proper Text Format | sufian,naeem | Excel | 1 | 05-05-2014 05:59 AM |
|
Unable to change font colors from theme colors
|
choy | Word | 3 | 08-01-2012 09:12 PM |
|
Proper Excel Table of Contents (ToC)
|
judicial85 | Excel | 1 | 10-23-2011 01:35 PM |
Windows 7 64bit 
Office 2010 64bit
Threaded Mode