|
Re: Help with creating an exam book..
Hi Sarrah
In your code for writing the data back to the sheet 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@excelforum-nospam.com> wrote in
message news:Sarrah.21bkvb_1136730001.4909@excelforum-nospam.com...
>
> 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 sheet 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...o&userid=30223
> View this thread:
> http://www.excelforum.com/showthread...hreadid=499013
>
|