• 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.

Recent content by amitcohen

  1. A

    How to change the row number in the range formula?

    Hi Guys Thanks for your answers. xld; your solution is perfect for the challenge. :) Hui; Using Cells() never cross my mind..:( I learned another thing 2day. BTW, is it a better coding to use Cells() instead of Range()? What is the idea behind it? Cheers, ;) Amit.
  2. 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...
  3. A

    Keep zebra strips proper look when sorting the table

    Things are 100 times clearer now :) Many thank guys for your help
  4. A

    Keep zebra strips proper look when sorting the table

    Cool guys. you right ;) Here is a sample: http://amit-cohen.com/excel/randomdata.xlsx I'm using Excel 2007. Sorting the table by any criteria (1,2 or 3) will show you the problem I'm trying to solve. Thanks.
  5. A

    Keep zebra strips proper look when sorting the table

    Hi Hui Unfortunate, my tests shows me a different results. (That is why I started this thread at the first place..)
  6. A

    Keep zebra strips proper look when sorting the table

    I guess. But I need a solution..
  7. 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