autofill 1004

  1. R

    Need help on code to copy formula from one cell to other cells in the row on a dynamic table

    Hi All, I am still learning VBA and currently, I am stuck on how I can copy formula from cell(1,1) on a table to new rows when the table expands (or new columns are added). Here's an example of my setup: Table1: PricesPerFruit <tbody> Fruit Price apple 1 pineapple 2 grapes 3 </tbody>...
  2. M

    Autofill last row error

    Hi guys, I know there are many posts on this topic. However I still could not figure out for my specific case. Please help. Thank you! It errors at Selection.AutoFill Destination:=ThisWorkbook.Sheets("Output").Range("A" & targetrow & ":C" & LastRow), Type:=xlFillCopy The full code is as...
  3. M

    On autofill to last row, getting Runtime Error 1004 'range of object'_Global' failed

    Hi all, Been struggling with this for a bit, figured it was time to ask for help. I have a bunch of formulas in columns B through R. I need to autofill these formulas from the second row (the first is headers) to the last row in my spreadsheet. The last row is dynamic based on data, so I've...
  4. J

    VBA Autofill

    Hi all, This is probably something pretty easy, I'm just not at all familiar with vba. I have a grade book that I am using for my class this semester. I have entered in it my 15 students names, with each of there 5 test scores in columns (B3:F3) and class average in column (G3). I would like...
  5. R

    Autofill from Activecell to Lastrow

    Hi All, My first post to the forum. Usually I find I am able to solve any problems I have by browsing historic posts and amending solutions to suit my needs however this one has me stumped. I have a worksheet with four columns (A,B,C & D) which is tens of thousands of rows long and grows each...
  6. M

    Excel Autofill Problem

    Hi, I'm having problems with a VBA script. The function fills in a sheet with some formulas. It works fine most of the time, however when I run it on a larger data set... it crashes with: Run-time error '1004': AutoFill method of Range class failed The debugger points to the last AutoFill...

Some videos you may like

This Week's Hot Topics

  • Check VBA code to locate value in cell
    Hello this is the current code I have [CODE=vba] Private Sub TextBox1_AfterUpdate() Dim m As String Dim rx As String rx = Trim(TextBox1.Text)...
  • Reverse Numbers Formula
    Hello Everyone! My computer is Asus My Operating system is Windows 10. Can someone please help me with a formula that I can drag down (or up) to...
  • Count If Issue
    Hi all, I'm trying to create an spreadsheet which counts certain words in a cell only once and gives me a total. I can do this but some of the...
  • VBA Check for multiple cell values and copy the cell in column A
    Hello! So I have this code that checks for the values in column "L" in this case it's 25. But I want to change this code so that it actually...
  • Sending mails to specific recipients based on a cells value
    Good morning, I am trying to get excel to send out an email to different sales reps. So if row X is an error code of "999" then excel needs to...
  • Matching Number in Textbox
    Hello Excel Users, I come with a request. Hope all are doing fine. So I have 1 textbox to type in numbers etc. 12345 (it will always be 5...
Top