Hello, so far, I've been using this to take into account all the data until the last non-blank data from a column:
Now, I'd like to define lastrow from a column to a specific value. For instance, all the data until the word "blank" comes up.
So if I had from V52:
a
b
c
d
e
f
g
blank
blank
blank
Last row would stop at "g". Is that possible?
Code:
LastRow2 = Range("Q" & Rows.Count).End(xlUp).Row
Range("V52").Select
Selection.AutoFill Destination:=Range("V52:V" & LastRow2)
Now, I'd like to define lastrow from a column to a specific value. For instance, all the data until the word "blank" comes up.
So if I had from V52:
a
b
c
d
e
f
g
blank
blank
blank
Last row would stop at "g". Is that possible?