| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Checking if ranges are the same after Range.EntireColumn
running the following code
If Selection = Selection Then MsgBox "ok" If Selection.EntireColumn = Selection.EntireColumn Then MsgBox "ok"-- If Selection.EntireColumn.Cells(10) = Selection.EntireColumn.Cells(10) Then MsgBox "ok" the first line works the second line results in a run-time error '13': Type mismatch the third line works can anyone explain why 2nd line doesn't work ? JC |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Checking 2 Ranges | Excel Programming | |||
| Checking for nonblank cells in ranges | Excel Programming | |||
| Checking range of cells for entry then checking for total | Excel Programming | |||
| Checking for named ranges in a workbook | Excel Programming | |||
| Checking if Target is within different ranges | Excel Programming | |||
Threaded Mode
