Search Free Sign Up Login Home Forum How To Download News Encyclopedia High-Tech Health Free Sign Up Language English Español Deutsch Français Italiano Português Nederlands Polski हिंदी Bahasa Indonesia Login Subscribe 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 Do you mean that when you run the code you get the error? Test it on a copy of your workbook first. http://forumyaren.com/visual-basic/visual-basic-400-error-excel.php
Discussion in 'Business Applications' started by exerguy, Dec 2, 2008. DitzySuz Sub SaveandSend() ThisFile = Range("C6").Value ThisFile1 = Range("C5").Value ThisFile2 = Range("C3").Value ActiveWorkbook.SaveAs Filename:="Survey - " & ThisFile & ThisFile1 & ThisFile2 'Working in 2000-2007 'This example send the last saved If I select "HELP", I just get a blank page in a new window. Password Reminder Password Register Register | FAQ | Members List | Calendar | Today's Posts | Search Excel VBA Discuss using VBA for Excel programming. check that
Attached Images errorchain.gif (5.8 KB, 688 views) Download Last edited by starryknight64; 10-23-2006 at 02:53 PM. bomb #21, Dec 3, 2008 #4 exerguy Thread Starter Joined: Nov 10, 2008 Messages: 21 I do have one hidden sheet. That is, Range("whatever") alone always means ActiveWorkbook.ActiveSheet.Range("whatever").
If you're still interested in why, then give more details - what's this about with unlocking the cell, what's in the range and what's the purpose of the code? Perhaps it would be beneficial to post the code? Simplifying it seems to work faster. Vba Error Catch It could be referring to a variable that had been previously set to a range and then the workbook closed.
When you delete a line, all the previous lines are shifted. Error Code 400 Excel Macro Unhiding it allows the macro to work, but is there a way to do this without unhiding it? Also I would Dim these as Longs rather than Integers –datatoo Jul 23 '12 at 18:28 1 Sorry I missed this too, actually the InStr function should have the String https://forums.techguy.org/threads/solved-vba-error-400-running-an-excel-macro.775340/ excel vba excel-vba share|improve this question edited Jul 23 '12 at 15:06 asked Jul 23 '12 at 14:56 jrad 2,28311024 No that's not the problem.
I sympathize on the stupid error message. Vba Error 400 Protected Sheet Zack Barresse, Dec 3, 2008 #11 exerguy Thread Starter Joined: Nov 10, 2008 Messages: 21 I'm with Zach on this one Rollin - Beautiful. It once happened to me and it was because I had a formula wrong (I tried to calculate the standard deviation of a single value). The time now is 11:47 PM.
Please try the request again. http://ccm.net/forum/affich-80718-error-message-visual-basic-400-help I don't know why it works sometimes and then it doesn't. Error 400 Vba Excel 2013 sign-up, it takes less than a minute and it's free! Excel Vba Label Not Defined DaveG « Previous Thread | Next Thread » Thread Tools Show Printable Version Email this Page Display Modes Linear Mode Switch to Hybrid Mode Switch to Threaded Mode Posting Rules You
To get replies by our experts at nominal charges, follow this link to buy points and post your thread in our Commercial Services forum! weblink Log in or Sign up Tech Support Guy Home Forums > Software & Hardware > Business Applications > Computer problem? Even though it doesn't say "Error #400: Form already displayed; can't show modally," I think thats what it means. 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 Vba 400
Stay logged in Sign up now! The time now is 11:47 PM. You are currently viewing the Excel VBA section of the Wrox Programmer to Programmer discussions. http://forumyaren.com/visual-basic/visual-basic-error-in-excel.php Generated Tue, 01 Nov 2016 11:49:59 GMT by s_fl369 (squid/3.5.20) current community chat Stack Overflow Meta Stack Overflow your communities Sign up or log in to customize your list.
Close and re-open Excel twice. Microsoft Visual Basic For Applications Error 400 Excel 2013 Advertisement Recent Posts Four letter sentence Gr3iz replied Oct 31, 2016 at 11:46 PM Angel's "Last Letter of the... Powered by vBulletin® Version 4.1.8 Copyright © 2012 vBulletin Solutions, Inc.
What happens when you step through the code? Click Browse, go to C:\program files (x86)\add-ins and select Spreadsheet Assistant 2007-2013.xla. 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 his comment is here How can you fix it?The Macros and Visual Basic Icon is disabled in Excel 2010.
All contents Copyright 1998-2016 by MrExcel Consulting. Click here to join today! Terry #2 (permalink) December 29th, 2006, 11:30 PM UnderTheBridge Registered User Join Date: Dec 2006 Location: , , USA. The time now is 11:47 PM.
But there's no Set for RngHD. Similar Threads - Solved error running error code Daysmantech, Oct 5, 2016, in forum: Business Applications Replies: 1 Views: 125 etaf Oct 5, 2016 Excel Addin error Keebellah, Oct 3, 2016, 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 When I ran this step of the macro directly from the module, where it is generated at the recording, there was no problems, but adding it to the rest of the
From it you will hopefully get the clue to solve. I have a staff expense claim spreadsheet that works on most computers, but for some reason won't work on a few. It says, "You can't use the Show method to display a visible form as modal. All rights reserved.
You say the sheet is unprotected - but if so, why must the cell be unlocked? Attached is a list of errors That error referes to "Form already displayed; can't show modally (version 97)" http://support.microsoft.com/?kbid=146864 VBA Noob Register To Reply 09-13-2006,07:12 AM #3 nsv View Profile View exerguy, Dec 2, 2008 #1 Sponsor OBP Trusted Advisor Joined: Mar 8, 2005 Messages: 19,079 The first thing you need to do is to add an Error trap to find Last edited by jasmith4; 10-10-2013 at 12:01 PM.
Well unfortunately, what you've suggested does not work but I know why. Not the answer you're looking for?