| Home |
| Search |
| Today's Posts |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Check a range to see if a value exists in it
Hi Howard,
I think there are two small changes. First, be sure to set "lData" = your data range. If it is a named range use: Set lData = Sheet1.Range("ldata") If it is not named, use: Set lData = Sheet1.Range("G1:G10") Then, change your function in the lCnt line to CountIf and drop the quotes: lCnt = Application.WorksheetFunction.CountIf(lData, i) Hope this helps Ben |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Check if Range EXISTS | Excel Programming | |||
| Check to see if a range name exists on a sheet | Excel Programming | |||
| Check if a named range exists with VBA? | Excel Programming | |||
| Check if named range exists! | Excel Programming | |||
| Check if a number exists in a range? | Excel Discussion (Misc queries) | |||
Threaded Mode
