+ Reply to Thread
Results 1 to 12 of 12

Formula Fill Down but what if all rows are full!

  1. #1
    Forum Contributor
    Join Date
    03-14-2013
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    491

    Formula Fill Down but what if all rows are full!

    Hi,


    In the code below I want to fill column T based on the length of column A.
    But column A goes to the last possible row in the worksheet making the lastrow = 1 again. How can I work around this?

    Please Login or Register  to view this content.

  2. #2
    Forum Expert
    Join Date
    12-14-2012
    Location
    London England
    MS-Off Ver
    MS 365 Office Suite.
    Posts
    8,448

    Re: Formula Fill Down but what if all rows are full!

    Please Login or Register  to view this content.

  3. #3
    Forum Contributor
    Join Date
    03-14-2013
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    491

    Re: Formula Fill Down but what if all rows are full!

    Quote Originally Posted by mehmetcik View Post
    Please Login or Register  to view this content.
    why A100000?

  4. #4
    Forum Guru
    Join Date
    08-26-2007
    Location
    London
    Posts
    4,606

    Re: Formula Fill Down but what if all rows are full!

    Have you really used all 1 million + rows?

  5. #5
    Forum Contributor
    Join Date
    03-14-2013
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    491

    Re: Formula Fill Down but what if all rows are full!

    Quote Originally Posted by StephenR View Post
    Have you really used all 1 million + rows?
    The last row my spreadsheet goes to is 65536

  6. #6
    Forum Guru
    Join Date
    08-26-2007
    Location
    London
    Posts
    4,606

    Re: Formula Fill Down but what if all rows are full!

    Your profile says you are using Excel 2010 which has more than a million. Sounds like you are using 2003.

  7. #7
    Forum Contributor
    Join Date
    03-14-2013
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    491

    Re: Formula Fill Down but what if all rows are full!

    Quote Originally Posted by StephenR View Post
    Your profile says you are using Excel 2010 which has more than a million. Sounds like you are using 2003.
    Yes this is true I have 2010 at the crib but Im using a different computer with 2007.

  8. #8
    Forum Guru
    Join Date
    08-26-2007
    Location
    London
    Posts
    4,606

    Re: Formula Fill Down but what if all rows are full!

    2007 also has a million.

  9. #9
    Forum Expert
    Join Date
    12-14-2012
    Location
    London England
    MS-Off Ver
    MS 365 Office Suite.
    Posts
    8,448

    Re: Formula Fill Down but what if all rows are full!

    What is the max no of rows that you would enter?

    Double that and you might be safe.

  10. #10
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: Formula Fill Down but what if all rows are full!

    If you only see 64K rows, you're in compatibility mode. Save as an xlsm file (if it's not already), then close and reopen.
    Entia non sunt multiplicanda sine necessitate

  11. #11
    Forum Contributor
    Join Date
    03-14-2013
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    491

    Re: Formula Fill Down but what if all rows are full!

    I see compatibility mode but when I followed your instructions to save as xlsm, No dice. It re-opened with 65536 as the number of rows. I'm assuming I am using version 2003 if that's the case...

  12. #12
    Forum Contributor
    Join Date
    03-14-2013
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    491

    Re: Formula Fill Down but what if all rows are full!

    Quote Originally Posted by swade730 View Post
    I see compatibility mode but when I followed your instructions to save as xlsm, No dice. It re-opened with 65536 as the number of rows. I'm assuming I am using version 2003 if that's the case...
    I just checked, it's 2007! what gives!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Working code need to be expanded to full fill the need.
    By abjac in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-13-2014, 02:19 AM
  2. [SOLVED] Full fill amount with year ages criteria
    By Jhon Mustofa in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-02-2014, 08:15 PM
  3. Inset rows & fill that rows base on formula.
    By johncena in forum Excel General
    Replies: 9
    Last Post: 02-15-2010, 05:13 AM
  4. Replies: 1
    Last Post: 08-10-2009, 03:34 PM
  5. Enter last name, auto fill full name & address--HOW?
    By ana maria in forum Excel General
    Replies: 3
    Last Post: 02-25-2005, 06:06 PM

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