Yes their is no value or formating in blank cells, but they were
"special pasted" "values only" onto the current sheet.

I am gettin a "no cells were found error"

Jim

"Dave Peterson" wrote:

Are those blank cells really empty?

If yes.

Select the whole range to fix--extra filled cells won't hurt.
Edit|Goto|special|blanks
notice that the selection changed to just the empty cells.
type your filler text
but hit ctrl-enter instead of enter to fill those empty cells.

Stewcrew wrote:

Hello, I need to fill in all blank cells a large data range. My data is
randomley scattered accross several hundred thousand cells and needs to
remain in place. I need to have a text string as a place holder in all blank
cells before importing into quickbooks.

Thank you very much for your help!

Jim

--

Dave Peterson