Running two arguments within same code

[Brad J.]

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

[RB Smissaert]

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

RBS


"Brad J." <[email protected]> wrote in
message news:[email protected]...
>
> 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
>