View Single Post
  #3 (permalink)  
Old October 5th, 2004, 04:31 AM
Martin Outlaw Martin Outlaw is offline
Authorized User
 
Join Date: Jun 2004
Location: Sandown, Isle of Wight, United Kingdom.
Posts: 12
Thanks: 0
Thanked 0 Times in 0 Posts
Default

When you come across a problem such as this a good way around it is to record a macro.

Go to a separare workbook and record a macro, select the cell and format the cell with fill colour, borders etc as required, hen stop the recording.

View the code that the recording has creating and cut and paste the relevent bit into your project.

Reply With Quote