LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #5   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 11,058
Default Code for testing whether a cell or row is highlighted?

You are welcome
Simple is always good.
--
Gary''s Student - gsnu200725


"J@Y" wrote:

Great simple solution. Thanks.

"Gary''s Student" wrote:

Sub colortest()
If ActiveCell.Interior.ColorIndex = xlNone Then
MsgBox ("not colored")
Else
MsgBox ("colored")
End If
End Sub

--
Gary''s Student - gsnu200725



 
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
Rename selected (highlighted) sheet with cell contents of sheets in cell A1 [email protected] Excel Programming 2 December 15th 06 08:41 AM
Checklist for testing code? M. Authement Excel Programming 2 April 25th 06 06:49 PM
unit testing code using vba Eric[_27_] Excel Programming 0 December 5th 05 03:51 AM
Testing code for oldest version... John Keith[_2_] Excel Programming 1 October 25th 05 03:16 PM
testing the state of a checkbox in vba code Paul James[_3_] Excel Programming 10 December 5th 03 07:55 PM


All times are GMT +1. The time now is 07:45 PM.

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

About Us

"It's about Microsoft Excel"