activecell.formular1c1

Hi! This time I am really stuck. I have two workbooks Workbook1 (main file - named: h:\dekstop\somethingneweveryday.xlsm) Workbook2 (data file - named: H:\desktop\blomst.xlsx) I do my work in Workbook1. I use a macro in workbook1 to open and activate Workbook2 and do some stuff and collect...

Hello, I cannot program. I tried to make a macro and succeeded. But I would want to repeat the macro until the end of numbers in the table. Can you help me? Here is the macro: Sub Tulostuskollilappu() ' ' Tulostuskollilappu Makro ' ' Range("A9").Select ActiveCell.FormulaR1C1...

Book1ABCDEFGH1Name1-Dec8-Dec15-Dec20-DecAverageCurrent week - Avg%2Cognizant$5$4$4$9$4$5108%3Credit Suisse$6$7$8$10$7$343%4Dominos$3$6$7$8$5$350%Sheet1 Column A have Name Date starts from Column B1 and is dynamic i.e. depending the no. of dates, the range will differ from B1 to X I want to...

Hi All, I am creating a sheet in which I have to select 5 random items out of 20 items. However, if 5 items are selected in round 1, round 2 should have 5 values from the remaining 15 items, round 3 from the remaining 10, and at last the remaining 4. I am using following code but there is an...

Hey Guys! Basically what happened is that one of our data suppliers changed his format a bit in excel. We have a macro for it however now it does not work every time, because it sometimes comes in a different format. So the macro works like this: The cells get unmerged, and after that, in all...

This code is supposed to be a simple copy some columns from one tab and paste them on another. It appears to be functioning, but no values are being pasted. Private Sub CommandButton1_Click() ' ' To unprotect sheet without password ActiveSheet.Unprotect ' Copy Over Columns...

Hello, I really need some help! Keep in mind that I use the Record Macro function liberally, so this may have to do with my limited knowledge of actual coding procedures. But here goes my explanation: In Macro Excel VBA, I've coded into VBA the formulas of SUMIFS functions for each column...

Hi All, Can you please help me by adjusting this VBA for autofill until empty and not until cell "C346"? Thank you very much!! ' Keyboard Shortcut: Ctrl+y ' Columns("A:A").Select Selection.ColumnWidth = 8.57 Columns("A:A").EntireColumn.AutoFit...

<tbody> Day Total Orders Total Late % Late % on-time February 1, 2018 February 2, 2018 February 3, 2018 Average on-time % #DIV/0! </tbody> I use a table similar to this each month (entire date range of the month) to calculate our companies on-time delivery percentage. I...

Greetings everyone. I am brand new to this but hungry to learn. I have searched for the answer to no avail. I have 4 sheets in a workbook and sheet 2 is named InvoiceNumbers. Sheet 3 (MonthlyInvoices) is where I have a commandButton2 with the following code that I have scraped together....and...

Hello I have some data in the column A , would like to convert it to L shaped Long in related cells. Please hit the F8 to see what is happening! Thank u. Sub FillDataToL() Range("A1").Select ActiveCell.FormulaR1C1 = "W18" Range("A1").Select Selection.AutoFill...

Is there a way to modify this so that in March, it will transition automatically to April, April -> May and so forth? Sub NewMonth()' ' NewMonth Macro ' ' Keyboard Shortcut: Ctrl+Shift+S ' Sheets(2).Select Sheets(2).Copy Before:=Sheets(3) Sheets(3).Select Sheets(3).Name = "March...

I have this macro that I just recorded using the macro recorder and it is way too long and messy. I would like a more efficient way of how to do this (so I could write something like this on my own). I have 6 columns in a report where i want to insert a blank column, rename each one of them and...

Hi, I am very elementary when it comes to creating macros and code. I have a macro that was given to me to run on data that I exported from an application with only certain columns. This macro is supposed to format the data as needed for meetings. I am trying to run the macro and getting the...

I have code that copies a formula down a range. I want to past the Values over the formulas once they are calculated. Do I have to recopy the paste area and then do a Paste Value? or can this be done in one step? Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As...

Hi, i'm in need for some assistance. my code is not working :confused: the macro is supposed to pivot the data but i don't know why the code doesn't run / can someone simplify the code. Thanks in advance Sub PREP() ' ' File preparation Macro ' Application.ScreenUpdating = False...

Hi I am trying to place in column A, a list of numbers from 1, 2, 3, 4, etc. At the moment, I am using the following VBA code. Could any one recommend a more efficient way? Thanks in advance Range("A1").Select ActiveCell.FormulaR1C1 = "1" Range("A2").Select...

I have realized that I go through a cycle of writing basic macros every so often at work. I have pieced together some more advanced over the years but have since forgotten them. I have a basic form that I want to automate into a sheet that can be used to input data into an access database. Due...

I've got a spreadsheet which has been processed up to a certain point. Then I want to autofilter it and add a tag to just the visible cells. This code shifts a column over, adds the columns for the new tags, but then doesn't fill the visible cells with the tag. Any help appreciated! Sub...

Sub COPYonRowsAndColumns() ' PLEASE help me to make this easier Range("BB1").Select ActiveCell.FormulaR1C1 = _ "=SUM(--(MMULT((RC11:RC12=R88C54)+(RC11:RC12=R88C55),{1;1})=2))" ' =SUM(--(MMULT(($K1:$L1=$BB$88)+($K1:$L1=$BC$88),{1;1})=2)) ' inside cell...