Help with paste special

[Guest]

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

 

[Guest]

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.

 

[Guest]

is there an easy work around for this?

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.

 

[Guest]

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

 

[Guest]

Use the isempty function an if true then clearcontents.

if isempty(selection) then
selection.clearcontents
end if

 

[Dave Peterson]

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