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. Join the community of 500,000 technology professionals and ask your questions. If..Then..End If block statement error. I then discovered that it wasn't all the sheets which had the problem, just one. http://www.mrexcel.com/forum/excel-questions/29581-run-time-error-40036-a.html
The error is occurring on the .Unprotect line, but it occurs no matter what I do there... Then use each of the sheet names output and see if you can select them. So this Microsoft visual basic runtime error 429 can occur if you are running two software programs that aren't compatible, if your computer has memory problems, or if the computer has Here is the FAQ for this forum. + Reply to Thread Results 1 to 8 of 8 Run time error 40036, similar procedures - works in one sheet not in the
you select it, and is a image!! 40036 Ticketmaster If that works, you need another way of generating the range to be cleared. Yes, my password is: Forgot your password? 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
Luiggi, Jul 28, 2016 #9 Advertisements Show Ignored Content Want to reply to this thread or ask your own question? did nothing to fix. Sub test() Sheets(5).Select End Sub And the same error message..... PC Review Home Newsgroups > Microsoft Excel > Microsoft Excel Programming > Home Home Quick Links Search Forums Recent Posts Forums Forums Quick Links Search Forums Recent Posts Articles Articles Quick
Worse yet the “on error xxxxx “ command does not work. https://groups.google.com/d/topic/microsoft.public.excel.programming/RnsyPr-ODb0 I wonder how many thousands of other people who had similar problem, costing the world millions of man-hrs of lost effort? Runtime Error 40036 Access Is there some kind of bug in Excel (I'm using the XP edition) that thi error occurs in certain situations? Check for patches or bug fixes that might be available for your program.
So, I tried to renumber and re-order the sheets, but that doesn't work. http://forumyaren.com/runtime-error/visual-basic-runtime-error-509.php In the future, around year 2500, will only one language exist on earth? Thanks, JOe K Private Sub btnChangeBid_Click() If MsgBox("Are you sure you could like to change the bid price of " & Me.cboItem.Column(1) & "?", vbYesNo, "Change Bid Price") = A few responses I have seen have shown a simple program which could not select a screen, or cell on one.
All contents Copyright 1998-2016 by MrExcel Consulting. The thing that I don't get is as of 6:30 last night this was working just fine now when I try to filter the subform I get a runtime error 40036 Run time error '40036' Application-defined or object-defined error. his comment is here No problem selecting the tab to move and the sheet which has 21 combo boxes functions ok and runs various macros attached to combo boxes.
The not defined, as you know, is saying that there is not sheet called that.....from my understanding -- Message posted from http://www.ExcelForum.com jpendegraft, Feb 4, 2004 #2 Advertisements Guest Guest Ro -- Message posted from http://www.ExcelForum.com shinydiamond, Feb 4, 2004 #1 Advertisements jpendegraft Guest Crazy. Displaying Excel chart in C# application exporting to excel from vb.net application Browse more Microsoft Excel Articles on Bytes Article Stats viewed: 6090 comments: 0 date written:Apr 28 '11 Follow this
Join & Write a Comment Already a member? Join & Ask a Question Need Help in Real-Time? Unknown symbol on schematic (Circle with "M" underlined) How should I deal with players who prefer "realistic" approaches to challenges? Share it with others Like this thread?
I believe i have isolated the problem but am unsure as to how to fix it. 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 Tom [email protected] Found problem. weblink If none of this works and Excel is totally screwed up, as it sometimes is my other “General Solution” is worth trying.
the first sheet is named "Piranha" (no idea why), and the second sheet is named "Piranha - Dist & Growth split" however when i write stardard code like Sheets("Piranha").select it has Reason: Forgot internal macro Share Share this post on Digg Del.icio.us Technorati Twitter Reply With Quote Feb 26th, 2010,11:01 PM #7 froodley New Member Join Date Feb 2010 Posts 2 Re: