From: mully <david.mullet@...>
Date: 2006-12-13T01:15:09+09:00
Subject: Re: Directory Size and bolding Excel cells

anon1m0us@yahoo.com wrote:

> In addtion, how do you  BOLD and hightlight and excel CELL??

Where ws is your Worksheet object and row and col are integers...

ws.Cells(row, col).Font.Bold = 1
ws.Cells(row, col).Interior.ColorIndex = 6

One of the best ways to determine the necessary Excel objects and
methods is to record a macro in Excel and then review the macro's VBA
code.

Mully