For Each c In Worksheets("1").range("I2:I100")

[Todd_M]

Hi-
The formula:

For Each c In Worksheets("1").range("I2:I100")

Will search for a c value in sheet 1, range I2 to I100. Say if I have 12 sheets named 1 thruogh 12 and I want the c.value to search in each sheet,range I2 to I200. How would one adjust this code so that it searches all 12 sheets at once??

 

[Ivan F Moala]

On 2002-04-27 17:13, Todd_M wrote:
Hi-
The formula:

For Each c In Worksheets("1").range("I2:I100")

Will search for a c value in sheet 1, range I2 to I100. Say if I have 12 sheets named 1 thruogh 12 and I want the c.value to search in each sheet,range I2 to I200. How would one adjust this code so that it searches all 12 sheets at once??

This will search ALL sheets;

<Pre/>

Dim Sh As Worksheet

For Each Sh In ActiveWorkbook.Sheets
For Each c In Sh.Range("I2:I100")
'//
Next c
Next Sh

</pre>

 

[Todd_M]

Thanks Ivan, This works well!!