Get One Column Value/Text quickly? ( not use For .... Next )


text from R1C2 to R10C2 = 1,2,3,4,5,6,7,8,9,10

For vsFlexGrid as following

ColumnText_From_R1C2_to_R10C2 = vsFlexGrid.cell(flexcpText, Row1:=1, col1:=2, Row2:=10)

' vsFlexGrid will return 1 + vbtab + 2 + vbtab + 3 + vbtab + 4 + vbtab ...... + 9 + vbtab + 10

vsFlexGrid.cell(flexcpText, Row1:=1, col1:=2, Row2:= 5) = Join( Array(11,22,33,44,55), vbTab )

' vsFlexGrid will write R1C2_to_R5C2 = 11,22,33,44,55

'=====================


iGrid : Is there any method / property to get one column(or Row) text quickly ? ( Without use For .... Next )

Sorry, but you can do that only using a loop.

Can you tell us why you need this?

Sorry, but you can do that only using a loop.

Can you tell us why you need this?

(1) speed fast
(2) convenient

=================================
EXCEL Cell also has it

EXCEL_Range_Array = Range("A1").Resize(rowSize:=10, columnSize:=5)
'EXCEL_Range_Array return R1C1 to R1C10 / Range("A1:E5") / Array Type

I understand that your code would be simpler if iGrid had such a method or property.

But my question is related to what you want to do with that string representation of a range of iGrid cells.

Are you going to display it on the screen, save it in a text file, pass to another app, etc.?

yes, display it on the screen, save it in a text file fast

about speed

fill R1C1 to R100C100 100 times

VSFlexGrid1: no loop -> cost 0.5 sec
VSFlexGrid1: use loop -> cost 3.0 sec