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?
>.
>
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?
> >.
> >
>
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?
> > >.
> > >
> >