View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Luc[_7_] Luc[_7_] is offline
external usenet poster
 
Posts: 21
Default Strange thing when copying a range !!

I applied the name by using the menu .... insert , name, define...(Excel
2003) (i guess those are the english names, because i use the Dtch Excel
version)


"JLGWhiz" schreef in bericht
...
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