somnath6309
New Member
Set NewSheet = Sheets.Add(Type:=xlWorksheet)
For i = 1 To Sheets.Count
With NewSheet.Cells(i, 1)
.NumberFormat = "@"
.Value = CStr(Sheets(i).Name)
End With
Next i
What is the meaning of the SET Key word (the red underlined portion)?
For i = 1 To Sheets.Count
With NewSheet.Cells(i, 1)
.NumberFormat = "@"
.Value = CStr(Sheets(i).Name)
End With
Next i
What is the meaning of the SET Key word (the red underlined portion)?