Posted to microsoft.public.excel.programming

Jim May

external usenet poster

Posts: 477

Code - not working - Why?

I thought the following should work, BUT IT DOESN'T.
Can somone "point-out" WHY it doesn't? - TIA,

Sub Foo()
With Selection ' Range currently highlighted - example A3:A50
For Each cell In Selection
If .Interior.ColorIndex = 6 Then
cell.EntireRow.Delete
End If
Next cell
End With
End Sub

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
VB Code Is Not Working	Rob	Excel Discussion (Misc queries)	2	May 30th 07 05:23 PM
Code not working	Jim May	Excel Programming	5	September 13th 05 04:39 PM
Code not working and can't see why	Steve	Excel Discussion (Misc queries)	3	December 31st 04 03:12 PM
why this code not working	Bernie Deitrick[_2_]	Excel Programming	0	September 2nd 03 05:08 PM
For Each Code Not Working	jacqui[_2_]	Excel Programming	4	July 29th 03 02:44 AM

All times are GMT +1. The time now is 10:51 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us