LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 599
Default Last Hope -HELP!!

Marie

Need more info. What range is "list"? What range is "BranchToDistrict" and
"DistrictNumber"?

If c.Offset(0, 1).Value = Range("DistrictNumber").Value

Then
Offset(0, 1).Value
Else: Selection.EntireRow.Delete

End If


If every row is being deleted, then this is probably always false. The THEN
part of this doesn't make any sense. If "List" comprises more than one
column, that's probably the problem.

--
Dick Kusleika
MVP - Excel
Excel Blog - Daily Dose of Excel
www.dicks-blog.com


 
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
Hope this is easy RobertG Excel Discussion (Misc queries) 3 May 18th 10 07:13 PM
Hope someone can help me Jay Blatherwick Excel Discussion (Misc queries) 1 June 15th 06 06:03 PM
Hope someone here can help me AlienBeans Excel Discussion (Misc queries) 9 March 17th 06 12:37 AM
An easy one i hope [email protected] Excel Discussion (Misc queries) 1 December 23rd 05 02:05 PM
Last Hope -HELP!! Bob Phillips[_6_] Excel Programming 0 June 29th 04 09:08 PM


All times are GMT +1. The time now is 11:09 AM.

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"