Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Ranges, adding a column to a named print range then saving the file
By going though the messages i leaned how to add the column i need: Set
tRange = Range("Print_Area").Resize(, 1 + Range("Print_Area").Columns.Count), however how do i save this back to the speadsheet? i can't seem to figure that out. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Ranges, adding a column to a named print range then saving the file
With Worksheets("Sheet1")
with .range("Print_Area") .resize(,.columns.count + 1).name = "'" & .parent.name & "'!Print_Area" end with end with This worked ok for me as long as there was that range named Print_Area. wrote: By going though the messages i leaned how to add the column i need: Set tRange = Range("Print_Area").Resize(, 1 + Range("Print_Area").Columns.Count), however how do i save this back to the speadsheet? i can't seem to figure that out. -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Join non-contiguous ranges into one range via named range? | Excel Discussion (Misc queries) | |||
Dynamic named ranges not saving | Excel Programming | |||
Like 123, allow named ranges, and print named ranges | Excel Discussion (Misc queries) | |||
adding named ranges | New Users to Excel | |||
Macro (Print) - Calling Named Ranges | Excel Discussion (Misc queries) |