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