Lastrow definition problem

[YounesB3]

Hello, so far, I've been using this to take into account all the data until the last non-blank data from a column:

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?

 

[MARK858]

Cross-posted
Lastrow definition problem

 

[YounesB3]

They're both the same forum?? Or are they linked together somehow?

 

[MARK858]

See No 24 (and see the rules at the other site you posted at)

http://www.mrexcel.com/forum/excel-questions/127080-guidelines-posting-updated-22-nov-2006-a.html

 

[Rhino_Dance]

Mark858: YounesB3 asked you if MrExcel & ExcelForum.com are somehow linked. There must be some kind of link between them as I've noticed when I've posted to MrExcel I've gotten gotten replies on ExcelForum. Can you comment on this link? Was MrExcel merged with Excel Forum?

 

[MARK858]

No link other than a lot of regular posters frequent multiple sites and it does get irritating if you spend time answering a question on one site only to find someone has given the same or similar answer on another site.

 

[YounesB3]

No link other than a lot of regular posters frequent multiple sites and it does get irritating if you spend time answering a question on one site only to find someone has given the same or similar answer on another site.

I understand, I will provide the link next time I do that.