#1   Report Post  
Posted to microsoft.public.excel.programming
sfh sfh is offline
external usenet poster
 
Posts: 2
Default macros

How can I create a macro that applies a specified color to the current row
rather than a defined row?
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 4,624
Default 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?

  #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?


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
weird saving of a document with macros resulting with macros being transfered to the copy alfonso gonzales Excel Programming 0 December 12th 04 09:19 PM
Macros inside macros, and pasting into macro code. pagelocator[_2_] Excel Programming 1 November 24th 04 09:11 AM
convert lotus 123w macros to excel macros rpiescik Excel Programming 1 September 18th 04 01:35 PM
Macros not appearing in the Tools Macro Macros list hglamy[_2_] Excel Programming 5 October 24th 03 09:10 AM
Suppress the Disable Macros / Enable Macros Dialog Shoji Karai Excel Programming 5 September 24th 03 03:10 AM


All times are GMT +1. The time now is 07:33 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"