Excel Macro

  • Thread starter Thread starter Robert Blankenhorn
  • Start date Start date
R

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?
 
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.)
 
Back
Top