Just to mention, the recorder will record settings for all attributes of the
cell. You only need to select those attributes you want to set/change.

--
Regards,
Tom Ogilvy

"Tom Ogilvy" wrote in message
...
The easiest way to see the code (and the possibilities) is to turn on the
macro recorder (tools=Macro=Record a new macro)

then perform the actions manually.

then turn off the recorder and look at the code.

this will give you the properties, methods and constant arguments you
need.
You can then use them in your code.

--
Regards,
Tom Ogilvy


"Kevin" wrote in message
...
Is it possible to format a cell using VBA code?

My code include the following.

DatabaseWorksheet.Cells(DestinationRow, 1).Value = AssignDate

At the time this code is executed the cell is not formatted. How would
I
modify this code so that, in addition to being populated with AssignDate,
borders and a pattern would be added?

Thanks.


Kevin