Find next available excel cell

[philipad]

Hi all,

I am writing a program which will enter some values in an excel worksheet in column A. This file will already
have some values entered in the first cells.

I want the VB program to check in which cell is the last value entered, so ti will write to the next available cell.
How can I do that?

Thanks.

 

[SkipVought]

Hi,

Are you coding this in Excel VBA or using VB 5 or 6?

Skip,
[sup]Don't let the Diatribe...
talk you to death![/sup][sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[philipad]

vb6

 

[SkipVought]

With xlApp.Sheets(1)
  LastRow = .Cells(.Cells.Rows.Count, "A").End(xlUP).Row
End With

Skip,
[sup]Don't let the Diatribe...
talk you to death![/sup][sub]
Just traded in my old subtlety...
for a NUANCE![/sub]