| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Check if empty
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I check for an empty cell in a formula? | Excel Discussion (Misc queries) | |||
| Check for empty range in vba | Excel Discussion (Misc queries) | |||
| If Then's for 12 textboxes to check if they are empty. | Excel Discussion (Misc queries) | |||
| How to check for next empty cell in list | Excel Programming | |||
| vba - check if cell is empty | Excel Programming | |||
![stevenmckeon[_4_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
