Highlight the required area, right click and its under format cells,
you want the border and patterns tabs, to get the vba, record a macro
while doing this.

hth

keith