Hi, I'm trying to use a macro to edit a column of data, but I'm quite
unfamiliar with the syntax of VB. in cell A1 i have the number of
people in a sample group. The Length of column B is the random number
stored in A1 (the number of people in the group) I want to go through
Column B and delete any number that is below 40 and above 80. This is
how I want the loop to look, if it were written in Java

Int Cellnum = 1
While {(Cellnum < CellA1)
If (Cellnum 80)
clear cellnum
If (Cellnum <40)
clear Cellnum)
Cellnum+=1
}

Thanks in advance


--
flyingmeatball
------------------------------------------------------------------------
flyingmeatball's Profile: http://www.excelforum.com/member.php...o&userid=37302
View this thread: http://www.excelforum.com/showthread...hreadid=573816