Hi.

I am writing a COM Add-in for Excel in C#, using Visual Studio .NE
2003 and the Office XP PIAs.

I trap the SheetChange event, and want to loop through each cell in th
target range. If I try

foreach(Range l_oCell in Target.Cells)
...

I get a COMException with the error "Member not found".

Can anyone shed any light on this? Is it a problem with the PIA? Doe
anyone have a workaround?

Thanks,
Nic

--
Message posted from http://www.ExcelForum.com