| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Identify the Current Cell | Excel Discussion (Misc queries) | |||
| Identify current active cell | Excel Worksheet Functions | |||
| Can I automatically enter the current date or current time into a | New Users to Excel | |||
| Identify Current Row for ActiveCell | Excel Programming | |||
| changing current directory to that of the current open file | Excel Programming | |||
Linear Mode
