Page 4 of 4 FirstFirst ... 234
Results 31 to 37 of 37

Thread: Filling formulas over to the right into a new column added

  1. #31
    Board Regular
    Join Date
    Mar 2013
    Posts
    793
    Post Thanks / Like
    Mentioned
    8 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Filling formulas over to the right into a new column added

    What I did:
    via input box added competitor_16, it was X:X should have been W:W
    Selected entire columns R, S & T together and deleted them
    via input box added competitor_15 back in.
    now adding competitor_16 it's W:W
    and adding competitor_17 it's X:X

  2. #32
    Board Regular
    Join Date
    Aug 2019
    Posts
    127
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Filling formulas over to the right into a new column added

    It is working for now. I have a feeling this is going to be one of those things that causes problems down the road. Thank you for this. You saved me a lot of stress.

  3. #33
    Board Regular
    Join Date
    Aug 2019
    Posts
    127
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Filling formulas over to the right into a new column added

    As expected, the problem returned. Almost immediately actually but I didn't want to take up your time with my one issue because you have helped me immensely. I think I will start a new thread that addresses my issue specifically. You solved this thread of filling the formulas over to the right.

  4. #34
    Board Regular
    Join Date
    Aug 2019
    Posts
    127
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Filling formulas over to the right into a new column added

    I think I solved it.

    The way I solved this issue was by moving the line of code (that fills the column to the right) farther down in my code under the line that has a message box. By doing this, I believe it gave Excel more time to process the adjustment of adding a column. Before, everything was happening so quickly that I don't think excel could process the new column in time to fill the right formula into it.

  5. #35
    Board Regular
    Join Date
    Aug 2019
    Posts
    127
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Filling formulas over to the right into a new column added

    Quote Originally Posted by NoSparks View Post
    how about
    Code:
        Dim ws As Worksheet, oLo As ListObject
    
    Set ws = Sheets("Competitor Comparison")
    With ws
        Set oLo = .ListObjects("CompComparisonTable")
        With oLo
            ws.Range(.ListColumns(.ListColumns.Count - 1).DataBodyRange, .ListColumns(.ListColumns.Count).DataBodyRange).FillRight
        End With
    End With
    How would you alter this so that the table selection range is the whole databodyrange minus the first column?

  6. #36
    Board Regular
    Join Date
    Mar 2013
    Posts
    793
    Post Thanks / Like
    Mentioned
    8 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Filling formulas over to the right into a new column added

    Code:
    With oLo
        Set rng = .DataBodyRange.Offset(, 1).Resize(, .ListColumns.Count - 1)
    End With

  7. #37
    Board Regular
    Join Date
    Aug 2019
    Posts
    127
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Filling formulas over to the right into a new column added

    This did what I was looking for thank you

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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