Strange thing when copying a range !!
in [Programming]
|
From: Luc on 14 Dec 2009 16:03 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
From: marcus on 14 Dec 2009 16:55 Hi Luc Sheets ("MASTER").Range("Fall_from_height").copy If you want to paste it say in A1 then Sheets ("MASTER").Range("Fall_from_height").copy Range("A1") Take care Marcus
From: JLGWhiz on 14 Dec 2009 17:24 Show us where you assign the value to "Fall_from_height" either as a named range or as a variable "Luc" <lferr(a)base.be> wrote in message news:uVyN0DQfKHA.4952(a)TK2MSFTNGP06.phx.gbl... 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
From: Luc on 15 Dec 2009 11:23 Same response error 1004...... "marcus" <marcusinlondon1(a)yahoo.com> schreef in bericht news:4266deb6-b446-4f96-a638-66b342ae1435(a)h14g2000pri.googlegroups.com... > Hi Luc > > Sheets ("MASTER").Range("Fall_from_height").copy > > If you want to paste it say in A1 then > > > Sheets ("MASTER").Range("Fall_from_height").copy Range("A1") > > > Take care > > Marcus
From: Luc on 15 Dec 2009 11:31 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" <JLGWhiz(a)cfl.rr.com> schreef in bericht news:e863myQfKHA.6000(a)TK2MSFTNGP06.phx.gbl... > Show us where you assign the value to "Fall_from_height" either as a > named range or as a variable > > > > "Luc" <lferr(a)base.be> wrote in message > news:uVyN0DQfKHA.4952(a)TK2MSFTNGP06.phx.gbl... > 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 >
|
Next
|
Last
Pages: 1 2 Prev: Some help with a workbook please Next: Restrict cells selected to specific range name |