fast copy and paste not transferring blank cells

Hi,

I just discovered that:

Please Login or Register  to view this content.

is not working properly with blank cells

Is this a condition of the statement? Can I alter it to do this?

Care to post a sample sheet where we can test this misbehavior? It may be important to see your actual content in those cells.

Attach a sample workbook. Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

The reason is that your single line of code generates and uses an array and the value of a blanks cell may be zero. Try:

Please Login or Register  to view this content.

Can I do that with just the Values and not the Formulae?

Hmm....

Please Login or Register  to view this content.