Identify Current WS?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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>!
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copy a range data from 1 sheet to multiple selected sheets 1
value input on 1 ws, find on another, put date in 2
Placing the MsgBox "No ID found" statement in my code?? 12
Capture current WS Name? 5
CONCATENATE code 2
Problem in adding macro to ribbon through Add-in 7
Converting a “Delete Column” Macro to a “Delete Row” Macro 7
Unprotected sheet is protected? 2

Back
Top