Finding the last cell in a column based on cell contents

Hi all,

I've had a look around the net but haven't been able to find an answer to my question.

I'm trying to write a code to select a range starting at cell B4 and ending at the last cell within the same column which doesn't contain the word "Nil"

In otherwords my spreadsheet contains a number of formulas like so:

B4 =if(A4="","Nil","<text>")
B5 = if(A5="","Nil","<text>")
B6 =if(A6="","Nil","<text>")
etc.

This continues to B20.

The code needs to select from range B4 to the last cell in column B which has an 'if' false value in it - in otherwords find the last cell with Nil in it then offset it by -1. The answers will always be in order starting at B4 so there won't be gaps or any Nil answers between the false answers.

Hope this makes a bit of sense - it's just hard to explain.

Thanks all,

AA

Not entirely sure I can follow your logic re: ordering etc but it's early... that said here's one possibility:

Please Login or Register  to view this content.

though I'd add you rarely need to .Select anything.

That should do the trick.