LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
ben ben is offline
external usenet poster
 
Posts: 232
Default copying and pasting Cell reference names

I have a macro that copies a named range of data and pastes it to a blank
workbook. the copied data has merged cells that naturaully merges the blank
workbook cells appropriately once pasted. The original data has MANY named
ranges. I do not want any named ranges to transfer with the copy & paste,
however once specific name copies over and ONLY ONE. I can not figure out why
this one named reference transfers while the rest do not. Any suggestions as
to why this does so?
--
When you lose your mind, you free your life.
 
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
Losing cell content when copying and pasting tomprochaska New Users to Excel 6 October 26th 08 07:14 PM
Copying cell contents from many cells and pasting into one cell MDN Excel Discussion (Misc queries) 7 December 10th 07 08:56 PM
prevent changes to cell references when copying and pasting MiChaos Excel Discussion (Misc queries) 2 July 3rd 07 04:21 PM
Copying and pasting table info and cell formating in one hit Sam at JWP Excel Discussion (Misc queries) 3 April 19th 07 03:24 AM
Copying and Pasting a cell with a constant number DenDz Excel Worksheet Functions 2 May 31st 06 07:57 PM


All times are GMT +1. The time now is 08:11 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"