I use following code to read DB table to Excel worksheet:
Please Login or Register  to view this content.
This works OK, but I need to find certain value from the DB and write that value to a specific cell. I know how to create SQL string to get that value but I don't know how to write it to a cell. I modified the code a bit:
Please Login or Register  to view this content.
but this doesn't work, it writes DB column name to that cell and results an error at some point. Any ideas?