This macro works great. It selects all the cells between two cell values. I need to adjust it a bit.
Right now it goes down column "C" and finds "Hamilton" and "Hamilton Total" and selects all the cells between. I need it to select only the cells in Column "D" in the same rows except the last one.
Here is an example of what I need:
If,
C10 = Hamilton
C15 = Hamilton Total
Select,
D10:D14
Right now this code will select C10:C15
HTML Code:
Try
Please Login or Register to view this content.
Almost. It selects the correct row, but is off one cell. It selects D9:D13
I need it to do D10:D14
Try this.
[code]
Sub BDown()
Dim rng As Range
Set rng = Range("C1:C" & Cells(Rows.Count, 3).End(xlUp).Row)
With ActiveSheet
.Range(rng.Find("Hamilton").Offset(,1), rng.Find("Hamilton Total").Offset(-1,1)).Select
End With
End Sub
If posting code please use code tags, see here.
Please Login or Register to view this content.
Awesome. The both worked. Thanks for the help.....
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks