Hello,
I have a worksheet that I need to sort by column A. That's working fine, but then I need to take the block or rows where the text in A starts with IFS. The text in the rest of the cell will vary. So, I need to get the row number of the first and last occurence of IFS..... in column A.

Most of the rows start with IFS, but there are always some that don't

I have tried every syntax I can think of, googled and searched this forum until I'm blue in the face and can NOT solve this. I'm sure it's very simple, but, apparently, so am I, LOL!

Here is my most recent attempt:

IFS = Range("A:A").Find("IFS*")
IFS2 = Range("A:A").Find(What:="IFS*", After:=Range("A2"), SearchDirection:=xlPrevious)
Range("A" & IFS.Row & ":G" & IFS2.Row).Select
This one highlights the last row and says "Object Required"

I will really appreciate any help on this!

Jenny