How to reference spaces as spaces not zeros

Hi guys,

Struggling a little here, I am using Excel 2007 and I am trying to reference blank cells as blank cells, but they are coming up as zeros, I have not been able to find the option in Tools - Options - view - zero values, I can't find such an option on this version that I am using. Here is the code I am using to extract the data from a different sheet, but as I am using R1C1 format, I can't work out how to use an =If statement. Please help.

Please Login or Register  to view this content.

Kind regards
Rob

try this

Please Login or Register  to view this content.

Thanks YasserKhalil, This worked better than I had hoped, it was quicker than what I was doing, and also solved the problem I had just encountered where it would give me a blank page until I stopped the macro and ran it again.

To be fair, the only way i know to learn is to record a macro to get the syntax and then edit it till it works, in this case I couldn't get it to work properly.

Thanks
Rob

You can attach your workbook to make it easier for others to offre help.

Anyone know why I can't post a new thread please, or point me at an admin I can talk to please. The only way i can stay logged in is to use one of my existing threads today is there a problem with the forum?