JuicyMusic
Board Regular
- Joined
- Jun 13, 2020
- Messages
- 210
- Office Version
- 365
- Platform
- Windows
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,
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,