mbake16
04-13-2009, 06:13 AM
Attached is an example of how I'm using a UDF to paste values in a column on one sheet into a column on another sheet.
If there is no value in a cell on the first sheet, nothing is to be pasted into the column on the second sheet, however a "0" is always pasted for cells in the first sheet having no value.
If anyone can let me know how to adjust my code to have nothing pasted for cells with no value instead of a "0" that would be great!
Thanks,
Matt
If there is no value in a cell on the first sheet, nothing is to be pasted into the column on the second sheet, however a "0" is always pasted for cells in the first sheet having no value.
If anyone can let me know how to adjust my code to have nothing pasted for cells with no value instead of a "0" that would be great!
Thanks,
Matt