Referencing a range problem

[guss]

Sorry about the long winded code posting as you can ignore most of it, just thought you might like to see how atrocious my coding is! I am using the code to learn about classes. I am tearing my hair out on the bold line below as it keeps throwing up this error....What I am doing is moving a range from a worksheet to a file.

Application defined or Object defined error

Any idea why it doesn't like it. Have tried entering a literal value for the range and its happy with that but when I put in the range object it screams.

Cheers
Guss


########## code module #########

Please Login or Register  to view this content.

########## class module #########

Please Login or Register  to view this content.

[TMS]

Try changing:

Please Login or Register  to view this content.

To:

Please Login or Register  to view this content.

as RangeToFILE is defined as a Range.


Regards

[guss]

Try changing:

Please Login or Register  to view this content.

To:

Please Login or Register  to view this content.

as RangeToFILE is defined as a Range.


Regards

Yup tried that and I got another error....

"Object doesn't support this property or method"

[guss]

I should add its important to me to know what I am doing wrong than someone handing me a solution thats different from what I have done.

But I do appreciate any contributions

Guss