Set range on spreadsheet

[G2K]

Hi All,

I am using Spreadsheet control on User form and i just want to set Range as we do for worksheets. but unfortunately it is not working here. and generates the error

Set rng = Spreadsheet1.Range("A2:A" & Spreadsheet1.Range("A" & Spreadsheet1.Rows.Count).End(xlUp).Row)

here spreadsheet1 is spreadsheet control and Error is "Type Mismatch"

Thanks

 

[RoryA]

Not that I know of, no. As I said, you would have to loop through each cell and check if its row is hidden.