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

Some videos you may like

This Week's Hot Topics

  • Sort code advice please
    Hi, I have the code below which im trying to edit but getting a little stuck. This was the original code which worked fine,columns A-F would sort...
  • SUMPRODUCT with nested If statement
    Hi everyone, Hope you're all well. I'm hoping someone will be able to point me in the right direction with a problem I'm having with a SUMPRODUCT...
  • VBA - simple sort is killing me!
    Hello all! This should be so easy, but not for me, apparently! I have a table of data that can be of varying lengths and widths. My current macro...
  • Compare Two Lists
    I have two Lists and I need to be able to Identify differences between them. List 100 comes from a workbook - the other is downloaded form the...
  • Formula that deducts points for each code I input.
    I am trying to create a formula that will have each student in my class start at 100 points and then for each code that I enter (PP for Poor...
  • Conditional formatting formula required for day of week and a value
    Hi, I have a really simple spreadsheet where column A is the date, column B is the activity total shown as a number and column C states the day of...
Top