Formatting using VBA

[Deville]

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.

 

[Guest]

here's a shot...


Range("A11").Select

 

[Guest]

Let me try that again..

Sub URSUB()
Range("A11").Select
Selection.Font.Bold = True
With Selection.Interior
.ColorIndex = 6
.Pattern = xlSolid
End Sub

 

[43N79W]

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.

In addition to what Alex said, playing with Excel's Macro Recorder feature
can show you the right code. It also shows you a lot of format code you
don't need, but it's a great way to learn how to code cell formats.

-gk-