Hello guys
I have a very simple SQL-retrieving routine reading four fields from a large Excel file and writing them to four cells in an excel sheet. The routine is triggered with Worksheet_Change() when I enter a number in column 1. The routine fetches the data and inserts them into the appropriate cells but only the first field is visible- the other three are not although the data in the cells are there. Not until I edit (F2) one of the fields, all four will be visible.
How should I handle the recursive Worksheet_Change() when my SQL routine writes the retrieved data to the worksheet?
Håkan