activecell.formular1c1

Get an error message: compile error: method or data member not found at each of the two lines starting with selection Sub Accrual_Provision() Sheets("backing").Activate ActiveCell.FormulaR1C1 = "Accrual October" ActiveCell.FormulaR1C1 = "=+R[-8]C[-1]/9*10" Range("F41").Select...

Hello, The computer system my company uses exports to excel in an ugly and unusable way. Normally i manually sort the data but I recently took an excel course and learned a bit about macro's. I have a macro set up to auto format the data but i was wondering if it can be set up to run on a...

Can somebody help me with this macro I want to run this macro until it reaches a blank cell. Thank you very much for your help. irenesboy Macro1 Macro ' FormatSchedule ' ' Range("A3").Select Application.CutCopyMode = False ActiveCell.FormulaR1C1 = "=R[1]C" Range("A5").Select...

Hello, I have a VBA code that I had made, but having a difficult time making a table from it. It has to be from a current selection, instead of A5 as it is never in the same cell in each workbook. Can someone help me? Sub template() ' ' template Macro ' ' ActiveCell.Select...

How to use variables inside activecell.formular1c1?

Hi. My table length will vary week to week. I want to put data in column A, only if there is data on the same row in column F. My macro at the moment is... Range("A1").Select ActiveCell.FormulaR1C1 = _ "=IF(iserror(VLOOKUP(RC[5],Sheet1!C,1,FALSE)),""yes"",""no"")"...

hi,pls help. i have a main excel 2016 with a vba code in a button. In sheet param, colum A is date and column B is file name.. After input the date DD-MON-YY e.g "09-Oct-18" and file name can be anything prefix with the "_09-10-2018.xlsx";in that sheet 'Param'.;; I want to use that data...

Hi, So in my macro I have Dim TradeDate As Range Set TradeDate = Active sheet.Range("AA1") Sheets("Sheet1").Activate Range("A1").AutoFilter Field:=4, Criteria1:=TradeDate The filtered results are good in my pivot table But when I need this in another macro with the same date: Dim TradeDate...

This formula was written while recording a Macro. Works perfectly fine in a cell , but when trying to run from VBE ,its throwing a runtime error '1004'. Any help appreciated .... Thanks in Advance Sub Macro7() ' ' Macro7 Macro ' ' ActiveCell.FormulaR1C1 = _...

I need to include a line that will find the next blank cell in column A and then run the macro. Here is the macro as it is now: Sheets("Sheet2").Select Range("A1").Select ActiveCell.FormulaR1C1 = "=NOW()" Range("A1").Select Selection.Copy Selection.PasteSpecial...

Hi all, I want my sheet to delete all conditional formatting when I process my sheet see code. where can I put a code in the below vba code? Private Sub LoginButton3_Click() If TextBox1 = "5555" Then ActiveSheet.Unprotect password:="5555" ActiveSheet.Unprotect...

Hi, am looking at a former colleagues spreadsheet, and I am trying to determine where h data is company is? But am at a complete lost???? please help, code is below: Sub Fileoutput() ' Applies combination of corrections and successfull lookup data into format ready for upload Dim C, D...

I'm very new to VBA and have not found the answer in other posts. Hoping you can assist. I need the formula provided below to continue past cell 83, as I'm going to be reusing this macro on other data that may be larger than 83 lines. How do I essentially tell it to read ALL cells in the...

I have a workbook which contains a startup script which works when opening this workbook manually. Now this is a viewer and is sometimes changed by an other VBA script. People who use this viewer sometimes need to refresh this document without saving. The script below is written to reopen the...

I can not figure out a multiple count if macro. Basically i want it to search a column (read d2:d3000) and find a set of letters such as "CB", "KP2" and throw out all the counts. I tried to record the macro then put multiple lines in but this did not work. can someone assist? below is my...

I have folder with many files, which the code below is applied on. So the process is to select the folder which have the files. The code open first *.txt file in excel, do some calculations save the *.txt file to *.xls file (Waveform_Freq-140.0_PC-10.0_KKC-2.0_180817-143116), copy/paste...

I need to apply below code on about 3000 files and each file have 300K rowsx 4columns. With the code below each file take about 5 minutes to complete, so to do this on all files will take me couple days. Is there a way to make this happen faster? (I need to also add, I'm very new to VBA and...

Good morning! I have a macro that functions as it should but is slow. The macro strips out all of the report and page headers from the text file dumped from the AS400 and organizes the sheet in the desired manner. I realize that part of the reason it's slow is the size of the worksheet it's...

I've only started to learn macro. I need to work on a spreadsheet everyday (different number of rows) to basically do the following: 1) In worksheet "Combined", find the total amount of "deposits" for each account (column "J") and also total number of items on deposit (column "M"). 2) Copy the...

Hi Again... good nights.. I try to adjust this formula to somthing that works... i have something like this.. Range("D18").Select ActiveCell.FormulaR1C1 = "=AVERAGE('[Calculadora Tecnica JULIO.xlsm]IN Y CS'!R18C4:R18C37)" Range("D18").Copy...