LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 34
Default After Copy and Paste, Add to an Existing Named Range

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Macro to copy and paste over existing files Cam Excel Discussion (Misc queries) 1 July 1st 09 08:37 PM
Copy and Paste 2 columns from a named range? Simon Lloyd[_735_] Excel Programming 2 May 28th 06 08:10 PM
Finding a named range based on cell value and copy/paste to same sheet? Simon Lloyd[_715_] Excel Programming 1 May 11th 06 11:25 PM
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 Steven Excel Programming 1 October 17th 05 08:56 AM
copy and paste table in another existing worksheet Andreas Aust Excel Programming 2 August 25th 04 01:22 AM


All times are GMT +1. The time now is 12:18 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"