oam
08-13-2015, 04:12 PM
I have a macro that I am working on (see below) and I need to the select the worksheet that is called by a macro. When I run my macro I need to select each tab that “For Each MyCell In myRange” calls.In other words, if “MyCell” called Detroit, Michigan in the list then the next line of code would select the tab labeled “Detroit, Michigan”.
Thank you for your help.
Dim MyCell As Range, myRange As Range
ActiveWorkbook.Sheets("Sheet1").Range ("K2")
Set myRange = Sheets("Sheet1").Range("K2")
Set myRange = Range(myRange, myRange.End(xlDown))
For Each MyCell In myRange
Thank you for your help.
Dim MyCell As Range, myRange As Range
ActiveWorkbook.Sheets("Sheet1").Range ("K2")
Set myRange = Sheets("Sheet1").Range("K2")
Set myRange = Range(myRange, myRange.End(xlDown))
For Each MyCell In myRange