type=xlfilldefault

  1. M

    Problem with autofill function?

    Morning all, Could you please help me out with my code - I'm simply trying to fill down from the cell with a formula (Rng2 in my code) but I'm getting error upon error. Rng2.AutoFill Destination:=Range("E2:E14"), Type:=xlFillDefault - gives me an error; as does Rng2.Select...
  2. B

    Setting up a Macro to run on a highlighted area

    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...
  3. H

    adjusting autofill range by referring to last row/column containing data in another sheet

    Im trying to find an addition to the code blow, which adjusts the 'Selection.AutoFill Destination:=Range("A1:JS5338")' options on sheets 2 and 3 is there a way to identify the last column and last row containing data in "sheet 1" and use this range automatically as the autofill option on sheets...
  4. L

    Destination:=Range -- want it to refer to the current cell

    Cell A4 has a date. I recorded a macro to go to the cell to the right, which is A4. Grab the handle and bring it down to cell A5 to give me the next date. Is there a way to change =Range("A4:A5") to reference the current cell? Selection.AutoFill Destination:=Range("A4:A5")...
  5. S

    AutoFill method of Range Class Failed

    I have formulas in ever cell from J3 thru BH3 Worksheets("Master_Week").Range("J3").Select Selection.AutoFill Destination:=Range("J3:BH2560"), Type:=xlFillDefault However the above code fails. Any ideas? Thanks
  6. montecarlo2012

    Loop - dynamic arrays - different worksheets

    Hello Everybody. PLEASE, I have two sheets and one dynamic array in each one, what I need is to subtract row by row one from another. On sheet 1 my array is for example purpose A1:F30, and on sheet 2 B2:G30 [in my workbook each are 6 by 2521 and growing]. this is the macro for better...
  7. H

    Adding a loop to a recorded macro

    Hello all, I recorded a macro that correlates a price series against an ascending sequence of numbers. The key steps are: 1) populate the adjacent column with ascending numbers i.e. 1,2,3,4,5... 2) Use the correl function to find the correlation between the price and the ascending numbers. A...
  8. V

    Randomly selecting items so that they don't repeat

    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...
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

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
Top