paste values leaves unwanted data

[DrBob]

Hi Guys,

To cut a long story short, I'm pasting data from sheet A to sheet B using paste values. The data in sheet A could expand (by rows) so blank cells end up being pasted into sheet B. When I use a CONTA function in sheet B the blank pasted cells get counted.

The blank cells need to be pasted but must not register as containing anything. Any ideas? (vba if possible as I'm using a macro for the paste)

Thanks for your time.

 

[njimack]

Rather than copying blank cells, using a dynamic range on sheet A - see http://www.contextures.com/xlNames01.html#Dynamic

 

[DrBob]

thank you - will try tomorrow.

DrBob