On 26 Feb., 14:01, Dave Peterson wrote:
FromCell and FromCell2 are always going to be assigned to ranges. *That's what
these two lines do:

* * * * Set FromCell = .Range("c8")
* * * * Set FromCell2 = .Range("G8")

If you want to check to see if the either destcell or destcell2 is empty:

* *if destcell.value = "" _
* * *or destcell2.value = "" then
* * * *'do nothing
* *else
* * * .....

Kasper wrote:

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?

--

Dave Peterson

It works as intended.

Thank your for your time and help.

/Kasper