Identify Current WS?
 

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

Identify Current WS?
 

set wksCurWks = ActiveSheet

--
Regards,
Tom Ogilvy


"Dave Birley" wrote:

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

Identify Current WS?
 

Thanks, Tom. All the Help files are busy with Adding a WS, or referencing a
WS by name. I confess -- I really did look at Help first <g!
--
Dave
Temping with Staffmark
in Rock Hill, SC


"Tom Ogilvy" wrote:

set wksCurWks = ActiveSheet

--
Regards,
Tom Ogilvy


"Dave Birley" wrote:

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