Using VBA to print a dynamic range.

[j_Southern]

Dear All,
I am using the following code to select a defined dynamic range and to print it.
As written here it fails with an error message saying that the method is not supported.

Please Login or Register  to view this content.

The code was arrived at by running a macro and changing the range details. If I run it as a macro it works.
If I change the code to:-

Please Login or Register  to view this content.

It fails again as above.
Where am I going wrong?
John

[shg]

The PrintArea property is a string, not a range, so

Please Login or Register  to view this content.

or just

Please Login or Register  to view this content.

[j_Southern]

shg,
Thanks for your interest.
I have tried

Please Login or Register  to view this content.

and

Please Login or Register  to view this content.

Both give Error "application or object defined error"
So I still don't quite understand.
John

[shg]

In your first example, you have a With statement that doesn't do anything. Activesheet (obviously) and Range refer to the active sheet, not to Worksheets("Envelope_List"). You might instead use

Please Login or Register  to view this content.

I don't understand why the second example doesn't work for you. Is the range name valid?

[j_Southern]

shg
I am still in difficulty, with all your suggestions giving the application or object defined error. I am sure that the worksheet and range names are as stated. The range was defined as dynamic in the name manager using a formula like = Offset(Sheet1!($A$10,0,0,Counta(Sheet1!$A:$A),Counta(Sheet1!$5:$5)).
The code is driven by a button click event.
If you can think of anything else It would be very helpful.
regards
John

[shg]

Post a workbook that minimally illustrates the problem.