insert 'x' number of rows in excel  
Author Message
JohnBrainerd





PostPosted: Mon Aug 09 06:16:21 CDT 2004 Top

Excel Misc >> insert 'x' number of rows in excel

Hi,
I'm looking to insert 'x' no. of rows into an excel document where 'x' is
the result of a 'countA' function.

Is this possible?

Excel227  
 
 
Frank





PostPosted: Mon Aug 09 06:16:21 CDT 2004 Top

Excel Misc >> insert 'x' number of rows in excel Hi#
only possible with VBA. Would this be feasible for you?

>-----Original Message-----
>Hi,
>I'm looking to insert 'x' no. of rows into an excel
document where 'x' is
>the result of a 'countA' function.
>
>Is this possible?
>.
>
 
 
AlBlakie





PostPosted: Mon Aug 09 06:27:06 CDT 2004 Top

Excel Misc >> insert 'x' number of rows in excel Yes VBA is feasible



> Hi#
> only possible with VBA. Would this be feasible for you?
>
> >-----Original Message-----
> >Hi,
> >I'm looking to insert 'x' no. of rows into an excel
> document where 'x' is
> >the result of a 'countA' function.
> >
> >Is this possible?
> >.
> >
>
 
 
Dave





PostPosted: Mon Aug 09 17:30:08 CDT 2004 Top

Excel Misc >> insert 'x' number of rows in excel How about:

Option Explicit
Sub testme()

Dim numOfRows As Long
Dim myRow As Long

myRow = 8 'or whereever you want it
With ActiveSheet
numOfRows = Application.CountA(.Range("a1:a3"))
If numOfRows > 0 Then
.Rows(myRow).Resize(numOfRows).Insert
End If
End With

End Sub





>
> Yes VBA is feasible
>

>
> > Hi#
> > only possible with VBA. Would this be feasible for you?
> >
> > >-----Original Message-----
> > >Hi,
> > >I'm looking to insert 'x' no. of rows into an excel
> > document where 'x' is
> > >the result of a 'countA' function.
> > >
> > >Is this possible?
> > >.
> > >
> >

--

Dave Peterson