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: 1,565
Default Strange thing when copying a range !!

Show us where you assign the value to "Fall_from_height" either as a named
range or as a variable



"Luc" wrote in message
...
The following code gives me the error " 1004 ..." in the second line

Sheets ("MASTER").Select
Range("Fall_from_height").Select 'PS : the range exists !!
Copy



The following code works, but after the Copy instruction it creates an new
workbook !!!!! (i do not want that it creates a new workbook).

Sheets ("MASTER").Select
Application.Goto Reference:="Fall_from_height"
Copy







HEEEEEEELP

Luc


 
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
Strange thing happens... TomCat Excel Worksheet Functions 4 September 30th 07 04:17 PM
Strange Occurrence Copying Formula jcoleman52 Excel Discussion (Misc queries) 3 April 24th 06 09:08 PM
Strange Thing Happening PeterK Excel Worksheet Functions 0 May 3rd 05 09:10 PM
Strange thing happened with TOC RoxSn Excel Discussion (Misc queries) 1 March 11th 05 08:43 PM
Strange thing with this formula written by VBA [email protected] Excel Programming 1 July 1st 03 06:11 AM


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