Prev: Some help with a workbook please
Next: Restrict cells selected to specific range name
From: TimK on 15 Dec 2009 23:14
Luc,

I'm pretty new to VBA, but I don't belive that a range is created when you
assign a name using the 'name/insert/define method'.

I know that that it sures to seems to me that you would be, but the vba
editor will not show properties or methods when you edit references to those
names.

Hope this helps (and is correct).


--
TimK


"Luc" wrote:

> 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
> >
>
> .
>
First  |  Prev  | 
Pages: 1 2
Prev: Some help with a workbook please
Next: Restrict cells selected to specific range name