LinkBack URL
About LinkBacks
Hi I keep getting a run time error stating that object doesn't support this property or method. The code is suppose to save to a specific folder. works on my others but not this one. Code below.
Please Login or Register to view this content.
Hi I keep getting a run time error stating that object doesn't support this property or method. The code is suppose to save to a specific folder. works on my others but not this one. Code below.
Please Login or Register to view this content.
Last edited by JBeaucaire; 10-07-2014 at 01:45 PM.
What is in C1 and C3? What is exactly in C1 and C3?
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
Dates C1=9/8/2014 and C3 = 10/5/2014
If you click on C1 and change the cell's number format to GENERAL, does it display a 5 digit number?
Maybe this:
Please Login or Register to view this content.
yes it does.
That did not work getting same code.I have attached a copy.
9-8-14 thru 10-5-14.xlsm
Sheets(1) refers to the first sheet in physical order in your workbook. Currently that's a Chart with no data in C1 or C3.
Use this to reference the sheet by name, regardless of where it is located in the workbook:
Please Login or Register to view this content.
Thans so much for the help.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks