I have a macro which retrieves data from a database and places it in an excel spreadsheet. At present the data is added to row 14 and overwrites any existing data.
Is there anyway possible to place the data in the first empty row instead of overwriting existing data.
As an example I am using this code at present.
Dim X As Integer
X = 14
xlSht.Range("A" & X) = rst!IWO
Is there anyway possible to place the data in the first empty row instead of overwriting existing data.
As an example I am using this code at present.
Dim X As Integer
X = 14
xlSht.Range("A" & X) = rst!IWO