formular1c1

Good Morning All Any help with this issue would be greatly appreciated, i cannot seem to figure out why this wont work..? Dim refcell As String Dim Location As String Dim excelname As String Dim ext As String Dim r As String Dim lookuprange As String Dim cs As Integer Dim Boo As Boolean Dim...

I receive an run-time error message 1004 "autofill method of range class failed" in the following setting, in the 2nd line. In this instance, I want to copy 1 cell from the cell 2 columns before. Range("M3").FormulaR1C1 = "=RC[-2]" Range("M3").AutoFill Destination:=Range("M3")...

If I enter this in VBA code, it works fine: Cells(X, Y).FormulaR1C1 = "=ROUND(RC[-12]*2.31556463,2)-401.59" But if I enter this: Dim TheFormula As String Let TheFormula="=ROUND(RC[-12]*2.31556463,2)-401.59" cells(x,y).formular1c1= TheFormula This time I get the error message "Runtime Error...

Hi Everyone, My question is about this: ActiveSheet.Cells(i, 106).FormulaR1C1 = _ "=VLOOKUP(RC[-4],'[Lookup Reference.xls]Sheet1'!R2C1:R11C2,2,FALSE)" The output in excel is the formula itself. How can it be just the value retrieved from the lookup? I guess what I need is the...

OK, so I recorded the following formula in excel but I need to change it so that it uses a variable for the column instead of a fixed column Currently I have: ActiveCell.FormulaR1C1 = "=SUM('Inbound Calls Handled'!C[-1])" I need something like: ActiveCell.FormulaR1C1 = "=SUM('Inbound...

ActiveCell.FormulaR1C1 = "=INDEX(Sales!$B$2:$ZZ$5000,MATCH($A10,Sales!$A$2:$A$5000,0),MATCH(B$9,Sales!$B$1:$ZZ$1,0))) Can someone please help me with the above? The formula works when I enter it directly into a cell but I can't get it to work when I assign it in vba. I'm sure I'm not using...

This formula r1c1 stuff is like voodoo. There has to be documentation of it soemwhere. Anyway, here's my question: Why doesn't the computer like this? Worksheets("QOutput").Cells(x, y).FormulaR1C1 = "=SUMIF('R'!c[5]:c[5],QOutput!r[x]c[1]&'Q','R'!c[y+11]:c[y+11])" Since the only way I can...

Hi, my first post and very new to VBA so any help appreciated. I'm trying to create a function to calculate the average of a range of cells in a column. The first cell is always the cell to the left of the cell where the UDF will be used, the last cell in the range will depend on a parameter...

ActiveCell.FormulaR1C1 = "=SUMIF( c:\new\filea.xls!pnof,RC[-4],c:\new\fileb.xls!qtyf)" This is how the macro formula used to be when I had the file selection as manual as in the user would have to save the files as filea & fileb in the folder c:\new\ . Later on I thought of making it more...