How to indicate that the current visible worksheet is the active o

[George Furnell]

Good day,

I have a function in a module, in which I would like to state that the
current visible worksheet should be treated as the active one, because I do
not know during execution what the sheet name will be. In the example below
the sheet name is hardcoded, what is the better solution?

With ActiveWorkbook
With .Worksheets("Titans")
.Range("M5").Value = 5
End With
End With

Kind regards

George

[Norman Jones]

Hi George,

Dim SH As Worksheet

Set SH = ActiveSheet

SH.range("M5").Value = 5

The object variable SH will refer to the stipulated sheet, irrespective of
whether it is subsequently active or not..


---
Regards,
Norman


"George Furnell" <GeorgeFurnell@discussions.microsoft.com> wrote in message
news:63CCD879-F9B3-4716-9589-12737D11DB91@microsoft.com...
> Good day,
>
> I have a function in a module, in which I would like to state that the
> current visible worksheet should be treated as the active one, because I
> do
> not know during execution what the sheet name will be. In the example
> below
> the sheet name is hardcoded, what is the better solution?
>
> With ActiveWorkbook
> With .Worksheets("Titans")
> .Range("M5").Value = 5
> End With
> End With
>
> Kind regards
>
> George
>
>
>