Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
controlling cell borders in excel using VB
I hve a VB application that is using the copyfromrecordset
function to transfer the an ADODB recordset to an excel file starting in cell A8 filling the range ("A8":"Z37") "Z37" varies depending on the query being executed. The resulting range could be anywhere from ("A8":"D9") to ("A8":"BZ1200") I would like to set the border to "all borders" just for the specified range. Can anyone explain how this can be acomplished? Any help would be greatly appreciated |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
missing cell borders in Excel | Excel Discussion (Misc queries) | |||
Controlling word wrap in a cell | Excel Discussion (Misc queries) | |||
Controlling which cell you go to when Tab is entered | Excel Discussion (Misc queries) | |||
how do i set wrapping to see cell borders behind a pic in excel | Excel Discussion (Misc queries) | |||
Excel 2003 - Cell Borders | Excel Discussion (Misc queries) |