Archive of Mr Excel Message Board
Back to Forms in Excel VBA archive index
Back to archive home
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
Re: Borders
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.
This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our
online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.