Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
find cells in a range which equal a specific value
I am trying to allocate a value to a mixed range of values ie 1100 may be
made up of 10 different values |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
find cells in a range which equal a specific value
Hi Keith,
Try something like this (untested): Dim myRange As Range Dim oCell As Cell For Each oCell In myRange.Cells If oCell.Value < "" Then Select Case oCell.Value Case 1 'Do something if the cell = 1 Case 150 'Do something else if the cell = 150 'Add as many Cases as you need End Select End If Next oCell Best regards John "Keith Piggott" <Keith wrote in message ... I am trying to allocate a value to a mixed range of values ie 1100 may be made up of 10 different values |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Adding random #s in a range to equal a specific # | Excel Worksheet Functions | |||
how can I find which cells in a dataset equal a specific value | Excel Worksheet Functions | |||
Selecting values from a range that equal a specific total | Excel Worksheet Functions | |||
Determine which cells from a specific range equal a certain sum | Excel Worksheet Functions | |||
Find cell of equal value of a range and give result of ajoining co | Excel Programming |