Help! I'm writing a spreadsheet that uses a macro and input boxes to
allow you to input product details relating to products for sale:
Column A contains the product number, then the macro automatically tabs
across for you to input other data; product name, cost price etc into
appropriate cells in the same row. At the moment, the user must specify
the starting cell in column A to input the new product number then the
macro simply selects the next cell relative to the starting cell. what
I would like to do is create a little piece of code that means that if
there is data already in the cell in column A, then the macro will
automatically skip down to the next cell, until the program selects an
empty cell.
This should be fairly easy, but I simply don't know enough about VBA to
make it happen :(
Can anyone help me please?
Many thanks.
--
slowdiver
------------------------------------------------------------------------
slowdiver's Profile:
http://www.hightechtalks.com/m778
View this thread:
http://www.hightechtalks.com/t2338065