• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search results

  1. A

    How to change the row number in the range formula?

    Hi Guys I'm using the following macro to create cells with formulas. Sub CreateLoginDetails() Dim i As Long Dim lps As Long lps = Range("C1").Value For i = lps To 1 Step -1 With ActiveSheet .Range("A" & i).Insert xlShiftDown .Range("A" & i).Formula = "TAG POS=1 TYPE=A...
  2. A

    Keep zebra strips proper look when sorting the table

    Hi Guys Thanks to Chandoo's email, I use this formula to create a zebra strips =Mod(Row(),2)=0. I'd like to know how to keep the zebra strips in the table when I'm sorting it based on a criteria? Right now when sorting the table, I might get 2 row or even more with the same color.. Thanks...
Back
Top