View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Kasper Kasper is offline
external usenet poster
 
Posts: 48
Default Problems with If "range" is nothing then

This is the part of the macro and it doesn't work the way I intended
it to do.

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

The Range "FromCell" is a merged cell in my sheet and even though i
delete everything in it the macro still goes forward with the "else"
part. How can this be?

"Nothing" in vba sense means that the cell is clear?

/Kasper