Excel Macro

[Robert Blankenhorn]

I need to create an Excel Macro tha will import a series
of txt files, one below the other, automatically. The
macro will be run every two weeks and each txt file will
have additional rows. What I want to know is how to
automatically position the curson to the next open cell in
column A after the previous txt file was imported. Can
anyone help?

 

[Dan E]

Range("A1").Offset(ActiveSheet.UsedRange.Rows.Count, 0).Select

Dan E

 

[Dave Peterson]

And I like to start at the bottom and go up.

dim NextCell as range
with activesheet
set nextcell = .cells(.rows.count,"A").end(xlup).offset(1,0)
end with

(I assumed that column A will always have data in it for each row.)