syntax error

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...

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...

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...

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...

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...

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") =...

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...

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...

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 = _...

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...

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...

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...

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...

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 =...

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 =...

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...