Bracketed Range References
 

I use bracketed range references and they work fine on my
desktop but are not recognized when I run the same macro
on my laptop. Does anybody know why?

thanks.

Bracketed Range References
 

should work probably more to do with the activesheet.

does your code refer to a sheet variable or does it work with the
activesheet or thisworkbook..



keepITcool

< email : keepitcool chello nl (with @ and .)
< homepage: http://members.chello.nl/keepitcool


"Bob" wrote:

I use bracketed range references and they work fine on my
desktop but are not recognized when I run the same macro
on my laptop. Does anybody know why?

thanks.

Bracketed Range References
 

What's different between the two machines?

different versions of excel?
Different operating systems?
Different version of Internet Explorer?

Have you tried going into your laptop and building code similar to what your
workbook contains - does that work?

Did you try it like this:

[namedrange].value = 100

Regards,
Tom Ogilvy


"bob" wrote in message
...
i'm just assigning a value to a named range on the active
sheet:

[namedrange] = 100

works on one machine, but not on the other; seems like
some setting or install must be different between the
machines; any ideas?

thanks...bob


-----Original Message-----

should work probably more to do with the activesheet.

does your code refer to a sheet variable or does it work
with the
activesheet or thisworkbook..



keepITcool

< email : keepitcool chello nl (with @ and .)
< homepage: http://members.chello.nl/keepitcool


"Bob" wrote:

I use bracketed range references and they work fine on
my
desktop but are not recognized when I run the same
macro
on my laptop. Does anybody know why?

thanks.


.

Bracketed Range References
 

the only difference is 'pro' on the desktop and 'home' on
the laptop; i tried '.value' and building the code from
scratch as suggested but in both cases get the same
error...

"compile error: can't find project or library"


??




-----Original Message-----
What's different between the two machines?

different versions of excel?
Different operating systems?
Different version of Internet Explorer?

Have you tried going into your laptop and building code
similar to what your
workbook contains - does that work?

Did you try it like this:

[namedrange].value = 100

Regards,
Tom Ogilvy


"bob" wrote in message
...
i'm just assigning a value to a named range on the
active
sheet:

[namedrange] = 100

works on one machine, but not on the other; seems like
some setting or install must be different between the
machines; any ideas?

thanks...bob


-----Original Message-----

should work probably more to do with the activesheet.

does your code refer to a sheet variable or does it
work
with the
activesheet or thisworkbook..



keepITcool

< email : keepitcool chello nl (with @ and .)
< homepage: http://members.chello.nl/keepitcool


"Bob" wrote:

I use bracketed range references and they work fine
on
my
desktop but are not recognized when I run the same
macro
on my laptop. Does anybody know why?

thanks.


.



.