| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy value problem... if "" then 0
Hi, the code below will copy the ActiveCell.Offset(0, 10).value... but
if ActiveCell.Offset(0, 10).value has nothing in it, I need it to paste a 0 instead of nothing... ActiveCell.Offset(0, 10).Copy Sheets("Datasheet").Range("I65536").End(xlUp).Offs et(1, 0).PasteSpecial Paste:=xlPasteValues Can anybody help please... ste |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Selecting "Save As" adds "Copy of" to file name- MS Excel 2007 | Excel Discussion (Misc queries) | |||
| Shortcut to switch from "fill down" to "copy" with mouse drag | Excel Discussion (Misc queries) | |||
| problem with Linking workbooks via "copy" and "paste link" | Excel Discussion (Misc queries) | |||
| Can you "duplicate" "copy" listboxes and code to multiple cells? | Excel Programming | |||
Threaded Mode
