autofill 1004

  1. E

    AutoFill to right to variable destination

    Any Assistance is greatly appreciated. I have 2 sheets. sheet 1 has a variable list of numbers in column A. Sheet 2 has a variable list of names in Column A. the formula moves the names to the right based on the number in each corresponding cell in sheet 1. once this is done, the formula then...
  2. 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>...
  3. 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...
  4. 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...
  5. 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...
  6. 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...
  7. 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...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top