| || |
How can you show the data of each row and column from datatable.
i want to print(like Msgbox Datatable(i,j)) each cell data presented in Global data sheet.Please suggest me how to do this.
Thanks in Advance
Re: How can you show the data of each row and column from datatable.
Got the solution here it is below.
For i = 1 to NumRows
For j = 1 to NumColumns
tblCellText = Datatable(j,dtGlobalsheet)
If tblCellText <> "" Then
Msgbox "The Text in Row: " & i & " and Column: " & j & " is: " & tblCellText