I want to define a variable in a for loop as a specific cell that will change as the for loop iterates through. I am just unsure of the syntax to do so. This is what I have so far. How could I make this do what I just explained? Any help would be greatly appreciated.
Key = Sheet1.Columns("A:A").Rows("i")
See Question&Answers more detail:os