> [NOTE: 06/11/2004 - I don't know if the reverse is true: if
> you define a VEE
> array with a certain size and shape and read an Excel Range
> into it, I have
> no idea what goes where or if it would even work. I tend to think it
> wouldn't work in the first place.]
> -SHAWN-
>
Hi,
No go. Vee tells unable to convert type of right-hand side of "=" to
type of left hand side.
-Antti
Please note: This e-mail may contain privileged and confidential information
and is intended solely for the addressee. If you are not the intended
recipient or an employee responsible for delivering this message to the
intended recipient, you are hereby notified that any review, publication,
dissemination, distribution, copying or use of the information in this
message is strictly prohibited. If you have received this e-mail by error,
please notify the sender immediately by replying to the message and
subsequently delete it from your system.
E-mail is susceptible to data corruption, interception, unauthorized
amendment, tampering and viruses. We only send and receive e-mail messages
on the basis that we are not liable for any such corruption, interception,
amendment, tampering, viruses, any other reprehensible acts or any
consequences of the aforementioned.
---
You are currently subscribed to vrf as: rsb@soco.agilent.com
To subscribe send a blank email to "join-vrf@it.lists.it.agilent.com".
To unsubscribe send a blank email to "leave-vrf@it.lists.it.agilent.com".
To send messages to this mailing list, email "vrf@agilent.com".
If you need help with the mailing list send a message to "owner-vrf@it.lists.it.agilent.com".
> you define a VEE
> array with a certain size and shape and read an Excel Range
> into it, I have
> no idea what goes where or if it would even work. I tend to think it
> wouldn't work in the first place.]
> -SHAWN-
>
Hi,
No go. Vee tells unable to convert type of right-hand side of "=" to
type of left hand side.
-Antti
Please note: This e-mail may contain privileged and confidential information
and is intended solely for the addressee. If you are not the intended
recipient or an employee responsible for delivering this message to the
intended recipient, you are hereby notified that any review, publication,
dissemination, distribution, copying or use of the information in this
message is strictly prohibited. If you have received this e-mail by error,
please notify the sender immediately by replying to the message and
subsequently delete it from your system.
E-mail is susceptible to data corruption, interception, unauthorized
amendment, tampering and viruses. We only send and receive e-mail messages
on the basis that we are not liable for any such corruption, interception,
amendment, tampering, viruses, any other reprehensible acts or any
consequences of the aforementioned.
---
You are currently subscribed to vrf as: rsb@soco.agilent.com
To subscribe send a blank email to "join-vrf@it.lists.it.agilent.com".
To unsubscribe send a blank email to "leave-vrf@it.lists.it.agilent.com".
To send messages to this mailing list, email "vrf@agilent.com".
If you need help with the mailing list send a message to "owner-vrf@it.lists.it.agilent.com".
It works the same way - just turn the assignments around.
> So, formatting the whole column would scrap it.
Ah, Range misunderstanding: a Range doesn't have to be a column, row or
square or rectangle - or even contiguous. A Range can be just a group of
cells anywhere. Try it - Ctrl-Click a bunch of different cells anywhere on
the sheet and name it MyRange. Then click A1. Then command Select MyRange.
Presto, all the previously selected cells are now selected again.
The trick is in constructing the discontinuous range via Automation. I must
confess that at the moment I don't know how that would work out, but here's
the macro I just recorded to do so, commented with clicks:
' Select a bunch of cells.
Range("A1,B3,D9,A10,C6").Select
' Click in the "NameBox".
Range("C6").Activate
' Type "MyRange" and enter.
Application.Goto Reference:="MyRange"
' Select a random cell. After this B1 is the only selected cell.
Range("B1").Select
' Click in the "NameBox", type MyRange and enter.
Application.Goto Reference:="MyRange"
' The range (A1,B3,D9,A10,C6) is now selected.
> Think I can live with that ;D
Yer right! If it works, don't fix it
next upgrade maybe.
> Now I just have to follow Shawn's recommendation...weekend ahoy.
Going to Blues Fest today downtown. I predict Awesome Performances dedicated
to the memory of Ray Charles. If anybody is around Chicago, make *sure* you
get down to Grant Park sometime in the next three days. It'll be soggy, but
after the first couple beers that won't matter.
-SHAWN-
---
You are currently subscribed to vrf as: rsb@soco.agilent.com
To subscribe send a blank email to "join-vrf@it.lists.it.agilent.com".
To unsubscribe send a blank email to "leave-vrf@it.lists.it.agilent.com".
To send messages to this mailing list, email "vrf@agilent.com".
If you need help with the mailing list send a message to "owner-vrf@it.lists.it.agilent.com".