PC Review


Reply
Thread Tools Rate Thread

create search macro based on if cells are merged, or have color in

 
 
SteveDB1
Guest
Posts: n/a
 
      28th Mar 2008
Hello all.
I would like to make a macro that looks for a specific property of a range
of cells. It's typically a merged row, or a row with a color index.

My thinking is as follows:

Search for colorindex or merged row
If cell colorindex != blank,

application.run ()

fill down to next row where colorindex != blank (no color).

And this is for Excel 2007.
Thank you.
 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Automatically color merged cells Rick Microsoft Excel Misc 1 11th Nov 2009 07:25 PM
Assigning markup color for merged cells =?Utf-8?B?T2ZmaWNlX3VzZXI=?= Microsoft Word Document Management 0 5th Jul 2007 05:36 PM
How do I change a merged Cells background color rich Microsoft Excel Programming 0 25th Oct 2006 03:33 PM
Create a macro to run autofilter based on contents of 2 cells =?Utf-8?B?U3luZHJvbWU=?= Microsoft Excel Programming 3 16th Sep 2006 10:33 AM
search for merged cells Carol Microsoft Word Document Management 2 18th Nov 2003 06:56 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 08:41 AM.