Spreadsheet inside a Userform

Im using an inserted sheet in my userform to connect data into a chart. I wasnt able to set any Range variables into the userform spreadsheet but managed my way through some issues until a worksheet function

The code below works for most pusposes in the spreadsheet

Code:

---

lvRange as variant
Set lvRange = .spshData.Range("A1:A" & .spshData.Range("A1").End(xlDown).Row)

---

instead of

Code:

---

lvRange as Range
Set lvRange = .spshData.Range(Range("A1"):Range("A1").End(xlDown))

---

I can also use worksheetfunctions such as "SUM(lvrange)", etc. but when the function specifically need "Range" as an argument ( as Subtotal does ) it shows an error. Is there a way to set a range to the spreadsheet? or to fool the subtotal function? Currently I have to copy the data to the workbook, excecute the ops and return the subtotals. Thanks

You need to specify that it's an OWC range, not an Excel Range:

Code:

---

Dim lvRange as OWC10.Range

---

if you're using OWC10 for example.

The two argument form of Range is not a property

Code:

---

lvRange As Range
Set lvRange = Range(spshDate.Range("A1"), spshDate.Range("A1").End(xlDown))

---

Thanks Rory, really helpful specially when managing charts in the uform but Im still having problems with the functions requiring RANGES. For Excel a Range and a OWC11.Range is different when worksheetfunctions?

Which functions are you using as a matter of interest, and can you not put them into the spreadsheet itself?

I tried but the subtotal function doesnt work for me

That should just be a question of something like this:

Code:

---

Spreadsheet1.Range("A6").Formula = "=SUBTOTAL(9,A1:A5)"
End Sub

---