Re: Help with creating an exam book..

Hi Sarrah

In your code for writing the data back to the *** you will need to
determine where the lastrow is in column A with something like
lastrow = .Cells(Rows.Count, 1).End(xlUp).Row
then write the range of data to
Range("a" & lastrow)

--
Regards

Roger Govier


"Sarrah" <Sarrah.21bkvb_1136730001.4909@xxxxxxxxxxxxxxxxxxxxx> wrote in
message news:Sarrah.21bkvb_1136730001.4909@xxxxxxxxxxxxxxxxxxxxxxxx
>
> Thanks for the reply Roger!
>
> I have one more question, I need to make a student list and a small
> form right above the list in the same *** with fields empty so that
> I
> can enter information and press the macro button, which will result in
> storing all the information in rows under the form.. I tried to do it
> but I'm having trouble it seem to store on the first row every time I
> try to add a new information which should be added on the next row,
> you
> know what I mean?
>
>
> --
> Sarrah
> ------------------------------------------------------------------------
> Sarrah's Profile:
> http://www.excelforum.com/member.php?action=getinfo&userid=30223
> View this thread:
> http://www.excelforum.com/showthread.php?threadid=499013
>


.

Loading