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