CHANGING "SET ws=SHEETS(" ") TO ACCEPT ANY SHEET NAME

[JuicyMusic]

Hello Guru's, I would like to know how to change the ws line of code in a code that I have been using.

Here is the line of code that I need to learn how to adjust: Set ws = Sheets("Renewal Log")



Dim ws As Worksheet
Dim Status As String
Set ws = Sheets("Renewal Log")
lr = ws.Range(A") & Rows.count).End(xlUp).Row

Please show me how to change this line so that the activated sheet can be called anything at all.
Thank you so much in advance,

Juicy,

 

[eirikdaude]

I'm not sure I understand the problem? Just put whatever you want inside the quotation marks?

 

[JuicyMusic]

I'm not sure I understand the problem? Just put whatever you want inside the quotation marks?

Hello, I think I was very clear. I wrote "Please show me how to change this line so that the activated sheet can be called anything at all."

 

[mumps]

Does this work for you?

Dim ws As Worksheet
Dim Status As String
Set ws = ActiveSheet
lr = ws.Range(A") & Rows.count).End(xlUp).Row

 

[JuicyMusic]

Yes, thank you mumps! That is exactly what I was asking for. Thank you for responding to me.
Juicy,

 

[mumps]

You are very welcome.