Re: Clean, Trim & Autofit will not work

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Stuart (sg_booth_at_hotmail.com)
Date: 03/26/04 

Date: Fri, 26 Mar 2004 16:30:53 -0000

Thanks for looking at the problem.
If you should find any kind of solution, then please
email me at sgbooth@totalise.co.uk.

Regards.

"NickHK" <TungCheeWah@Invalid.com> wrote in message
news:c40nbr$t322@imsp212.netvigator.com...
> Stuart,
> After playing around a bit, I see what you mean. The row height can be set
> incorrectly, with an extra line, for a cell whose text should fit.
> Can't find a logical reason for it yet, but it seems that Excel sometimes
> gets confused over the real height required to show all the text.
>
> NickHK
>
> "Stuart" <sg_booth@hotmail.com> wrote in message
> news:us0Y5cvEEHA.2052@TK2MSFTNGP11.phx.gbl...
> > Already tried that......empty line moves to the top.
> >
> > Tried copying cell contents to a new cell then autofit
> > .........same result, an extra line.
> >
> > Regards.
> >
> > "NickHK" <TungCheeWah@Invalid.com> wrote in message
> > news:c400fc$t2v2@imsp212.netvigator.com...
> > > Stuart,
> > > What happens if you set the formatting so that the text is aligned
with
> > the
> > > bottom of the cell ? Does the extra line disappear ?
> > >
> > > NickHK
> > >
> > > "Stuart" <sg_booth@hotmail.com> wrote in message
> > > news:erd6I1mEEHA.1544@TK2MSFTNGP11.phx.gbl...
> > > > Thanks for the reply.
> > > >
> > > > In every case that I've tried that test, it has returned
> > > > the last character in the cell, even though the cell
> > > > shows an empty line after that character.
> > > >
> > > > Regards.
> > > >
> > > > "NickHK" <TungCheeWah@Invalid.com> wrote in message
> > > > news:c3u5q1$d4c2@imsp212.netvigator.com...
> > > > > Stuart,
> > > > > What do you get if you put this in C2 for example:
> > > > > =Code(Right(B2,1))
> > > > >
> > > > > i.e. check the code of the last character in column B?
> > > > >
> > > > > NickHK
> > > > >
> > > > > "Stuart" <sg_booth@hotmail.com> wrote in message
> > > > > news:%23Yh2RvdEEHA.2460@TK2MSFTNGP12.phx.gbl...
> > > > > > Importing certain files into Excel cause some rows where
> > > > > > principally text is in column B to contain empty lines.
> > > > > >
> > > > > > I cannot identify these cells programmatically, so I
> > > > > > currently let the user run a basic import routine, then display:
> > > > > >
> > > > > > MsgBox ("The EBQ file(s) are now imported and formatted into
> > Excel."
> > > &
> > > > > > vbNewLine & _
> > > > > > "There will be occasions where cells in column B
have
> an
> > > > extra
> > > > > > empty line." _
> > > > > > & vbNewLine & "Currently, these empty lines must be
> > marked
> > > > by
> > > > > > you manually." _
> > > > > > & vbNewLine & vbNewLine & _
> > > > > > "Open the new files (every file in that new folder)
> and
> > > > place
> > > > > #
> > > > > > in col G" _
> > > > > > & vbNewLine & "in every row that has such an empty
> > line."
> > > &
> > > > > > vbNewLine & _
> > > > > > "Do this for every *** in every workbook." &
> vbNewLine
> > &
> > > > > > vbNewLine & _
> > > > > > "Save each workbook, then run the 'HASH' sub on
those
> > > > > > workbooks." & _
> > > > > > vbNewLine & vbNewLine & _
> > > > > > "Once you have done this, you can run the
'PageResize'
> > > > > > routines.")
> > > > > >
> > > > > > I'm now relying on them to accurately find every instance of the
> > blank
> > > > > line
> > > > > > throughout every *** and book they just imported.
> > > > > >
> > > > > > The delete routine is simple, since it's always just one blank
> line.
> > > So
> > > > > find
> > > > > > '#',
> > > > > > establish the rowheight, and then reduce by 12.75 (the default).
> > > > > >
> > > > > > Is there anything else I could try, please?
> > > > > >
> > > > > > Regards.
> > > > > >
> > > > > >
> > > > > >
> > > > > > ---
> > > > > > Outgoing mail is certified Virus Free.
> > > > > > Checked by AVG anti-virus system (http://www.grisoft.com).
> > > > > > Version: 6.0.637 / Virus Database: 408 - Release Date:
20/03/2004
> > > > > >
> > > > > >
> > > > >
> > > > >
> > > >
> > > >
> > > > ---
> > > > Outgoing mail is certified Virus Free.
> > > > Checked by AVG anti-virus system (http://www.grisoft.com).
> > > > Version: 6.0.637 / Virus Database: 408 - Release Date: 20/03/2004
> > > >
> > > >
> > >
> > >
> >
> >
> > ---
> > Outgoing mail is certified Virus Free.
> > Checked by AVG anti-virus system (http://www.grisoft.com).
> > Version: 6.0.637 / Virus Database: 408 - Release Date: 20/03/2004
> >
> >
>
> 

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.637 / Virus Database: 408 - Release Date: 20/03/2004
Quantcast