How can i define below start range as range given in a cell to do a Loop ?? Please help
Means range given in cell "B5" and "C5" in sheet 2 I want to use in below code
So that I can loop like (For counter = startrng To endrng ) Is it possible?
.Range("Q" & counter).Value
Dim startrng As String
Dim endrng As String
startrng = Sheets("BurnMacro").Range("B5").Value
endrng = Sheets("BurnMacro").Range("C5").Value
For counter = 16 To 20
If Sheets("Actual vs Plan").Range("Q" & counter).Value = Sheets("BurnMacro").Range("C3").Value Then
Bookmarks