Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
selecting multiple cell in a roll that falls withing a range
Gentlemen,
Using VBA, is it posible to select all the cells in column A which their value fall in between 5 and 10 i.e select all cells in columnA =5 and =< 10 |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
selecting multiple cell in a roll that falls withing a range
The subrountine below will do that, but if you just want to highlight them
do you know about Conditional Formatting? Sub Check() myrange = "" For j = 1 To 100 mytest = Cells(j, 1).Value If mytest = 5 And mytest <= 10 Then myrange = myrange & "A" & j & "," End If Next j myrange = Mid(myrange, 1, Len(myrange) - 1) 'MsgBox myrange Range(myrange).Select End Sub best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "Olamide" wrote in message ... Gentlemen, Using VBA, is it posible to select all the cells in column A which their value fall in between 5 and 10 i.e select all cells in columnA =5 and =< 10 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Selecting range in list of range names depending on a cell informa | Excel Discussion (Misc queries) | |||
Checking if a certain day falls in a range | Excel Discussion (Misc queries) | |||
update cell only if now() falls in a given date range | Excel Worksheet Functions | |||
Data falls in a range +/-1 | Excel Worksheet Functions | |||
Selecting a cell in a range | Excel Worksheet Functions |