John Walkenbach's site
http://www.j-walk.com/ss/excel
go to the developers section

Chip Pearson's site
http://www.cpearson.com/excel/topics.htm


to loop through all cells

for each cell in Activesheet.UsedRange
if cell.value = 10 then
msgbox cell.Address(0,0)
end if
Next


for each sh in Activeworkbook.Worksheets
for each cell in sh.UsedRange
if cell.value = 10 then
msgbox cell.Address(0,0,xlA1,True)
end if
Next
Next

--
Regards,
Tom Ogilvy




"HSalim[MVP]" wrote in message
...
Good morning All

Where can I find guidance and code samples to help me perform the
following
tasks using Excel VBA
1. iterate through a worksheet cell by cell
2. replace values, parse values and conditionally set flags in mew columns

Thanks in advance

Habib