+- QP School (https://qomplainerzschool.lima-city.de)
+-- Forum: Tutorials (https://qomplainerzschool.lima-city.de/forumdisplay.php?fid=3)
+--- Forum: Excel VBA Tutorials (https://qomplainerzschool.lima-city.de/forumdisplay.php?fid=48)
+--- Thread: Worksheet methods in VBA (/showthread.php?tid=5218)
Worksheet methods in VBA - Qomplainerz - 07-26-2023
Description:
Worksheets are objects in Excel, and they have methods like Activate, Select, and Copy.
Example:
Sub ExampleWorksheetMethods()
'Activate a specific worksheet
Worksheets("Sheet1").Activate
'Select a range on the active worksheet
Range("A1").Select
'Copy the entire worksheet
Worksheets("Sheet1").Copy
End Sub