I have a Macro that steps through several WS, looking for a particular entry.
Once found, I perform some conventional geekery, but then I need to write out
the results of my geekery to a particular R1C1 on the current WS. So I have
this construct..

Set rngWorkCell = Selection
'Set wksCurWks = Worksheets.

...second row commented out because I have no way to tell it what to use.
wkcCurWks is Dimmed as Worksheet.
--
Dave
Temping with Staffmark
in Rock Hill, SC