Posted to microsoft.public.excel.programming

theo

external usenet poster

Posts: 66

offsets - using ranges

This works fine:
If IsEmpty(cll.Offset(0, 1)) Then cll.Offset(0, 1).Interior.ColorIndex = 6 _
Else: cll.Offset(0, 1).Interior.ColorIndex = xlNone

I want to do the same thing but for a range of cells in the row (from colum
R to column V, for example - check to see if they are ALL empty and then
highlight ALL of them, if so).
Any help is much appreciated .

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
offsets (I think)	Stan	Excel Discussion (Misc queries)	4	January 31st 10 04:48 PM
Countif & Offsets	Yuanhang	Excel Discussion (Misc queries)	1	February 15th 08 09:16 PM
Named range using offsets	Spike	Excel Programming	2	July 17th 06 12:45 PM
cutting and pasting ranges using offsets	timmulla	Excel Programming	2	July 14th 05 06:28 PM
average, array and offsets	Darin1979	Excel Worksheet Functions	0	November 17th 04 04:21 PM

All times are GMT +1. The time now is 03:34 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us