Posted to microsoft.public.excel.programming

roster_jon[_2_] roster_jon[_2_] is offline

external usenet poster

Posts: 1

count resize range

Hey,

I need a VBA code that count the number of times "cf" occurs in the 14 cells
to the left of every cell, including the cell, in a range and change the
bottom border line to a thick red line if the count exceeds 4.

What I'm trying to do is point out if someone has been scheduled "cf" more
than 4 times in the past 14 days.

Is this possible at all?

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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
Resize Table Range to exclude zero values and Input New Range into achart object	jparnold	Excel Programming	10	December 22nd 09 04:09 PM
resize range	Norma	Excel Programming	3	October 16th 08 09:05 PM
Set new range based on rng.Offset(rng.Rows.Count, 0).Resize(1, 1)	Keith	Excel Programming	2	January 7th 07 08:35 PM
Range.Delete and Range.Resize.Name performance issues	Test.File	Excel Programming	0	February 15th 05 03:33 PM
Range Resize	jacqui	Excel Programming	2	April 6th 04 06:22 PM

All times are GMT +1. The time now is 01:41 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us