complie error

  1. T

    VBA errors in Excel

    Hello, Below is my code. I have a workbook with 3 sheets "ALL RECORDS, ACTIVE, ARCHIVE", and I am trying to get the VBA to move the rows in the ALL RECORDS sheet that have "CURRENET" in Column J to the ACTIVE sheet, and rows that have "ARCHIVE" in Column J to the ARCHIVED sheet.......I am...
  2. J

    Putting contents of a cell in a Message Box

    I want to use a Message Box to display the contents of a worksheet cell in between a text string. I keep getting an error "Compile Error" "Syntax Error". MsgBox "Sample # Sheets("Calc").Range("A2").value "Loaded" & vbNewLine & "Click OK to Load", & vbNewLine, "Next Sample", vbONnly, "Load...
  3. R

    A Compile error: Else without If and I don't know why and how to fix

    I'm trying to debug some code and I think the problem area is related to an ElseIf statement. The error message I get is: "Compile error: Else without If" and the row that is highlighed in the Visual Basic viewer is the ElseIf Line. Any help would be appreciated. 'This is option A to add...
  4. W

    Error Handling: GoTo Err1 Help.

    I can't get my error handeling to work. It breaks on the following line. Any Ideas? On Error GoTo Err1 ' Breaks here "Compile error: Label not Defined" Range("A10").Select Range("Master").AdvancedFilter Action:=xlFilterCopy, CriteriaRange:=Range("Group"), CopyToRange:=Range("A1:K1")...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top