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

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

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

Is it possible to replace empty cells with null cells (or vice versa)

"Dave M" wrote:

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

Use the isempty function an if true then clearcontents.

if isempty(selection) then
selection.clearcontents
end if
"Dave M" wrote:

Is it possible to replace empty cells with null cells (or vice versa)

"Dave M" wrote:

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

Saved from a previous post:

If you want to see what's left in that cell after you convert ="" to values,
try:
Tools|Options|Transition Tab|Toggle Transition Navigation keys on.

Then select one of those cells and look at the formula bar. You'll see an
apostrophe. (Don't forget to toggle the setting to off.)

When I want to clean up this detritus, I do this:

Select the range (ctrl-a a few times to select all the cells)
Edit|Replace
what: (leave blank)
with: $$$$$
replace all

Immediately followed by:
Edit|Replace
what: $$$$$
with: (leave blank)
replace all

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

--

Dave Peterson