.formular1c1

First, I apologize if this has already been addressed. I was unsuccessful at trying to find anything similar. I have a working formula to average the bottom three values in a filtered list. My VBA routine which builds the spreadsheet from scratch (reading data from individual files) fails in...

So I have a number of formulas that are currently in-cell. I am converting the workbook to VBA and so would like to use the .FormulaArray and .FormulaR1C1 to place the formula in the columns. However, I have found that those two pieces of code have a 255 character limit of what they can place...

Hello All. I have a spreadsheet with about 450 cells that need to have a tick or a cross inserted into them. I've found a great bit of code here; https://www.extendoffice.com/documents/excel/4558-excel-tick-and-cross.html which is 80% of what I would really like the vba to do,,, code so far...

Hi there, I have found the below code on the internet to do what I want, but when I want to expand the range it comes up with an error . Any one has any idea how to include H:H, J:J, L:L and N:N sections to it? Thanks

Hello, I´m new to VBA and I wonder if you can put a variable inside the brackets when using .FormulaR1C1. Here is an example of what I´m trying to do: Sub b() Dim fl As Integer Dim fc As Integer Dim nb_parts As Integer Dim nb_measurments As Integer fl = 8 fc = 8...

Hi I have created the following to put the code in cells on multiple sheets: For Each ws In Sheets(Array("C-H-1218 Jenner", "C-H-1219 St Peters", "C-H-1235 Moxley")) With ws.Range("C12") .FormulaR1C1 = "=-ROUND(SUMIFS('TB actual'!C4,'TB actual'!C3,RC[4],'TB actual'!C[-2],R3C2,0)"...

Is it possible to replace the vlookup function below by something else? This solution is crashing the excel very often. Dim rngS As Range Set rngS = Range("S11:S" & END_Row - 2) With rngS .FormulaR1C1 = "=VLOOKUP(RC[17],'\\ad.igt.com\igt\TEAMS\ TOOL_ADMIN\###IAT...

Dim lastRow As Integer Dim ws1 As Worksheet Set ws1 = Sheets("PayoutsTest") lastRow = ws1.Cells(Rows.count, 1).End(xlUp).Row 'Sum Columns With ws1.Range("B2") .FormulaR1C1 = "=SUM(R[1]C:R&lastRow&C)" End With Above is the relevant part of my code. The lastRow could be changing so I...

Hello all, I have a VBA code I've used successfully to update formulas on a spread sheet once a week. This past week someone pointed out to me that in end of the month weeks 2 formulas were updated incorrectly. Once I corrected the R1C1 formulas, however, I started getting a run-time error...