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











LinkBack URL
About LinkBacks
Register To Reply
Bookmarks