format first row within select

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I try to record macro to format data. My purpose is to every time select a
certain rows and run the macro to format. That part is easy. But I want to
format the first row within the selection to be bold. How can I identify the
first row in the selection?

Please help. Thanks,


With Selection
.VerticalAlignment = xlBottom
.WrapText = False
.Orientation = 0
.ShrinkToFit = False
.MergeCells = False
End With
 
Hi Jackie,

Try:

With Selection
.Rows(1).Font.Bold = True
.VerticalAlignment = xlBottom
.WrapText = False
.Orientation = 0
.ShrinkToFit = False
.MergeCells = False
End With
 
Thanks, It works!

Norman Jones said:
Hi Jackie,

Try:

With Selection
.Rows(1).Font.Bold = True
.VerticalAlignment = xlBottom
.WrapText = False
.Orientation = 0
.ShrinkToFit = False
.MergeCells = False
End With
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to get a macro to run on all files in a folder and save each one? 0
Modify Recorded Macro 1
Condense code 2
How to rewrite this code? (first half) 1
Run Time error 1004 - Pastespecial method of range class failed. 3
keep getting the error message - Compile error: Else without If 2
piece of code keeps failing.... 2
Run-Time error '9' Subscript out of Range 7

Back
Top