ExcelBanter - macros

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - macros (https://www.excelbanter.com/excel-programming/358401-macros.html)

sfh

macros

How can I create a macro that applies a specified color to the current row
rather than a defined row?

JE McGimpsey

macros

One way:

Public Sub ColorCurrentRow
ActiveCell.EntireRow.Interior.Colorindex = 3
End Sub

In article ,
sfh wrote:

How can I create a macro that applies a specified color to the current row
rather than a defined row?

sfh

macros

thank you...

"JE McGimpsey" wrote:

One way:

Public Sub ColorCurrentRow
ActiveCell.EntireRow.Interior.Colorindex = 3
End Sub

In article ,
sfh wrote:

How can I create a macro that applies a specified color to the current row
rather than a defined row?

All times are GMT +1. The time now is 05:51 PM.