View Single Post
  #1   Report Post  
Posted to microsoft.public.office.developer.vba,microsoft.public.office.developer.com.add_ins,microsoft.public.office.developer.automation,microsoft.public.excel.programming
LF LF is offline
external usenet poster
 
Posts: 32
Default Working with a Range object

Hello,

In a C++ COM add-in for Excel I need to do something with all the cells on a
worksheet. I saw that I can use Worksheet.UsedRange. However, this is a
read-only property. Does this mean that the range itself is read-only, or
the cells that are covered by this range (I hope the cells are writable)?

Then, assuming I've got a Range object, how do I iterate all the cells in it
an do my processing on each cell?

Regards and thanks,
Levente