i.formula

Does anyone know why I would be getting this error? It worked fine before I added 7 additional ranges and 7 additional strings. I've limited the rows to run from 13 to 20 for a test but it worked running 700 lines without an issue before adding ranges and strings to expand to other columns: Sub...

Hello, Whats wrong with my sumif function? Sub update2()Dim x As Workbook Dim y As Workbook ImportDir1 = Trim(Sheets("Control").Range("H6").Value) Application.DisplayAlerts = False Set x = Workbooks.Open(ImportDir1 & "\" & Sheets("Control").Range("C6").Value & ".xlsx") With x.Sheets(1)...

Hello, I have to modify a tool that makes new OBR sheets (OBR (2), OBR(3)) . I need to refer to cells in these newly made sheets in a for loop on the sheet Uaar from B94 onwards. I have to move down one cell for every reference. Something like this? Sheets("Uaar").Range("B" & "93 +i").Formula...

I feel like this code is taking way too long to process (2-3 minutes). It's quite basic so was wondering if there were any ways I could improve it? Sub Sample1() Dim LastRow As Long, i As Long Dim ws As Worksheet Set ws = Sheets("Sheet1") LastRow = ws.Range("A" & Rows.Count).End(xlUp).row...

Hello, I am still quiet new to VBA. I am working with a spreadsheet that requires me to Divide one column by another (eg. G2/F2, G3/F3, G4/F4...). I'm having trouble getting "Then GoTo" skip to work in my code. If a cell in column "G" or column "F" has the variable "$0.00", i would like to...

HI Why do i get an error on this formula? Cells(3, i).Formula = "=INDIRECT('Data 2 (2)'! & ADDRESS($A3,J$1))" Thanks