View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Deville Deville is offline
external usenet poster
 
Posts: 3
Default Formatting using VBA

Hello All,
I am dumping data from an Ms Access data source to an
Excel spreadsheet. I have the field names and the data
going to excel just fine. I having trouble mimicking a
Header section from a picture of what my users want to
see. How can I:
1: Insert a into a cell and have the cell cover from A1
to say D1
2: Format that area with Highlight, bold, shading all
that good stuff.

If anyone could help me with that, it would really be
appreciated.