About Us

Glad you got it working.

(Thanks for posting back)

wrote:

Dave, I'm kicking myself now. This first suggestion you gave me is
exactly what I needed. For some reason, it didn't seem to work when I
first tried it. I must have done it wrong. But I also made a change
back in the formulas on the other sheets, and that may have then
allowed your suggestion here to work. Now it works great. It gets me
back to really blank cells, then Chip's macro deletes the blank rows.

Thank you so much for your help, and I'm sorry I took so long to get
it right.

I'm trying to do a couple of other weird things with the calendar, so
I may be asking for help again in a few days.

Cooter

On Tue, 26 Apr 2005 07:48:08 -0500, Dave Peterson
wrote:

If the zero length strings are values--not formulas, then you could select your
range
edit|replace
what: (leave blank)
with: $$$$$ (some unique string)
replace all

then reverse it
edit|replace
what: $$$$$
with: (leave blank)
replace all

(This cleans up those formulas that evaluated to "" that were converted to
values.)

Alternatively, you could modify Chip's routine.

Depending on what Chip's code was, though.

if isempty(.cells(irow,icol)) then
.rows(irow).delete
end if

could become

if .cells(irow,icol).value = "" then
.rows(irow).delete
end if

You may want to post your code to get a better answer.

wrote:

I am trying to delete blank rows using Chip Pearson's macro; also
tried acouple of addins that delete blank rows.
My problem that the cells are not really blank, apparently they have
zero length strings.
Is there a way to delete zero length string rows, or to convert zero
length string cells to blank cells, and then run the delete blank rows
macro?
The cells' data was achieved via copy/paste from another sheet, which
was achieved from formulas such as =IF(D29="","",ha).
I tried such as =IF(D29="",G32,ha), where G32 is a really blank cell.
But some of the formulas involve time, and the latter formula caused
the time cells to be wrong.
Thanks for any suggestions.

--

Dave Peterson

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Delete specified critria rows	rn	Excel Discussion (Misc queries)	4	March 21st 05 12:51 PM
delete repeating rows	aledger	Excel Worksheet Functions	2	March 4th 05 08:43 PM
how do I print grid lines for blank rows	calrolfe	Excel Discussion (Misc queries)	0	February 24th 05 07:33 PM
How do I delete blank rows at the bottom of a spreadsheet to get .	Miklaurie	Excel Discussion (Misc queries)	1	January 26th 05 02:30 PM
Blank Rows	Acesmith	Excel Discussion (Misc queries)	1	November 30th 04 09:23 PM

Menu

About Us