Dim As Worksheet

[Heather_Llo]

So I've done a bit of research on Dim As Worksheet and what it means, but I'm still not entirely confident with it. As I understand it renames a sheet based on its number (such as Sheet1, Sheet2, Sheet3, etc.) to a value that you specify so that you can reference it from the new value. I understand that it can also define a destination for a function.

I am needing to know more about this function because it may affect what I am doing in my newest worksheet.

This is the Dim As Worksheet function I have in it currently:

'Rename sheets Dim NextRow As Long
Dim wsPaste As Worksheet: Set wsPaste = Sheets("AMPaste")
Dim wsCurrent As Worksheet: Set wsCurrent = Sheets("AMCurrent")

As I understand in this code (which someone wrote for me), it is taking the functions "wsPaste" and "wsCurrent" and applying them to only affect "AMPaste" and "AMCurrent". Is this correct? I am worried about it because I am wanting to copy and paste the code out, editing the function names and sheet names, to use it on a different sheet in the workbook, but I don't know if they will override each other.

Thanks!

 

[mumps]

You should be aware that "wsPaste" and "wsCurrent" are variables and not functions. The "Set" statement assigns a particular sheet to that variable so

Dim wsPaste As Worksheet: Set wsPaste = Sheets("AMPaste")
Dim wsCurrent As Worksheet: Set wsCurrent = Sheets("AMCurrent")

assigns the "AMPaste" sheet to the variable "wsPaste" and assigns the "AMCurrent" sheet to the variable "wsCurrent". If you change the variable name and assign it to a different sheet, that will not be a problem. I hope this makes sense.

 

[Heather_Llo]

You should be aware that "wsPaste" and "wsCurrent" are variables and not functions. The "Set" statement assigns a particular sheet to that variable so

Dim wsPaste As Worksheet: Set wsPaste = Sheets("AMPaste")
Dim wsCurrent As Worksheet: Set wsCurrent = Sheets("AMCurrent")

assigns the "AMPaste" sheet to the variable "wsPaste" and assigns the "AMCurrent" sheet to the variable "wsCurrent". If you change the variable name and assign it to a different sheet, that will not be a problem. I hope this makes sense.

Yes, that makes sense. Thank you.

 

[mumps]

You are very welcome.