Not sure, but it sounds you want to know the number of dimensions of an
array in that case look he
http://vbnet.mvps.org/index.html?cod...tarraydims.htm

RBS


"Brad J." wrote in
message ...

Hi all,

I have an Excel worksheet that I created to import measured dimensional
data automatically into specific cells from an external application I
use. It works fine for the most part, but, I have a situation where
occasionally, I need to use a specific type of dimensional calculation
which requires two or three additional features I have already done so
when this particular line imports into my sheet, it also imports all of
the other dimensions in the line. For this particular instance, I have
written an additional section of code using the external application's
object library commands, but, I cannot seem to get them to work
together. I have use an If, Then and ElseIf, Then but I don't seem to
be finding the right combo.

I basically the script to run as such: When the script reads the next
row, I want it to make the determination whether it is dimension type a
or dimension type b and place data accordingly.

I have been using the VBA scripting for many of my sheets and have a
fair level of proficiency but this one just has me flat stumped!

Any help would be great!
Thank you, Brad


--
Brad J.
------------------------------------------------------------------------
Brad J.'s Profile:
http://www.excelforum.com/member.php...o&userid=21713
View this thread: http://www.excelforum.com/showthread...hreadid=550823