Hello EXCELcior08,

Welcome to the Forum!

Reminds of Longfellow's poem..
The shades of night were falling fast,
As through an Alpine village passed
A youth, who bore, 'mid snow and ice,
A banner with the strange device,
Excelsior!
The Find method for a Range object returns a Range object. You can then manipulate the Range and the Worksheet to which it belongs to either read or write data to a specific cell or cells.

Here are a couple questions I have for you. Once you answer these, I can give you some examples of For loops using Find.[list="*"][*] Is the search looking for all three cells to contain a "1" or any of the cells to contain a "1"? [*] Are you searching for just one row or all rows that contain "1"?