activecell.formular1c1

Hi, Really hoping somebody can help please, as I've been going round in circles with this for ages. I did have some better code than that below, but I deleted it and instantly regretted it (I was so close!). Anyway, here's what I'd like to do: 1) On 'Delete Sheets' I have a list of company...

Hi There is bound to be a simple solution to this as I am probably doing something very basic wrong! I have a workbook with 1 worksheet from a Salesforce report download (so random name - "report***************"). I am making some changes on the sheet and then copying it to a new sheet titled...

HI, I have the below code and I want to drag the formula down tothe last row, that part is working fine. I have tried two different ways of doing this but are givingthe same result. The problem is the code is dragging the formula for "B4:AEN4"the whole way. I need to the formula to...

Hi, I have the below code which joins all of my cells into one column, now I would like to add a "|" separator at the end of each cell before they are joined into one cell. If someone could advise the best way to do this in this code that would be great. Sub JoinCells() Dim lastrow As Long...

I am using the link below to rea a cell in another closed wb. And it works. Except I need to fill a range and when I look at the formula in the cell it is posting as $A$2 instead of A2 so I can not drag it. What's wrong? ActiveCell.FormulaR1C1 = "='Z:\.. M C T...

Hi to all, iam new here and stuck atone point. Desperately need help. I have a macro which is working only for a single transaction. What it does is, it take value from INPUTsheet.A2 cell then runs SAP gui, SAP gui exports a excelfile(SAPTO.XLS) to temp location. Then macro opens the file...

Hi, I created a script to created three separate equations in columns, P, Q and R. I have it working up to autofilling down for P and Q, but am now getting a Run time 1004 error when it tries to auto fill down from R2 to wherever the bottom would be. Any suggestions would be helpful! Sub...

I have issue which I hope someone can suggest a solution for. I have several *.csv files in a folder, which my program can open and convert to *.xls-file. What I need to do is to make a chart in every new open *.xls in an certain range. The file name and sheet name is for example "Wv_B-2_Fre"...

Range("Q2").Select Application.CutCopyMode = False ActiveCell.FormulaR1C1 = _ "=SUMIFS(Variation!C[-5],Variation!C1,RC11,Variation!C3,RC13,Variation!C4,RC14)" Range("Q3").Select ActiveCell.FormulaR1C1 = _...

Hey guys, I get extensive daily reports in the form of workbooks with multiple sheets. I have a master workbook with multiple sheets as well. We operate by shift numbers. In the master workbook, I have shift numbers in columns. For example, row 8 is shift 5, row 9 is shift 6, row 10 is shift...

Hello I generated a macro through the recorder and it generated the following code: ActiveCell.FormulaR1C1 = _ "§ 4,795.............. What does the =_ mean? Also, is it possible to use multiline text/code for the ActiveCell.FormulaR1C1 ? Thanks!

Hi Everyone, Any help here would be greatly appreciated! I've tried checking trust settings, etc. on other people's computers, they're set to allow macros. I'm getting run-time error 438 when i run this code on other's computers. Any idea why? I red fonted/underlined the line of code that the...

Hey, I am working on some VBA macros for work but have ran into some trouble with the auto-sum function...basically I have various data-sets on the same sheet that I need to auto-sum the total for in column K but the problem lies in that there are 3 blank rows between each set of data...I have...

Hey guys, I am trying to make a cost template easier on the end user and want to have 1 or 2 macro buttons to create the cost file. I have the listed VBA code below to reference a list and create worksheets based on the quantity and titles in the list and then create hyperlinks to the newly...

This allows user to select multiple .csv sheets and then summarises them, saving the summary alongside the originals. What I want to happen at the end is for the Macro enabled book to be left open so that the user can then do another summary, or manually close it. I cannot seem to get this to...

Hello, I have 4 worksheets in my workbook labeled, Baltimore, Owings_Mills, Towson and Westminister. Column A has a title in cell A1, A2 is blank and additional subtitles in cells A3 & A4 and then the names of the customers in cells A5 to the bottom row (this is never the same number of rows...

Hi guys. Im just starting out with VBA in Excel, and have a question like millions before me, anyway it goes like this. I want to add my own column header names using VBA , and have used running a macro with success, but now want to shorten the code to a few lines of code rather then about 20 +...

Hi Got to be a way to do this I filter by column A and it shows if any cells are blank but text in B to G I manually type in Blank I use a simple macro to do this bit it only works in the last cell is there a better way below is what I use. ActiveSheet.Range("$A$1:$G$3000").AutoFilter Field:=1...

Hi all, I have the below macro. I am trying to get it to loop. Where each time the R[-1] part increases by 1 and keeps repeating until it finds an empty cell Sub Test Sheets("Sheet1").Select Range("C3").Select Application.CutCopyMode = False ActiveCell.FormulaR1C1 =...

my end goal is thatevery month you run the macro and get : "**this month** pricing" and"**next month** pricing" I get an #Name error when I run this. =MONTHNAME()&" Price" Selection.Insert Shift:=xlToRight, CopyOrigin:=xlFormatFromLeftOrAbove Range("U1").Select...