Match a number pattern

Hello Excel vba super users,

I have thousands of rows of numeric data ranging from 1 to 90. In case I want to find a pattern such as I've indicated in the attached photo. How do I go about this??

Hi !

Use the Range.Find method - example within the VBA inner help - to search for the first cell then if found just check both cells under …