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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Set destination sheet based on variable and paste data assistance 13
Returning a value from a range 1
Returning a named range source reference 3
Returning a range from application.inputbox 5
Properties returning object reference or value? 2
paste data from a workbook on a userform spreadsheet 2
Transfer data from user form to register spreadsheet 0
Combine 2 columns in a dynamic range into one 7

Top