Consulting

Results 1 to 4 of 4

Thread: Solved: Fill formulas to end of column

  1. #1
    VBAX Regular
    Joined
    Apr 2006
    Posts
    32
    Location

    Solved: Fill formulas to end of column

    Being a VBA noobie, ,I am having trouble with the following:

    Column length for "S:S: varies with spaces between lists
    Formulas in ("T8:Z8") are constant
    I need the formulas in ("T8:Z8") to fill, down through their respective columns, through the last entry in column "S:S", including the spaces between lists in "S:S".

    Can anyone help a noobie?
    Many, many, thanks if you can!

    R1C1
    Last edited by R1C1; 04-03-2006 at 08:38 AM.

  2. #2
    VBAX Expert Shazam's Avatar
    Joined
    Sep 2005
    Posts
    530
    Location
    See if this helps.

     
     
    Range("T8:Z" & Cells(Rows.Count, "S").End(xlUp).Row).FillDown
    Application.CutCopyMode = False

  3. #3
    VBAX Regular
    Joined
    Apr 2006
    Posts
    32
    Location
    And Shazam, it is done. Thank you so much. With your quick post to my problem, I see I have a lot to learn.

    R1C1

  4. #4
    VBAX Mentor
    Joined
    Jun 2005
    Posts
    374
    Location
    hello
    please provide numerical example.
    moshe

Posting Permissions

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