| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Why Spreadsheet worksheet is not a worksheet?
Appreciate very much if you can help.
I add a Spreadsheet control on my userform, and want to reference a worksheet on the control. But got a "Type mismatch" error. Set Sht = Me.Controls.Add("OWC10.Spreadsheet.10") Dim Wksht As Worksheet Set Wksht =Sht. Worksheets("Sheet1") Why the worksheet on the Spreadsheet control is not of type worksheet? George |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| e-mail a worksheet from a spreadsheet | Excel Discussion (Misc queries) | |||
| Reporting on multi worksheet spreadsheet | Excel Worksheet Functions | |||
| Worksheet or Spreadsheet | Excel Worksheet Functions | |||
| Extracting Worksheet names within a spreadsheet | Excel Discussion (Misc queries) | |||
| archiving spreadsheet rows from one worksheet to another | Excel Programming | |||
Threaded Mode
