Prev: SAMPLE EXCEL DATA
Next: determine a range using a formula
From: AlexJarvis on 30 Apr 2010 11:17
If I need to autofill column B from the last cell that has data in it to the
same row as the last cell of column A that has data in it, how do I set the
destination for the autofill correctly?



I have tried a lot of ways that seemed obvious and all of them return errors.


Here is where I am stuck:

Selection.AutoFill Destination:=Range(B[this number is the active cell, or
the one I just put a value in in column B]:B[this number should be the same
as the last cell that has a value in it in column A])


From: Jacob Skaria on 30 Apr 2010 11:24
Try

Dim lngRow As Long

lngRow = Cells(Rows.Count, "A").End(xlUp).Row
Selection.AutoFill Destination:=Range("B" & ActiveCell.Row & ":B" & lngRow)


--
Jacob (MVP - Excel)


"AlexJarvis" wrote:

> If I need to autofill column B from the last cell that has data in it to the
> same row as the last cell of column A that has data in it, how do I set the
> destination for the autofill correctly?
>
>
>
> I have tried a lot of ways that seemed obvious and all of them return errors.
>
>
> Here is where I am stuck:
>
> Selection.AutoFill Destination:=Range(B[this number is the active cell, or
> the one I just put a value in in column B]:B[this number should be the same
> as the last cell that has a value in it in column A])
>
>
From: AlexJarvis on 30 Apr 2010 11:47
Good deal, thank you!

I was forgetting to put a "&" in there...

-A

"Jacob Skaria" wrote:

> Try
>
> Dim lngRow As Long
>
> lngRow = Cells(Rows.Count, "A").End(xlUp).Row
> Selection.AutoFill Destination:=Range("B" & ActiveCell.Row & ":B" & lngRow)
>
>
> --
> Jacob (MVP - Excel)
>
>
> "AlexJarvis" wrote:
>
> > If I need to autofill column B from the last cell that has data in it to the
> > same row as the last cell of column A that has data in it, how do I set the
> > destination for the autofill correctly?
> >
> >
> >
> > I have tried a lot of ways that seemed obvious and all of them return errors.
> >
> >
> > Here is where I am stuck:
> >
> > Selection.AutoFill Destination:=Range(B[this number is the active cell, or
> > the one I just put a value in in column B]:B[this number should be the same
> > as the last cell that has a value in it in column A])
> >
> >
 | 
Pages: 1
Prev: SAMPLE EXCEL DATA
Next: determine a range using a formula