Results 1 to 4 of 4

Auto Fill not working

Threaded View

  1. #1
    Forum Contributor
    Join Date
    11-20-2009
    Location
    Melbourne
    MS-Off Ver
    Excel 365
    Posts
    288

    Auto Fill not working

    In the attached workbook I have code that I want to auto fill in Column C to the last populated cell in Column B.
    I have done the same thing in Column B which works fine, but then when I play the code, the Column C doesn't auto fill.
    What am I missing/doing wrong?
     Columns("C:C").Select
        Selection.Insert Shift:=xlToRight, CopyOrigin:=xlFormatFromLeftOrAbove
        Range("C1").Select
        ActiveCell.FormulaR1C1 = "WS"
        Range("B2").Select
        ActiveCell.FormulaR1C1 = _
            "=IF(AND(RC[-1]=R[-1]C[-1],RC[3]=R[-1]C[3]),R[-1]C+1,1)"
        Range("B2").Select
      Selection.AutoFill Destination:=Range("B2:B" & Range("B" & Rows.Count).End(xlUp).Row)
        Range(Selection, Selection.End(xlDown)).Select
        Range("C2").Select
        ActiveCell.FormulaR1C1 = "=IF(RC[-1]>R[1]C[-1],""L"","""")"
        Range("C2").Select
        Selection.AutoFill Destination:=Range("C2:C" & Range("C" & Rows.Count).End(xlUp).Row)
        Range(Selection, Selection.End(xlDown)).Select
     Columns("B:C").Select
    Attached Files Attached Files
    Last edited by coach.32; 06-18-2019 at 06:34 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. auto fill not working for data above empty cell
    By mrl in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-28-2017, 11:11 AM
  2. Macro auto fill is not working
    By Ashkan.1984 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-14-2016, 07:46 PM
  3. Auto fill / flash fill not working with formulas?
    By mhorga in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 04-18-2016, 12:54 PM
  4. Auto fill cell based on Drop Down List not working
    By cbcruz in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 04-14-2014, 10:35 AM
  5. [SOLVED] Formula to auto-fill Index/Match not working
    By rajncajn in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 06-18-2013, 09:21 AM
  6. Auto Fill stopped working...
    By Nickster64 in forum Excel General
    Replies: 1
    Last Post: 04-03-2009, 01:05 PM
  7. Replies: 1
    Last Post: 07-13-2007, 10:59 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1