View Single Post
  #12   Report Post  
Posted to microsoft.public.excel.misc
Kasper Kasper is offline
external usenet poster
 
Posts: 48
Default Cannot copy merged cell to a single cell

Tried this:

If FromCell Is Nothing _
Or FromCell2 Is Nothing Then Exit Sub
'do nothing
Else
DestCell.Value = FromCell.Value
DestCell2.Value = FromCell2.Value
End If.

But this Gives an error: Compile error - ELSE without IF?