activecell.formular1c1

I am very basic at macros and I need some help. I recorded the below macro and I need it to repeat but for all the rows. This was just using the record macro button so I did not do all the coding. A little explanation: I have a table that is a calculator. I have a project that has a range of...

Good Morning, I am attempting to update my excel code as originally split he code per quarter. I have fixed most issues to make the code generic, what I am having issues on is a formula to do a vlookup. any suggestions to complete the fix. ActiveCell.FormulaR1C1 = _...

I have a template sheet called "template" that I'd like to apply to all sheets starting on the 4th. How do I loop through each sheet, apply the format and do some other functions. I posted a macro I create to do it manually. But it needs to dynamically take the value in A9, paste into the range...

How do I have the macro automatically calculate a column where the row number length changes: (Below is my macro) Range("R2").Select Selection.End(xlDown).Select Range("R2333").Select ActiveCell.FormulaR1C1 = "=SUM(R[-2331]C:R[-1]C)" Range("R2334").Select

I am looking for help with a print macro I previously had when using a windows and no longer works on my Mac. When I try to re-record the macro it doesn't recognize the print function and when I tried to copy and paste the code I used on my PC it didn't work. I essentially need it to pull the...

Hi all, A pretty simple one but in need of advice. The quickest way to populate cells P1:P25 with values 1-25. I recorded the following macro and am using that, but i am sure there is a quicker way to generate the numbers. Sub record1_25() ' ' record25 Macro ' ' Range("P1").Select...

Hi I have a macro which is copying and pasting a vlookup. How do I get it top running hen the data the spreadsheet runs out? instead of giving it an line number to end on as below: Sub vlookup() ' ' vlookup Macro ' ' Range("N2").Select ActiveCell.FormulaR1C1 =...

From a report, the data within one column will have multiple line breaks within the cell which I parsed out via marcro. Here is an example the layout of the mentioned cell: <tbody> Full Text: Here is the full sentence Description: Here is the full description for support. Type (1): Color...

I have dynamic report that will grow by about 200 rows per day. I'm new to VBA and trying to get the formulas to only calculate based on Active or filled rows. Any help would be great: Sub step1() ' ' step1 Macro ' ' Keyboard Shortcut: Ctrl+r ' Columns("W:W").Select Selection.Delete...

Hello, I am getting the following error message when attempting to run my Pivot table code. "Object Required" What am I doing wrong? Full code: Sub FilterRatedAuditsImpactingOT() ' ' Rated Audits Impacting O&T Chart Macro ' Created by Miriam Hamid ' Created on 5/11/2018 'Declare Variables to...

Hello, I am fairly new to Oracle Smart View and have been recently assigned to debug an issue with establishing a connection to our National Sales connection. Establishing a connection requires logging in with a username and password. How do I properly establish a connection to National...

Hi all, I have a vba set up already that works perfectly. Shown below (Any simplifications would be brilliant) Sub sbVBS_To_Delete_EntireRow() Rows(1).EntireRow.Delete ActiveSheet.Name = "Master" 'Updateby20150707 Dim Rng As Range Dim xInterval As Integer Dim xRows As Integer Dim...

HI Team need help below macro is running for all the sheet , could you please help with the code so that it should not run for Sheet1,Sheet2,Sheet3 Sub Test111() Dim ws As Worksheet For Each ws In ThisWorkbook.Worksheets ws.Activate Range("A500").Select ActiveCell.FormulaR1C1 =...

Folks please help - Trying to create a macro using "Record Macro" but I have a static fields on my range please see below: - Those are all 350... I want the last range to be the same range as the last range from A1 column, how do I do that? thank you!!! Selection.Copy...

Hello Everybody. PLEASE, I have two sheets and one dynamic array in each one, what I need is to subtract row by row one from another. On sheet 1 my array is for example purpose A1:F30, and on sheet 2 B2:G30 [in my workbook each are 6 by 2521 and growing]. this is the macro for better...

Hi. I have a macro that selects multiple sheets and is supposed to be applying formula's to all sheets. However, the formula's are only being applied to half the sheets and I don't know why. I am not getting errors when it's selecting the sheets and I can see that all sheets are selected...

Hello all, I recorded a macro that correlates a price series against an ascending sequence of numbers. The key steps are: 1) populate the adjacent column with ascending numbers i.e. 1,2,3,4,5... 2) Use the correl function to find the correlation between the price and the ascending numbers. A...

I want to enter the following formula's in two cells: Range("D61").Select ActiveCell.FormulaR1C1 = "=SUM(D58:D60)" Range("D63").Select ActiveCell.FormulaR1C1 = "=COUNTIF(IG_TxnHist[ProfitAndLoss];"">0"")-1" the result in D61 is =SUM('D58':'D60') and returns a #NAME ? error. How...

Hello, I created this code to apply this formula to the first row and then copy it down until the end, but then it does not work if the data/table only has one row. My code is below if anyone can help that would be great, I think it may just be something I am forgetting. thanks! 'Days Aged...

I have macro written that i want to repeat on several text files. How can i have the macro prompt me to select the file I want ? My Macro is as follows: Sub Import() ' Import Macro ' ' Keyboard Shortcut: Ctrl+a ' With ActiveSheet.QueryTables.Add(Connection:= _ "TEXT;Z:\Davids\File...