Quote:
|
The tables could be accessed specifically, but I'd then need 3 (at least) subs to do the job, all differing only in the table name used inside them.
|
LineCutter,
I think you misunderstand me, I was meaning to load all three tables with data but then use just one sub to access whichever cells you require, something like...
Sub DoSomeThing(TabelName,ColName,RowNumber)
CellData=Control(TableName).Cell(ColName,RowNumber )
...
...
End Sub
This would be quicker than having to load the data into a single table each time you want to access a cell. Of course I don't know what you are populating the tables with or even whether you need to access data from more than one of the tables during normal operation. It's just another idea to add to the pot
Regards,
RandomCoder