Hello, I've been trying to get this macro to work for a while and I keep getting the method Range of object _global error. This is my code:
I have since added this
Please Login or Register to view this content.
and changed the Range()'s to Sheet1.range(), but am now getting a unable to set values property of Series class on this linePlease Login or Register to view this content.
Any Suggestions? Thanks.Please Login or Register to view this content.
Try this,
Please Login or Register to view this content.
Thanks for the quick reply! Works like a charm.
Donnie
EDIT: The files that I want to manipulate with this macro are in the .cvs format. How would I be able to make this macro work for any file name (I tried using this on an arbitrary file name "temp" and it said that it was "out of range". Thanks again
Last edited by dstull; 06-19-2008 at 12:15 PM.
Don't understand.
The code works on a worksheet, in this case named Sheet1, but that can be changed.
How does csv fit in to the problem?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks