Thread: macros
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
sfh sfh is offline
external usenet poster
 
Posts: 2
Default 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?