Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Find error?
That's what I dont understand. It works for the lRowMax, but not for the lRowMin. iMax = Application.WorksheetFunction.Max(rR) lRowMax = rR.Find(iMax, rR.Cells(rR.Rows.Count)).Row Set rE = Range(Cells(2, lCol), Cells(lRowMax, lCol)) iMin = Application.WorksheetFunction.Min(rE) lRowMin =...- ecarney14
- Post #5
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Find error?
I get Runtime error '91' Object Variable or with Block variable not set. Anyway, why are you starting your search from the last row ? I don't know exactly what you mean....how am i looking at the last row? Thanks.- ecarney14
- Post #3
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Find error?
Hey, I have been working on this macro to analyze data. And I keep getting an error when i try to find lRowMin. It's driving me nuts, so any help would be greatly appreciated. Thanks a lot. Sub carney() Dim iMax As Double, iMin As Double, lRowMax As Long, lRowMin As Long, lCol As Long Dim...- ecarney14
- Thread
- Replies: 4
- Forum: VBA Visual Basic for Applications (Microsoft)
