Bracketed Range References

  • Thread starter Thread starter Bob
  • Start date Start date
B

Bob

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.
 
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 >
 
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 said:
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 >




.
Click to expand...
Click to expand...
 
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 said:
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
Click to expand...
work
with the
activesheet or thisworkbook..



keepITcool

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



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

thanks.


.
Click to expand...
Click to expand...


.
Click to expand...
 
Back
Top