Re: excel

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: johnfli (john_at_here.com)
Date: 10/08/04 

Date: Fri, 8 Oct 2004 14:42:41 -0700

ok, I found it.
the Merge cell prperty has to be set to NEVER

"johnfli" <john@here.com> wrote in message
news:%235dGQlXrEHA.3900@TK2MSFTNGP10.phx.gbl...
> for some reason I can not get the mshflexgrid to select any rows.
> I mad sure that all the settings for selection are set to true, but no go.
> any ideas??
>
>
>
> "Jeff Johnson [MVP: VB]" <i.get@enough.spam> wrote in message
> news:ezGEgGXrEHA.4008@TK2MSFTNGP14.phx.gbl...
> >
> > "Jim Edgar" <djedgarNOSPAM@cox.net> wrote in message
> > news:%23jKYPtWrEHA.1296@TK2MSFTNGP12.phx.gbl...
> >
> > > For i = LBound(aRows) To UBound(aRows)
> > > aCols = Split(aRows(i), vbTab)
> > > For j = LBound(aCols) To UBound(aCols)
> > > sht.Cells(i + 1, j + 1) = aCols(j)
> > > Next
> > > Next
> >
> > Why the extra work? Go to the upper-left corner of the range and Paste.
> >
> >
>
>