access 2016 vba - Find the first cell that starts with

[RCBricker]

I have exported my query to excel. I need to format the rows based on a range of data. This range of data begins with the number 4 (it is a text string though). How can I find the first and last cell in a column that STARTS with the number 4 (as a text)?

I tried to use a .FIND but there are cells with a 4 in the string before the range that begins with a 4 and after that range ends.

        Set rng = wsCOA.Range(.Cells(4, 1), .Cells(lngROW, 1))
        
        
        
        
        intBUD1 = rng.Find(strBUD1).Row

any ideas?

thanks

 

[Micron]

Reads very much like an Excel question, although your post title says Access. I'm confused by that.
You might have better luck getting an answer if you posted in the Excel part of the forum, assuming that's really what this is. I'm afraid that while I do dabble in some Excel vba, it's not my strength. Please come back here a post a link to your new thread if you start one.

 

[RCBricker]

Reads very much like an Excel question, although your post title says Access. I'm confused by that.
You might have better luck getting an answer if you posted in the Excel part of the forum, assuming that's really what this is. I'm afraid that while I do dabble in some Excel vba, it's not my strength. Please come back here a post a link to your new thread if you start one.

You sir are correct!

I am exporting to Excel from access. So I focuses on the wrong forum.

btw I solved this so no need for a new thread.