|
Re: Help with creating an exam book..
Hi Sarrah
So your data is being written to Column B, not column A.
In your code you need to determine the last used row in column B with
something like
lastrow = Range("B1").Cells(Rows.Count, 1).End(xlUp).Row
then write your data out to
Range("B"&lastrow + 1)
--
Regards
Roger Govier
"Sarrah" <Sarrah.21brky_1136738701.3904@excelforum-nospam.com> wrote in
message news:Sarrah.21brky_1136738701.3904@excelforum-nospam.com...
>
> I'm sorry to be such a pain in the butt but what I'm trying to do is a
> bit different I think.. I'm a bit lost with your explanation.. okay
> let
> me show you how my student list sheet looks like..
>
> click on the 'LINK HERE'
> (http://img490.imageshack.us/img490/6844/image22dn.jpg)
>
> I want to input information in the fields and when I press the button
> the information should store in the table under the form.. my problem
> is I cant seem to store it automatically in the row under the first
> data, it just keeps replacing that first data..
>
>
> --
> Sarrah
> ------------------------------------------------------------------------
> Sarrah's Profile:
> http://www.excelforum.com/member.php...o&userid=30223
> View this thread:
> http://www.excelforum.com/showthread...hreadid=499013
>
|