Hi all I have some code that inserts search results from an access database into an Excel worksheet.
I want to put borders around the cells in excel. I know how to put borders around a defined range but the number of rows populated in the excel sheet will vary depending on the number of search results.
Basically I need some code that will do Range("B6:??).Select
I managed to record this Macro in Excel but I can't get it to work
Range("B6").Select
Range(Selection, ActiveCell.SpecialCells(xlLastCell)).Select
thanks in advance for anyone who can help me
I want to put borders around the cells in excel. I know how to put borders around a defined range but the number of rows populated in the excel sheet will vary depending on the number of search results.
Basically I need some code that will do Range("B6:??).Select
I managed to record this Macro in Excel but I can't get it to work
Range("B6").Select
Range(Selection, ActiveCell.SpecialCells(xlLastCell)).Select
thanks in advance for anyone who can help me