Borders


Posted by Roger on August 22, 2001 5:02 PM

Ok heres the story all...I've got group of cells that is defined by the used...say from 1-100 however that range can change depending on the size of the test lot.What I want to do is formatt the cells that will fill the range from start to finish. Seems simple but I wrote a loop to do it but it only works on the first cell and doesnt loop..and the loop is written like the other 20 loops I have in the program.
Thanks to all who post and answer here..you've been a great help
Roger



Posted by Francisco on August 22, 2001 5:36 PM


It should not be necessary to use a loop - should be able to do it with one line of code.
Post the code you have.