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
|