After 2 days of searching I actually found the answer myself!!! :-)
I left the _ (underscore) off the end of the 1st row & obviously this makes
a difference as to how the code is handled. Please explain why? But it is
now working perfectly.


lRow = ws.Cells(Rows.Count, 1) _
.End(xlUp).Offset(1, 0).Row

--
Thanks,
Butterfly Girl


"FSt1" wrote:

hi
why not just post your code here. everyone does it.

regards
FSt1

"ButterflyGirl" wrote:

Hi & thanks in advance,
I am trying to put 2 user forms that relate to the same worksheet, however
its not working...
I am getting an error message that says "Compile error: Invalid or
unqualified reference"
I am extremely new to programming so i would appreciate any help I can
get... I can email the "code" through if that helps.
--
Thanks,
Butterfly Girl