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.
|