ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   OpenText FieldInfo:= Array (https://www.excelbanter.com/excel-programming/386224-opentext-fieldinfo-%3D-array.html)

PBezucha

OpenText FieldInfo:= Array
 
My experienced friends,
Could you declare in VBA dynamically the composed
Array(Array(a1,b1), .. , Array (an,bn))
on the base of integer matrix a1,..,bn ?
Thanks
Petr

--
Petr Bezucha

PBezucha

OpenText FieldInfo:= Array
 
Catch removed. Thank you, Tom.
Petr
--
Petr Bezucha


"Tom Ogilvy" wrote:

Dim v() as Variant

n = 10
Redim v(0 to n - 1)
for i = 1 to n
v(i-1) = Array(Cells(i,"A"), cells(i,"B"))
Next

... FieldInfo:=v

--
Regards,
Tom Ogilvy


"PBezucha" wrote:

My experienced friends,
Could you declare in VBA dynamically the composed
Array(Array(a1,b1), .. , Array (an,bn))
on the base of integer matrix a1,..,bn ?
Thanks
Petr

--
Petr Bezucha



All times are GMT +1. The time now is 08:53 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com