Or, disregard the 'with' and try
Set g = Range("'RecsC'!A" & Rows.Count).End(xlUp).Offset(1, 0)
instead of
Set g = Range("A" & Rows.Count).End(xlUp).Offset(1, 0)


"Don Guillett" wrote in message
...
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