Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi,
I have named a range and when I copy a group of rows (with this range included), I would like to update the new section to include this name in its range. For example: Row 7 to 26 is the entire group. D7 to O19 is called InputRange. When I copy and paste this group anywhere on the spreadsheet, say, Row 27 through to Row 46, I'd like the range of D27 to O39 to be included in the InputRange name. This is so that I could update the fonts and formats for everything located within InputRange. Thank-you for helping me. Aria :) *** Sent via Developersdex http://www.developersdex.com *** |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Macro to copy and paste over existing files | Excel Discussion (Misc queries) | |||
Copy and Paste 2 columns from a named range? | Excel Programming | |||
Finding a named range based on cell value and copy/paste to same sheet? | Excel Programming | |||
copy multiple worksheets of a workbook, and paste onto a Word document ( either create new doc file or paste onto an existing file.) I need this done by VBA, Excel Macro | Excel Programming | |||
copy and paste table in another existing worksheet | Excel Programming |