excel vba error 40036 Deridder Louisiana

Founded in 1987, Myco-Com Inc. is a telecommunications services company that specializes in telephone system installation and repair. Based in Baton Rouge, La., it offers the Lucent Technology product line of telephone equipment. Myco-Com Inc. also provides professional services, enterprise communication systems, productivity and efficiency enhancers, call center solutions, integrated voice response products and equipment repair. The firm caters to a host of clients, including McDonald s of Baton Rouge, Venture Transport Inc., Acme Brick Co., Breazeale, Saeshe & Wilson LLP and many more.

Communication Technology Specialists - SAMSUNG -SAMSUNG Factory Certified Technicians - AVAYA - AVAYA Certified Technicians -VALCOM Paging Systems - IP Based Data Communications -Communication Technology -VOIP -Voice & Data Systems -IP Based Data systems

Address 9232 Joor Rd, Baton Rouge, LA 70818
Phone (225) 963-6189
Website Link http://www.myco-com.com
Hours

excel vba error 40036 Deridder, Louisiana

Posts: 812 Thanks: 1 Thanked 53 Times in 49 Posts Hi Vamshi Can you try the following Selection.Copy Destination:=Range("N11") Cheers Shasur __________________ C# Code Snippets (http://www.dotnetdud.blogspot.com) VBA Tips & Tricks (http://www.vbadud.blogspot.com) If that doesn't work, go back to the original file, make a copy of the sheet, delete the original sheet, rename the copy as per the original, and see if that Hell, even during DEBUG MODE i can change it to : sheets("Johntext.xls").activate RIGHT IN THE MIDDLE OF DEBUGGING (WHILE THE CODE IS STILL RUNNING) and still get the error when I No, create an account now.

I have my xlsm file that i'm writing my macro in, it's creating a template that gets data from multiple spreadsheets that other people send me. and got the same result, 40036 when copying the worksheet. nbaj2k Excel VBA 2 April 7th, 2010 11:13 AM Run a macro at a certain / specific time Andy84 BOOK: Professional Outlook 2007 Programming ISBN: 978-0-470-04994-5 1 June 8th, 2009 05:19 Thanks for your help Rob --- Message posted from http://www.ExcelForum.com/ Guest, Feb 4, 2004 #5 Guest Guest You could try looking at the code behind the sheet you are attempting

Share it with others Like this thread? Thanks for your help Ro -- Message posted from http://www.ExcelForum.com shinydiamond, Feb 4, 2004 #4 Guest Guest Rob One more thought. Password Home Register Calendar Today's Posts FAQ Free Publications Search Xtreme Visual Basic Talk > Legacy Visual Basic (VB 4/5/6) > VBA / Office Integration > Word, PowerPoint, Outlook, and Other Drag the sheet into a new workbook.

Bottom line is this: This : sheets(var & "text.xls").activate will NOT work if you do it TWICE in the same macro. not a object! I'm new to VBA and have trouble deciphering the cause of error messages and the associated "help" available when an error is generated. Contact Us - Wrox - Privacy Statement - Top Powered by vBulletin Copyright ©2000 - 2016, Jelsoft Enterprises Ltd. © 2013 John Wiley & Sons, Inc.

Powered by vBulletin Version 3.8.9Copyright ©2000 - 2016, vBulletin Solutions, Inc. --> A few responses I have seen have shown a simple program which could not select a screen, or cell on one. I keep getting an Error 40036 Application - Defined or Object - Define error. I had the error message on the first Sheet that I tried it on titled "Budget", so I didn't know that the specific sheet was the issue.

this: sheets(var & "text.xls").activate should be This : sheets(var & "text").activate and sorry for the double posts, my internet at work was being buggy so i couldnt tell if they were Advertisements Latest Threads Happy Birthday Captain Zed! Now, knowing that there is something wrong with the worksheet, not your code, I tried to compile the project and get the error mentioned in my reply. Players stopping other player actions Why is it a bad idea for management to have constant access to every employee's inbox How do you say "root beer"?

You can then close the original file without saving and the sheet will still be in it. I will GLADLY give several hundred MORE points for an valid answer to this question. Not 0. It was supposed to go to the customer next Monday, was almost finished, and out of the blue I've got nothing.

Password Reminder Password Register Register | FAQ | Members List | Calendar | Today's Posts | Search BOOK: Excel 2007 VBA Programmer's Reference ISBN: 978-0-470-04643-2 This is the forum to discuss Next I tried ~x's suggetions. I am having this error come up all of a sudden in a macro that was working fine and hasn't been changed. Please Login or Register to view this content.

You'll be able to ask any tech support questions, or chat with the community and help others. Control Freak #5 02-06-2003, 04:17 PM NateBrei Contributor Join Date: Jul 2002 Location: Omaha, NE Posts: 572 How many sheets are in that workbook; and on which statement I have had other inconsistent problems with the screen, which may be related. Thank you!

It will fail. Search Forums Show Threads Show Posts Tag Search Advanced Search Go to Page... Comment Submit Your Comment By clicking you are agreeing to Experts Exchange's Terms of Use. The workaround is simple but may not be complete. 1) Rename the tab with the screen name 2) Create a new tab 3) Copy the old screen contents to the new

What I did notice is that th sheet I'm trying to select is named as sheet1, when in fact it i actually sheet5 (it's also preceded by a hidden sheet4). Need to download code? THIS IS REALLY PISSING ME OFF, ID BE GLAD TO GIVE SEVERAL HUNDRED MORE POINTS FOR THIS IF SOMEONE COULD PROVIDE A CORRECT RESOLUTION. 0 Message Author Comment by:arthurcid2002-07-08 No, It was created in and intended for excel 2003.

It may be an answer to that problem also. Try deleting the blank lines, for the purpose of the test, and running your macro again. Sub test() Sheets(5).Select End Sub And the same error message..... You should check your code -- especially the module level vars to see if you have anything that may be existing already. (I just renamed the var to mySort and then

I can't find solution on internet and I have two files exactly equal and the other one hasn't this problem. subscribe

Home Register Calendar Today's Posts FAQ Archive © Xtremevbtalk.com 2001 - 2016. Also because it's not my file if there is a way to do it without actually altering the file would be amazing. Welcome to the p2p.wrox.com Forums.

Not the answer you're looking for?