Put the same number in A1 for 160 rows and change that number to the
next highest (ex. from 29 to 30) based on a value in cell G.

.......A.............................G.
1.....29.........................."ABC"
2.....29.........................."ABC"
3.................................."ABC"
4.................................."ABC"
160..29.........................."ABC"
161..30.........................."DEF"
162..30.........................."DEF"
...................................."DEF"
...................................."DEF"

Need help..just a beginner in Excel VBA


--
KrimerJ
------------------------------------------------------------------------
KrimerJ's Profile: http://www.thecodecage.com/forumz/member.php?userid=227
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=84541