LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 10
Default when looking at a range can certain rows be missed out

Below is my code for changing a value in a cell depending on what values are
in a range of rows.

Private Sub Worksheet_Change(ByVal Target As Excel.Range)
On Error GoTo ErrHandler
Application.EnableEvents = False
If Not Intersect(Target, Me.Range("C2:C20")) Is Nothing Then
Range("E63") = (Range("C63") - Target.Value)
End If
ErrHandler:
Application.EnableEvents = True
End Sub


But is it possible to miss out certain rows of the range for example

my range is A1:A100 but i dont want to include A23 and A25 is this possible
 
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
how can we find out any missed number in a series? Excel Excel Discussion (Misc queries) 4 May 17th 06 04:57 PM
how we can find out any missed number in a series? Excel Excel Discussion (Misc queries) 1 May 17th 06 04:26 PM
redistribution of missed targets Huber57 Excel Discussion (Misc queries) 0 March 16th 06 02:09 AM
missed data rjl Excel Discussion (Misc queries) 2 January 10th 06 01:37 PM
COUNTIF temporarily missed some cells dstx Excel Worksheet Functions 0 July 18th 05 08:42 PM


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

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"