Quote Originally Posted by Mack 10 View Post
...Can I call the code from a user defined function and pass it the ranges and have it do what I want?
Hi Mack,

As I read your code, it appears to me that you want to copy values, skipping the blank cells. If I have that right, I think we should be able to do that (I didn't really test) but the "output" range must be the range of cells that the UDF is entered (as an array formula). Is that any help?

Mark