View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Aria[_2_] Aria[_2_] is offline
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 ***