Submit new data

  • Thread starter Thread starter msnews.microsoft.com
  • Start date Start date
M

msnews.microsoft.com

Hello group, I guess this could be very simple but I need some help, I
created a userform that will ask the user for some information and then all
this information should be submitted and written to a sheet , how do I make
a macro to determine where is the last row with information so the new data
is placed in the next row ?

thanks to all and sorry for my english..
 
Use something like this to find the next row, will go to the next blank cell
in column A

Range("A65536").End(xlUp).Offset(1, 0).Select

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 97 & 2000
** remove news from my email address to reply by email **
 
Back
Top