syntax error

  1. L

    “Unable to get the VLookup property of the WorksheetFunction Class” error

    Hi all, I am trying to set the values in column B in my Workbook "Copy of Dash Board Shell" (shown in the image below) equal to the value derived from my HLOOKUP function from my data workbook shown as second image below Copy of Dash Board Shell Data file so esentially the code will find a...
  2. Z

    Syntax Error Not R1C1 Problem. Manual formula work fine

    Hi all, I cannot fathom why this returns syntax error. I've done all the fiddles and bits I know and it still gives it me. The formula works fine when i type it in but when i do it in a macro. Nope. Ive typed the macro, I've recorded the macro. Nothing. Its driving me up the wall !!! Sub...
  3. R

    sql issue

    Sub output_into_files() Dim CONNECT As New ADODB.Connection Dim zapytanie As New ADODB.Recordset Dim path As String Dim name As String Dim a As Integer Dim sheetValue As String Dim QueryString As String path = "SOME PATH...." name = Dir(path) a = 1 sheetValue = "sheet" & a Do Until...
  4. M

    SQL Error in trying to fill formula down

    Hi, I have an issue with my SQL code below, in that I am trying to fill series the formula in column Y within my dynamic table. For some reason it doesn't like the format of the formula despite it working in the excel sheet itself. It appears not to like the "A" which is being added within the...
  5. dmqueen

    Syntax error on function calls

    Please help! I cannot get past these compiler errors on my function calls, and I can't figure out why. Neither function returns anything, so it should be straightforward. I've marked the function calls receiving the errors with asterisks in the code comments and added the functions being called...
  6. dmqueen

    Syntax error If Or stmt

    Hello, For the life of me I cannot find the syntax error in my If Or stmt. I'm hoping fresh eyes an spot it. I tried to clearly mark the problem line with comments, its the line looking for the Notes field. I'd love any help, Thanks! <code> Sub fInput_Complete() 'Validate Entries 'copy listbox...
  7. H

    Dynamic range based on column order

    Hi I want to refer to columns by column order (i.e. A=1, B=2, etc.) I want to sum a range for dynamic columns and fixed widths (i.e. B2:B5 or F2:F5, etc). i have C_N as variant and i am trying to write the formula but desperately getting syntax error. Range("M5") =...
  8. J

    Compile error: expected end of statement

    I am in need of a way to consolidate data from multiple files into one file. I am using the code below to perform this task. There are 2 errors and I am at a loss for how to correct them. Any help would be greatly appreciated. Sub GetData()Dim strWhereToCopy As String, strStartCellColName As...
  9. E

    IF statment (DAX) in powerpivot

    Hello, I am having a had time having this function work properly. I am creating a proper P and L sheet using powerpivot. Meaning I want both my expenses and revenue as positive value on the sheet. Right now the revenue show up as negative and expenses as positive. So I need to make the Revenue...
  10. W

    Excel formula doesn't work when recorded as macro - syntax error

    hi, i have a formula that works in excel but when i come to record it as a macro it no longer works and si ignored but doesn't diurupt any other part of the macro. Recording below Range("O3").Select ActiveCell.FormulaR1C1 = _...
  11. Gingertrees

    Please help me sort in VBA and help me kill my errors

    Found some code a Contextures for locating the LAstRow and LastColumn in a worksheet. Trying to combine it with a macro to sort my data. I am trying to modify the macro-recorder's data to allow for the variable end of a worksheet (I recorded it such that it sorted from A1:Q205). I come up with...
  12. T

    Syntax Error

    Hi all, Can anyone see why this query is hitting a syntax error (missing operator)? I've added as many square brackets as possible, but still there's a problem! It seems to point at my joins, I know DISTINCT queries are a nightmare in Access, but it all looks OK to me. Any help would be...
  13. C

    Syntax

    can anybdy help me i m working in vba but i have one issue for example if i have two sheet sheet1 which is data given below name id forcast chetan 1 blank raj 1 blank amit 1 yes and sheet2 which is data given below name id forcast chetan 1 yes raj...
  14. G

    Proper syntax

    I am creating a Macro to convert formulas to values on a Datasheet after each entry from a form (worksheet) is carried over. Since each entry will go on a separate row I created formulas to give the new datas location. I just can't get the syntax correct for it to run. Sub...
  15. J

    compiled error (syntax error) in macro

    Hey all, When I currently try to run the below macro, I get a syntax error. Basically it performs excel formulas to split names: Sub nameSplitter_Improved() ' ' nameSplitter_Improved Macro ' ' Windows("summary_judgment.xlsx").Activate Range("C1").Select ActiveCell.FormulaR1C1 =...
  16. G

    Use Variable in AND formula in excel

    Hello everyone, I would like to know what is the syntax to retrieve the value of a variable and use it in an AND formula in excel. This is my current code: Sub Module1() Dim RowNdx As Long Dim ConfMonth As String Dim DelPrevMs As String Dim ConfirmDel As String Application.DisplayAlerts =...
  17. N

    Help with inserting Excel formula into VBA code

    I found the following code on this site that does exactly what I want. It counts the number of rows in <?xml:namespace prefix = st1 ns = "urn:schemas-microsoft-com:office:smarttags" /><st1:State w:st="on"><st1:place w:st="on">Col</st1:place></st1:State> A and then copies the value of the formula...

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