Compile error

Likes Received764Points78,858Trophies2Posts25,954Operating SystemWindows (x64)Excel VersionOffice 365

Re: Vba?

Please read the rules you agreed khổng lồ particularly concerning Thread Titles. Thanks. You need lớn amover your title khổng lồ something more meaningful


Hope that Helps

Roy

New users should read the Forum Rules before posting

For free Excel tools và articles visit my web site

Chechồng out my new website site.

You watching: Compile error

royUK"s Database Form

Where lớn paste code from the Forum

About me.


*

Re: Vba?

Easy.

See more: Chỉnh Sửa File Word Bị Khóa, Cách Mở Khoá File Word Không Cho Chỉnh Sửa

If you want khổng lồ exeđáng yêu more than one statement after an if, you *must* not put the first of those statements on the If line (IYSWIM)

so:


will return the error you have seen.

If there is *only* one action as a result of the If, it should be on the same line & you don"t need the end if:


HTH

Ignore the horrible indentation in my code - it"s because I type the pseuvị code direct inkhổng lồ the post - I don"t normally indent like that... ;o)


*

Re: Vba?

Hi ajclark

Welcome lớn my-huawei.com

Please use more meaningful Thread Title. "VBA" is of no help for searching or answering your question.

See more: Tra Cứu Mã Số Karaoke Mới Nhất 2016, Ma So Karaoke 5 So Arirang Co Loi Viet 4+

Change to:


>Merge Or Convert Excel | Trading Add-ins For Excel | Convert Excel Inlớn Web Pages | Convert Databases Including Excel | Business Spreadsheets | Build Automatic Trading Models in Excel >


*

Re: Compile error. End if without bloông xã if

NOw its giving me a runtime error 9? saying subscript out of range


*

Re: Compile error. End if without block if

I"m locking your post until you read and agree lớn the rules


>Merge Or Convert Excel | Trading Add-ins For Excel | Convert Excel Inlớn Web Pages | Convert Databases Including Excel | Business Spreadsheets | Build Automatic Trading Models in Excel >


This site uses cookies. By continuing to browse this site, you are agreeing to lớn our use of cookies.More DetailsClose
Your browser has JavaScript disabled. If you would lượt thích to use all features of this site, it is mandatory lớn enable JavaScript.