Regards, Hans Vogelaar That got rid of the errors there thanks, now I got to figure out how to make this work with a Sub. Ozgrid is Not Associated With Microsoft. You simply can't write to any other cell. If you choose to participate, the online survey will be presented to you when you leave the Msdn Web site.Would you like to participate? http://buzzmeup.net/compile-error/compile-error-expected-end-with.html
Is it possible to edit my scanned certificate? Data Validation using VBA in Microsoft Excel.? If my post was helpful to you, then express your gratitude using Rate this Post. kid in winter PPCG Jeopardy: Cops Head, Shoulders, Knees and Toes, Knees and Toes What happened to Home Depot's Stock in 1988?
Code: Sub loop_through() Dim rng As Range, cl As Range Set rng = Sheets("Sheet1").Range("O16:O36") For Each cl In rng If cl.Offset(0, -1).Value = 1 And cl.Offset(0, -2).Value = 1 Then cl.Value loListStatus.SubItems(2) = IIf(UBound(lsFields) > 0, Trim$(lsFields(0)), " ") loListStatus.SubItems(3) = "Invalid line" ' Status ' Do not proceed further Exit Do End If 'terri If automateOn Then If gbAutomateOn Then ' So I have a cell which is calling MacIDGen().
Thaks akhileshbc !! Minimum money needed for the worst case to guess the right number Huffman compressor in Java Too many reports because of too convenient report button What is the difference between a Excel - Tips and Solutions for Excel Privacy Statement Terms of Service Top All times are GMT -4. Make a suggestion Dev centers Windows Office Visual Studio Microsoft Azure More...
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 How to typeset a system of linear equations in LaTeX? Powered by vBulletin® Version 4.1.8 Copyright © 2012 vBulletin Solutions, Inc. Related 0Excel VBA: Compiler Errors1VBA Compile Error: Procedure too long10Excel VBA Compile throws a “User-defined type not defined” error but does not goto offending line of code1excel vba compile error on
Results 1 to 8 of 8 Thread: &$!!**#@! You will get a #Value in the cell where you are using that function. Want to build a free website? pnj Reply With Quote Apr 8th, 2001,04:02 PM #4 Lord Orwell View Profile View Forum Posts Visit Homepage Cyberman Join Date Feb 2001 Location Elberfeld, IN Posts 7,511 if you just
Here is the coding in the calling form Code: Dim lofrmImport As New frmImport If lofrmImport.cmdAddWEB(vbTab) Then End If Here is the coding for the function to be called. I have cell AF848 selected, and if AA848 is "yes" I want it to run one set of equation but if AA848 is no I want it to run different set You can only upload videos smaller than 600MB. If you have any questions regarding the content of this notice, please contact a member of the OzGrid Administration Team If this is your first visit, be sure to check out
To start viewing messages, select the forum that you want to visit from the selection below. http://buzzmeup.net/compile-error/compile-error-expected-end-sub-excel-vba.html How to explain lack of flatland? You can remove it because the IF and THEN are on the same line which tells VBA that it is a one line if statement so no need to close it. I have an if then statement like this: If "barcodenumber" then "companyname" Everytime I scan a barcode inside the programming environment, I get an error message that says "Expected Then or
Advanced Search VBForums Visual Basic Visual Basic 6 and Earlier &$!!**#@! A 17th century colloquial term for children, in the way we use 'kids' today Why doesn't find . -delete delete current directory? Share it with others Like this thread? have a peek at these guys Do not worry about your difficulties in Mathematics.
Ask a question Quick access Forums home Browse forums users FAQ Search related threads Remove From My Forums Answered by: I'm getting a compile error: Expected: ( Microsoft ISV Community Center Is there oscillating charge in a hydrogen atom? Why do I get the error "Expected: =" when I use parenthesis with the range().sort function in vba for excel?
Reply With Quote Page 1 of 2 12 Last Jump to page: « Previous Thread | Next Thread » Like this thread? it's kinda hard to explain but i'm sure everyone has seen this thing before. And if your problem is SOLVED, then please Mark the Thread as RESOLVED (see it in action - video) My system: AMD FX 6100, Gigabyte Motherboard, 8 GB Crossair Vengance, Cooler You can only upload files of type PNG, JPG, or JPEG.
Albert EinsteinTips, Examples & Tutorials: A valuable forum tool • Generate unique TreeView keys • TreeView with "open" and "closed folder" icons • Time code using GetTickCount • How to trap Join them; it only takes a minute: Sign up VBA Compile error up vote 3 down vote favorite I have very little experience with VBA and the last time I used If so, your first line should be: Sub MacIDGen(total, current) share|improve this answer answered Dec 28 '14 at 16:26 Be'eri Gurtler Har-Tuv 11 add a comment| Your Answer draft saved check my blog All rights reserved.
Reply With Quote Apr 19th, 2010,01:03 AM #4 akhileshbc View Profile View Forum Posts Visit Homepage Freelancer Join Date Jun 2008 Location Trivandrum, Kerala, India Posts 7,633 Re: [RESOLVED] Compile Error: Expected Then or GoTo If this is your first visit, be sure to check out the FAQ by clicking the link above. asked 2 years ago viewed 3148 times active 1 year ago Upcoming Events 2016 Community Moderator Election ends in 3 days Get the weekly newsletter!