Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.
One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.
And then use the name "Werkbladen" in other subs like this.
Option Explicit Sub Werkbladen() Dim wsf As Worksheet Dim Wsa As Worksheet Dim Wsk As Worksheet Dim Wsp As Worksheet Dim Wsv As Worksheet Dim Wsd As Worksheet Set wsf = Worksheets("factuur") Set Wsa = Worksheets("attest") Set Wsk = Worksheets("klantenbestand") Set Wsp = Worksheets("productenbestand") Set Wsv = Worksheets("vaste waardes") Set Wsd = Worksheets("database") End Sub
But then i get variable not defined. Is it even possible what i am trying to do. Or should you always dim and set al the worksheets for every sub you make?
Option Explicit Private Sub test() Werkbladen wsf.Range("A1").Value = 5 End Sub
Join the community of 500,000 technology professionals and ask your questions.