Hi Tony,

Try:

With Worksheets("Sheet3")
Set g = .Range("A" & Rows.Count).End(xlUp).Offset(1, 0)
End With
g.Value = UserForm1.strSuppNam

Note the dot before range and the use of the value property of g.

---
Regards,
Norman



"Tony Zappal" wrote in message
...
Hi All,

I have the below code which i was hoping would work.
It's supposed to enter the varable defined from the userform1 onto another
sheet which doesn't have focus. However, it enters it onto current sheet,
not
onto the RecsC sheet.
Can anyone please help? I've tried different combinations, but cant get it
to work.

Cheers.
Tony.

----------------------------------------------------
With Worksheets("RecsC")
Set g = Range("A" & Rows.Count).End(xlUp).Offset(1, 0)
g = UserForm1.strSuppNam
End With