I have a grid with 8 columns. 7 of the columns are populated with the FillFromRS method. The 8th column cannot be populated from the recordset.

I am looping through all the rows to populate the values manually but it is a little slow.

I tried using the CellDynamicText procedure but that only allows me to set a cell's TEXT and what I want to do is set the real VALUE of the cell.

What is the fastest way to do what I need?

Thank you.

Ray

It seems, your post already contains a hint about the answer:

The 8th column cannot be populated from the recordset.

If so, then, it seems, you have no choice than to loop through all the rows and set the required cell values.

The only possible exclusion I can think of is to prepare a recordset that already contains the 8th column calculated/populated (using a stored procedure, a wider SELECT statement, etc). But I do not know whether this idea is applicable to your app.