user form entering data into correct cells


Posted by Cliff on January 15, 2002 3:19 PM

Hello ladies and gentlemen,

I'm using a user form to input several items of data. I need for the form to enter the data starting in cell b9 and each other item of data in cells c9:u9, I have the cells inputing the data in the correct columns eg.
c9:u9 but I'm having trouble with the form starting out putting the data in b9. I will then need the formula to move down one row with each new series of data. I've used a counta formula to find the first empty cell but can I use the counta formula to start at b9?

Thanks,
cliff



Posted by Jacob on January 15, 2002 6:37 PM

Hi

Try this
LastRow = range("B65536").end(xlup).offset(1,0).row

range("B" & LastRow).select
-Your Code Here-


HTH

Jacob