I have tried to use the following code to copy a given range and paste it into a new workbook which I will then file with a new name.
I get an error message "object does not support the named Property or method at line marked 10. In most cases when I have got this error it has been caused by a typo. On this occasion though Rangename is right and the range does exist in wbSource in wsSource. Where else could I have gone wrong?
Please Login or Register to view this content.
How are you calling the subroutine
This format only works as a subroutine and must be called by another Macro.
My General Rules if you want my help. Not aimed at any person in particular:
1. Please Make Requests not demands, none of us get paid here.
2. Check back on your post regularly. I will not return to a post after 4 days.
If it is not important to you then it definitely is not important to me.
mehmetcik,
Thanks for your interest.
The routine OutputText is called by the following routine fired by clicking a button on a userform.
The routine PasteDownN is simply a way of copying and pasting formulae.Please Login or Register to view this content.
The reason I have two output routines, Output and OutputText, is that Output deals with those situations where I need to copy to several sheets in a new workbook.
A workbook doesn't have a Range property - that applies to either a Worksheet or the Application object.
Everyone who confuses correlation and causation ends up dead.
Ive changed the offending line to:-
I still get the same error. If this code is OK I think I must have a typo that I've missed.Please Login or Register to view this content.
John
Remove the wbsource. part from the start, so it's just:
Please Login or Register to view this content.
That's all it was. All is working as I wanted.
Many thanks for your help.
I am a bit puzzled though. When I am working with one workbook with many worksheets it is not necessary to use the worksheet name when referring to a named range, though it is necessary when referring to an ordinary range. This is why I used the workbook name and the rangename only and got the error. There is obviously something here that I don't understand properly.
John
In a normal module, you can use Range on its own, and it's equivalent to Application.Range which will work with either a regular range address (returning a range on the active sheet) or a workbook-level named range defined in the active workbook. You can't use workbook.range with any type of range, though you could use the Workbook.Names collection - perhaps that's what you were thinking of?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks