expected end of statement

  1. N

    Fix expected end of statement in VBA

    I am trying to use a filter function with data from a seconf workbook. I have the following formula, but I am getting expected end of statement in the first Range and I don't know why: sub tenplate() Dim gen As String, template As String, lr As Long, data As String, name As String, i As Long...
  2. E

    VBA Will Not allow me to enter this formula as shown below.

    VBA Will Not allow me to enter this formula as shown below............ ActiveCell.FormulaR1C1 = "=(GETPIVOTDATA("Total",'TKOFF Summary'!$A$3,"LEVEL 3","D" & Select_Row,"Area",F7,"CSI MF CODE","H" & Select_Row,"ITEM DESCRIPTION","I" & Select_Row,"Unit","K" & Select_Row7" I keep getting the...
    • ebrandt
    • Thread
    • compile error expected end of statement shown vba
    • Replies: 2
    • Forum: Excel Questions
  3. B

    Compile Error: Expected: end of statement ? Simple code

    Hi everyone again! I have a very simple line of code : I am trying to set up a value contained in cell O59 as my col_index_value in a Vlookup. So i dont have to type the column index number in the formula, I can just use ColIndexVal. Im getting a compile error. Sub VertLookLiteral() dim...
  4. B

    VBA Compile Error: Expected end of statement

    I have the following code working: Range("A4:BQ50").Copy Range("A51").PasteSpecial Paste:=xlPasteAll, Operation:=xlNone, SkipBlanks:= _ False, Transpose:=True Rows("4:50").Delete Shift:=xlUp I was trying to reduce it to the following single line: Range("A4:BQ50").Copy...
  5. A

    using concatenate in a macro to combine 2 cells with an ampersand between

    column A contains the husband's name column C contains the wife's name If they both have the same last name (columns C and D) then column F contains "same last name" So if they have the same last name, I want to combine the husband's and wife's first names with an ampersand between them and...
    • alabing
    • Thread
    • compile error concatenate expected end of statement
    • Replies: 1
    • Forum: Excel Questions
  6. A

    using concatenate in a macro to combine 2 cells with an ampersand between

    column A contains the husband's name column C contains the wife's name If they both have the same last name (columns C and D) then column F contains "same last name" So if they have the same last name, I want to combine the husband's and wife's first names with an ampersand between them and...
    • alabing
    • Thread
    • compile error concatenate expected end of statement
    • Replies: 3
    • Forum: Excel Questions

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