makako
04-28-2008, 03:30 PM
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
lvRange as variant
Set lvRange = .spshData.Range("A1:A" & .spshData.Range("A1").End(xlDown).Row)
instead of
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
The code below works for most pusposes in the spreadsheet
lvRange as variant
Set lvRange = .spshData.Range("A1:A" & .spshData.Range("A1").End(xlDown).Row)
instead of
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