Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Shift formulas, but not formats
I am trying to insert a row that duplicates formulas, and shifts the
other rows down. This works great, changing the cells exactly as I want them: Public Sub InsertFiscalMonthData() Sheets("DATASUMMARY").Select Application.CutCopyMode = False With Rows("2:2") .Copy .Insert Shift:=xlDown End With End Sub ....EXCEPT... I want the first 12 rows to have a bold border around them. When I insert the row, the border grows with it. Is there any way to suppress the border reformatting? Thanks! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Shift formulas, but not formats
Joel,
I think you'll have to erase and reborder the region after you insert the cells. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "JoelW" wrote in message oups.com... I am trying to insert a row that duplicates formulas, and shifts the other rows down. This works great, changing the cells exactly as I want them: Public Sub InsertFiscalMonthData() Sheets("DATASUMMARY").Select Application.CutCopyMode = False With Rows("2:2") .Copy .Insert Shift:=xlDown End With End Sub ...EXCEPT... I want the first 12 rows to have a bold border around them. When I insert the row, the border grows with it. Is there any way to suppress the border reformatting? Thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Shift Differential TimeSheet Formulas | Excel Worksheet Functions | |||
Formats in formulas | Excel Discussion (Misc queries) | |||
Can formats follow formulas? | Excel Worksheet Functions | |||
What's the best way to add a row and copy formulas and formats? | Excel Discussion (Misc queries) | |||
Cell Formats in formulas | Excel Discussion (Misc queries) |