VBA: How to refer to the right worksheet
- by stanigator
Sub Macro1()
'
' Macro1 Macro
'
'
Worksheets("Drop-down").Select
n = Cells(1, 1).End(xlDown).Row
For i = 1 To n
ActiveSheet.Cells(i, 2).Select
If Worksheets("Misc").Cells(2, i).Value <> "" Then
If Worksheets("Misc").Cells(3, i).Value <> "" Then
Set validationRange =…