Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #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 David,
I have a template already setup that consists of about 20 rows or so.
Within these rows, I have named a specific range called InputRange.

Is there a way that if I keep copying and pasting these 20 rows over and
over again throughout the spreadsheet, that I could add the range to the
InputRange name?

That way, I could select all cells that are called InputRange and do any
formatting required by code Before_Save?

Thanks,
Aria :)

*** Sent via Developersdex http://www.developersdex.com ***
Reply
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 01:19 AM.

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"