try putting the dot ( . ) before range. Look in help for with.

--
Don Guillett
SalesAid Software

"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