Thread: Checking if ranges are the same after Range.EntireColumn
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
jc jc is offline
external usenet poster
  
Posts: 164
Default 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
Reply With QuoteReply With Quote