filldown

  1. M

    Copy down formula using VBA

    Hi I'm trying to copy a formula from cell B1 and paste it into a fixed range of cells (B7:B11). But it's not working, as expected? I used this Range("b1:b1").copy Range("b7:b11").FillDown But it didn't work. Any ideas why? TIA
  2. K

    Autofill Filldown issue VBA

    Hi, I have 'Master' formulas in I1:Q1, all are formulas except col. O which has a static number that I wish to be copied down. The vba copies the 'master' formulas and pastes formulas into I9:Q9 to then populate to end of data based on data in col G. Autofill is working well for the formulas...
  3. M

    vba code doesn't work; same code works as a macro

    <code> Sheets(studentBlad).Select ActiveSheet.Cells(3, kolom).Select ActiveCell.FormulaR1C1 = "='" + naamSp + "'!RC[1]" ActiveSheet.Cells(3, kolom).Select Range(Cells(3, kolom), Cells(10, kolom)).FillDown </code> The above does what it's supposed to do when I use this in a...
  4. B

    VBA FillDown vs. Autofill errors out

    Hi there, I am having trouble (seemingly) with the syntax / usage of "FillDown" in the code snippet low. I have a varying number of rows (number of rows added each day change drastically) in column C of a dataset. I then have a unique numeric code that populates column B down to the last row...
  5. S

    Unable to Filldown from Date Variable in VBA

    My goal is to find the most recent date in column A (the date in column A is determined by a formula) and filldown one row from the most recent date in column A through column T. I am able to locate the most recent date in column A utilizing Max_date =...
  6. M

    Filldown when don't know Column reference other than by Header Name in VBA Macros; Excel 2013, Windows 10

    Good day all, I posted a much wider subject here: https://www.mrexcel.com/forum/excel-questions/1075442-referencing-columns-based-header-names-vba-macros-excel-2013-windows-10-a.html but am not getting much responses so I decided to break it down a bit with a few edits I've been working with...
  7. J

    VBA Filldown

    I am in need of assistance with perfecting my current macro. I have a spreadsheet with 49 account numbers in column A. My objective is to duplicate those 49 account numbers to a certain number of rows. For example, I need account # 654189 to be in column A from row 2-213. Then I need...
  8. B

    FillDown Formula Run-Time error

    Hello, I use the filldown feature in vba to enter formulas into my cell range. I'm trying to enter the following formula into my cell range but and getting an error. I don't see what the problem is. I'm hoping one of you can. Thanks in advance for your help. Range("BS3") = "=IF(AND(BO3 >...
  9. S

    Excel Table - FillDown formula from top row in respective column

    Hi there In the Excel table from the attachment, starting from column EQ, I would like to have the VBA filldown the formula in row 6 of each column for the respective column. This is what I have so far: Sub EnableFormulas() Dim Lastrow As Long Application.ScreenUpdating = False Lastrow =...
  10. L

    FillDown in VBA

    Hi, Can someone please help...I have a macro where an input box prompts a user to input a single date...it's only a single date that needs to be copied down based on the length of an adjacent column: myResponse = InputBox("Date EMAIL Recieved in MM-DD-YYYY Format") Range("F2") = myResponse...
  11. L

    Fill down formula to end

    Hi I know this question has been asked in many guises, but the answers don't seem to help and are all specific to the question. Basically, I am copying data from varying spread sheets into one worksheet. Each time I paste the data into the spread sheet I want to label each data set depending...
  12. A

    Fill down non consecutive formula from one sheet to another

    Hi, I need to fill down the formula in cells A1, A5, A9, A13, A17, A21, A25 from Sheet 2 into cells A1:A6 in Sheet1. Attached Workbook should hopefully explain exactly what i need. https://www.dropbox.com/s/6d7ypsj10gnl6z1/book2.xlsx?dl=0
  13. M

    Need a VB Autofill solution

    I pull reports that has data in columns A thru AD but the rows of data can vary. I am trying to write a simple VB code to paste 8 formulas in rows AE thru AL and paste them down to the end of the data set but I keep getting an error on the 4th line where I try to define "LRow". If I remove...
  14. H

    How to use FillRange in a single cell?

    Hi All My code works if I have more than 3 rows in current region. When I have 2 rows the source range and end range are the same IE a cell at activecell offset 1,5 Therefore the fillrange doesn't make sense. How do I get this code to "copy and paste" in the same cell? Spreadsheet example ...
  15. L

    VBA How to FillDown with linear..Based on Cell value

    Hi Boys & Girls, Please, help me.. I have this: ColumnA ColumnB SN qtty ac227 3 cz122 2 7787 4 And i need this: ColumnA ColumnB SN qtty ac227 3 ac228 ac229 cz122 2 cz123 7787 4 7788 7789...
  16. J

    FillDown user selected cells to last used row in Column A

    The code I have below works great if I am only selecting one cell. I need the sub to work on multiple cells at once. The current code allows me to select multiple cells but only does FillDown on the first selected cell. I have searched for a solution but have yet to find one. All solutions that...
  17. Gingertrees

    Speed question: which is faster: loop to add formula, or fill-down?

    I currently have a macro set up that loops through used rows to add a different formula to column A, B, C, D, and E. So it applies the formula to A3, then another formula to B3, etc. to E3. Then it loops and does the same to A4, B4, etc. to the end of range. Is this the fastest way, or would...
  18. 9tanstaafl9

    How do I filldown an array using VBA? Or copy and paste one?

    I need to use VBA to either filldown or copy and paste a cell that contains an array. I have to admit, I don't even know what an array is, I'm trying to clean up someone else's report. (Never again!) Anyway, when I try to use VBA to filldown, or to copy and paste, it "works" fine and pastes...
  19. R

    VBA Calculations Update with Pivot table Changes

    Hello, First time posting, long-time user. I have searched far and wide to find a solution to the issue below. I am a novice in VBA but I am trying my best to get better. I have a Pivot Table that will update based on the selection of the region. To the right of the Pivot Table are manual...
  20. B

    VBA Vlookup variable range

    still learning VBA and frequently bumping up to some errors. I currently have the following issue: I have an excel with 2 worksheets (FORM and DATA). sheet DATA contains 2 colums of data: A = lookup value. B = value to be returned. Range (A:B) is named data. sheet FORM column B contains the...

Some videos you may like

This Week's Hot Topics

  • Problem with Radio Button's format control
    I am creating an employee evaluation template (a sample is below) Column A is the category Column B, C D, E and F will be ratings (unacceptable...
  • Last Display on userform to a Listbox
    [CODE=vba] lstdisplay.ColumnCount = 15 lstdisplay.RowSource = "A1:O600000" [/CODE] So when i do this it Displays everything on the sheet i am...
  • Rename and move files to a new location
    Dear all, I have an excel file with the following information. The actual file name is at column A but i want to rename it using the following...
  • Help with True/False Formula
    Hello! Am stumped how to fix this formula, in which my result returns 'True', but it should return False. =IF(AG2=True...
  • Clear extra characters from a provided range of cells
    Dear All, I have following code which gives me desired output to remove extra characters from a provided range. But it takes too much time when...
  • Help with Current and highest streaks
    Hi there, I've just joined the forum and this is my first post. I've already spent quite a bit of time searching the net and this forum for a...
Top