First, I DO understand what SkipBlanks actually does.

What i'm doing is running a simple macro to copy values from one workbook to another. Everything is working fantastically except one glitch. The macro copies a range of cells and copies over the values to the other workbook. These cells it copies do reference to cells that contain formulas. The logics in the cells are told to return blank if it doesn't meet certain criteria. (ex. =IF(A1>1,1,""))

This I thought would work well. The values it copes are displayed from these types of IF logics. If they returned blank then I thought skipblanks in VBA wouldn't copy the blank cell. But apparently Excel references to weather or not the cell is truly blank, as in no formulas no nothing.

Is this true?

Here is a sample of the code. 

Please Login or Register  to view this content.
It does that several times to different cells. But it always copies the cells where forumlas are supposed to be returning blank (and the ones I want to copy), and pasting blank over the data I don't want to overwrite while pasting the data I want. Any ideas on this?