View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Dave M[_2_] Dave M[_2_] is offline
external usenet poster
 
Posts: 27
Default Help with paste special

is there an easy work around for this?

"Joel" wrote:

cntrl + down work with Null cells not empty cells. After you perform the
paste the cells are no longer Null, they are still empty. Excel treats Null
and Empty differently.

"Dave M" wrote:

I am pasting a section of my worksheet special, values only. After pasting,
the contents of the cell are empty, but when I use the ctrl+down, it skips
over the blank cells to where the first cell that I didn't paste it is. (kind
of confusing, I know, hard to explain)

Does anyone know how to work around this?

Dave