Hi All,

I have a sheet that copies cells from excel to word. I need to be abl
to determine if the clipboard copy is empty - if its empty it fails.

Sheets("Page1").Select
Range("C305:E318").Copy

Basically I need to be able to say if the range to be copied is in fac
empty - ignore. If range to be copied has value then paste it.

I have code to copy and paste but I need to run an IF that determine
whether the copy and paste is run or not.

Any assistance appreciated.

Thnaks

Stev

--
Message posted from http://www.ExcelForum.com