By using vba.booksticle.com you agree to our cookie policy, We and our partners operate globally and use cookies, for multiple purposes

948 Steps to 6 Figures by Learning Excel-VBA and Other Skills

Step 174 - As Worksheet

The As Worksheet is used to define a variable or parameter as a Worksheet.

Sub test_worksheet()

Dim sh As Worksheet

For each sh in Workbook

  debug.Print sh.Name
  set last_worksheet = sh

Next

End Sub