Home > What Is > What Is Error 400 In Excel Vba

What Is Error 400 In Excel Vba

Reports: · Posted 8 years ago Top Topic Closed This topic has been closed to new replies. So the problem is older than the Add-in you downloaded? Suggestion 2: explain what the purpose of the code is, since it doesn't seem to work even with ws.Select suppressed. Application.Commandbars.Reset Best Regards, Asadulla Javed, Kolkata --------------------------------------------------------------------------------------------- Please do not forget to click “Vote as Helpful” if any post helps you and "Mark as Answer”if it solves the issue.

exerguy, Dec 3, 2008 #7 bomb #21 Joined: Jul 1, 2005 Messages: 8,284 It ought to work for visible and hidden sheets. There should be a restore point from just before you downloaded the Add-in (or was that a long time ago?). It's unlikely anyone will be able to help you unless you post a copy of the module, details of which line threw the error and what cells/forms/dialogue boxes were selected/active at It is blank. @ whs... read review

I have one other Workbook where I have been able to include the Calendar and another one where I have this same problem. To get replies by our experts at nominal charges, follow this link to buy points and post your thread in our Commercial Services forum! So I see this: Set RngH = etc. Posts: 4 Thanks: 0 Thanked 0 Times in 0 Posts From what I have been able to gather, the 400 is a generic illegal operation code that could apply to just

Highlight the variables in your code, right-click, choose "add Watch...", click "OK", (Here's an excellent resource to help you with your debugging in general) and note the following: Which line hits In that case the RTE 400 is only a symptom. at the first beginning of the application it has shown a dialog box mention.. 'Excel could not find this Add-in installed. Just modify the existing IF statement to evaluate the sheetname as well.

All contents Copyright 1998-2016 by MrExcel Consulting. E-mail us or call us 302-584-1771, 8AM to 10PM U.S. Staff Online Now TerryNet Moderator DaveA Trusted Advisor Advertisement Tech Support Guy Home Forums > Software & Hardware > Business Applications > Home Forums Forums Quick Links Search Forums Recent Posts http://www.excelforum.com/showthread.php?t=575702 I've already done the add-in through Excel.

Any way thank you for clear explanation. Change the code of Userform1 to this: Private Sub CommandButton1_Click() UserForm2.Show vbModeless End Sub And run sub Main again. Posts: 13 Thanks: 0 Thanked 0 Times in 0 Posts From what I found the error 400 is part of Excel 97 (did not find this in the error code list The error message tells you to use this code:myForm.HidemyForm.Show vbModal2.7k ViewsView More AnswersRelated QuestionsHow do you use Visual Basic for Applications in Excel?Is there something like visual basic excel training in

You can break the relationship between the windows when you shown them non-modal, resp. I am really got vexed with this. If the worksheet is hidden you can either skip it completely like I've done in the code below or you can modify it to unhide the sheet first, process it, and Esker" mean?

Do you really think a developer would let some who didn't even know how to set a break point in VBE debug this macro? Any ideas now... I've tried to avert this by instead of deleting the row, changing that cell's color so I at least have SOMETHING to go by. Click the command button and the 2nd form is shown, move the window a little so that you can see the first form.

  1. Reports: · Posted 8 years ago Top karteekkarteek001 Posts: 57 This post has been reported. @ whs...
  2. But the problem still persists. :-( Reports: · Posted 8 years ago Top whs Posts: 17584 This post has been reported.
  3. Now change the code in the regular module to this: Sub Main() UserForm1.Show vbModeless End Sub And run that sub.
  4. Register To Reply 10-24-2006,07:21 AM #8 nsv View Profile View Forum Posts Forum Contributor Join Date 08-22-2005 Location Denmark MS-Off Ver Excel 2013 Posts 335 In my case I don't know
  5. Not the answer you're looking for?
  6. Probability of throwing a die What commercial flight route requires the most stops/layovers from A to B?
  7. Reports: · Posted 8 years ago Top Budohorseman Posts: 847 This post has been reported.
  8. Share it with others Twitter Linked In Google Reddit StumbleUpon Posting Permissions You may not post new threads You may not post replies You may not post attachments You may not
  9. Zack Barresse, Dec 3, 2008 #11 exerguy Thread Starter Joined: Nov 10, 2008 Messages: 21 I'm with Zach on this one Rollin - Beautiful.
  10. Join them; it only takes a minute: Sign up 400 Error Excel Macro up vote 5 down vote favorite I'm trying to run a macro that will delete rows that don't

Now try to select a cell in the worksheet or the 1st form, it is possible! NSV Register To Reply 09-12-2006,08:05 AM #2 VBA Noob View Profile View Forum Posts Forum Contributor Join Date 04-25-2006 Location London, England MS-Off Ver xl03 & xl 07(Jan 09) Posts 11,988 Change the code in Userform2 to this: Private Sub CommandButton1_Click() UserForm1.Show vbModeless End Sub Run sub Main, the 1st form opens, click the command button the 2nd form opens. instead of Range("F24").Value use Cells(24,6).

The difference is that mine blows up when I do Workbook.RefreshAll Register To Reply 10-10-2013,11:58 AM #14 jasmith4 View Profile View Forum Posts Registered User Join Date 01-14-2011 Location N/A MS-Off share|improve this answer answered Jul 23 '12 at 18:16 JimmyPena 6,01932944 +1 Since this also works with the merged cells noted by the OP. –Gaffi Jul 23 '12 at If I close the application and restart it, again the same dialog box comes.

From it you will hopefully get the clue to solve.

If you need lines of my code to know the answer, then I can assure you that you are in the dark as much as am I. 12-22-2009, 12:38 PM It turns out that I'd made a schoolboy error, looking for 'email' in the worksheet name when I should have been looking for 'Email'... In the example below the macro will be executed on all visible sheets in the workbook except for Sheet1 Code: Sub Clearcolors() Dim ws As Worksheet For Each ws In ThisWorkbook.Worksheets Register To Reply + Reply to Thread Page 1 of 2 1 2 Last Jump to page: « Previous Thread | Next Thread » Thread Information Users Browsing this Thread There

View our list of code downloads. So whatever happens when you get the RTE 400 in your file, IMHO there are windows involved. Please don't suggest Formatting!! Click here to join today!

This sets the toolbars in the right order the second time. Thanks for your response. ...bob Bob Sutor Edited by ConstPM Saturday, January 04, 2014 9:23 PM Saturday, January 04, 2014 9:20 PM Reply | Quote 0 Sign in to vote Asadulla, The only way I can reproduce the error is to run a form.show command from the form itself which isn't a good way to do things.1.3k Views · View Upvotes ·