Returning a range from Spreadsheet WC

J

jille

Hi,

I'm new to WC's so this may be a relatively simple question but...

I've embedded a spreadsheet in a Word 2000 userform and I want users to be
able to select a range of cells and then click a button to perform an
operation on the selected rows. As such, I need to return the range that they
have selected. I'm not familiar with the object model so am having difficulty
and haven't found much documentation to help (apart from msowcvba.chm).

Any help would be appreciated,

Thanks
 
J

Josh Sale

Both the SpreadSheet and Window objects have a Selection property which
would be that range. To process the selected rows, you would use something
like: owcSS.Selection.EntireRow.
 
Top