activecell.formular1c1

Hi, I am getting 1004 error for the following code, i have checked through many time and still unsure why.. ActiveCell.FormulaR1C1 = "=IF(" & buffer2(0) & "=""yes"",IF(" & buffer2(1) & "=0," _ & buffer2(2) & "*0.07,SUMPRODUCT(" & buffer2(1) & "," & buffer2(3) & ") * 0.07),0)"

hello all! i am learning to code, and have 7 books but still have such a hard time understanding loops. i'm desperate for help. My boss wants me to loop through a years worth of files and pull data. I tried for days, and am just not retaining the rules behind the action. I hope someone will just...

Hi, I have the below code which is returning an error, I believe near the bottom. It says I need to "End With" but when I put "End With" before "End Sub" it says it wasn't expecting "End With" :banghead: I'd really like this to run without any problems. Can someone please show me where I am...

Hi, I have recorded the below macro. However it is taking loads of time to run. Is there a way to ensure macro will delete old data on the file (with click of a button) and let the user start a fresh. Same time it won't take time to run. The vlookup should be done only if columns C as value...

Hello, I am new to VBA but trying to learn. I am trying to have a sheet that has 2 Macros, the 2nd Macro will send the data to an IE webpage, this part I have done. I Recorded my Macro to copy values from one sheet to another and do some multiplication, this is where I get stuck, the Webpage...

Trying to create a macro that will add 2 new columns A & B with headers to each sheet in workbook. This code works to add columns for all worksheets, but only puts the headers in the 1st worksheet. Sub Insert_Columns() Dim ws As Worksheet For Each ws In ActiveWorkbook.Worksheets On Error...

Hello, I am a noob to VBA and macros. What I am trying to do is copy text into the middle of my formula which is a sumif formula...

Hi, Firstly thanks for looking :) I have a spreadsheet were I need to reset a range of cells, I have recorded a macro (see below) which will reset the range. There are 1100 ranges in total. What I am asking is, is there a way to click on a cell, any cell and run the below code. I know the...

Hello, I have a workbook with multiple sheets and I'd like to run this macro on all sheets. The code below will run on the first worksheet, but not on all. If anyone can see why it's not looping through all the sheets I'd appreciate it. <Code> Sub Add_On_Time_Or_Not_To_Each_Sheet() Dim ws As...

Hello everyone, I'm attempting to use a vlookup formula within my VBA code. I recorded a macro and attempted to remove as much noise as I could. However I continue to receive a "Run-Time error '1004' Application-defined or object-defined error. The code in bold red is the line of code that is...

I have a followup question to an earlier post. The formulas are all working great. However, I need for the coding to overlook 3 customers when selecting the "Top 5 Customers". These customers are GMIT, BGS GRM, and GMIT SC. I'm not sure how to incorporate this into what I have currently...

Hello, I am a beginner with macros and am having trouble. I have created a macro that creates a new sequential Invoice number upon opening a protected document. My issue is that several people in the company will be using this same document. How can I make sure that If several people have the...

This may be an easy one but I am just starting to learn all of this. below is a code that works great, only i would have to type it over and over again until i reach row 250 :( i want to loop through the E Column cell rows from 2 - 250 until it reaches the end. Any help would be greatly...

Hello, I'm finding the last row with data in my range and then I'm attempting to use the cell number in a formula. ''' firstRow = sht.Cells(sht.Rows.Count, "D").End(xlDown).Row lastRow = sht.Cells(sht.Rows.Count, "D").End(xlUp).Row Range("E1").Select ActiveCell.FormulaR1C1 = "Late /...

Hello, I have a macro that is pulling data from a sheet Cycle_14a_Output.txt. There will be multiple sheets used for this project, all name Cycle_XXa_Output.txt. I've added an input box to ask what the number of the file should be. How can I add the Input Data into the formula string? <Code>...

Hi All, I'm relatively new to creating macros but have been working on the attached code for some time, unfortunately it ends with an error which i haven't been able to eliminate. The problem line is highlighted in red text. Any help on the associated error would be much appreciated. Thanks in...

Hello I have below Data - and my end goal is to reach the data in next column - I have already recorded the macro but I want it to run till there is data on the left hand column - in my example I have only 20 rows. so what I am doing I just takin left data and adding it"" example - if 123 ---...

Hi Guys, Thanks in advance for your help!!! I am trying to edit an existing sheet that we have at work. There is a button that clears all previous records and then a 2nd button that resets the formula. (The VBA for resetting the formula is pasted below) When I hit the reset button all cells...

Hello I did my best to post using everything suggested but this is the best I can do. Here is a spreadsheet I am trying to work with. It is basically up to 200 rows and using columns A:H. I am also attaching my vba code. The code will add titles, formatting and some formulas. I am having...

Hi, I use the same bit of opening code on just about everything I ever work on (I know there are a lot of different ways of doing this): 'Finds last row of data on the Altos billing Nov 18 calls Sheets("Altos billing Nov 18 calls").Select LastRowWithValueAltos = Columns("A").Find("*", ...