Fomatting a row based on style of a cell within the same row

  • Thread starter Thread starter web2
  • Start date Start date
W

web2

Hello,

I get an Excel worksheet that has a specific style (bold/fill/pattern
etc.) applied to it in column A at various subtotals lines. I was
looking to apply this style to the ENTIRE row, e.g. cells A16, A23,
A30... have style X applied to it. I need to apply style X to entire
row 16, 23 etc. Any sample VBA code would be greatly appreciated.

Thanks,

Manish
 
The following code will set the format of the entire row for the currently
active cell, adapt to suit your needs

With ActiveCell.EntireRow
With .Font
.Name = "Arial Black"
.Size = 11
.Bold = True
End With
.Interior.Pattern = xlSolid
.Interior.Color = vbYellow
End With
End Sub
 

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

FORMAT ENTIRE ROW BASED ON SPECIFIC TEXT 2
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Apply cell formatting using VBA 1
Delete rows based on contents of Col A 0
Move row based on value in cell 2
Different Styles within a single Cell 4
Loop to copy paste rows base on table arrays 0
Hide rows with zero's on several sheets within a workbook 11

Back
Top