Re: Autofill help
From: Cecilkumara Fernando (cekufdo_at_sltnetDOTlk)
Date: 06/12/04
- Next message: Stephen Rasey: "Re: Hash a range, output a Long Integer?"
- Previous message: Cecilkumara Fernando: "Re: Converting two column compare macro to vba in Excel"
- In reply to: Patrick Simonds: "Autofill help"
- Messages sorted by: [ date ] [ thread ]
Date: Sat, 12 Jun 2004 09:57:30 +0600
Patrick Simonds,
range("A" & rows.Count).End(xlUp).EntireRow.AutoFill _
destination:=range("A"&rows.Count).End(xlUp).EntireRow.Resize(2)
to autofill columnA only remove ".EntireRow"
Cecil
"Patrick Simonds" <ordnance1@comcast.net> wrote in message
news:eMAYT6CUEHA.3012@tk2msftngp13.phx.gbl...
> I need a piece of code which will go to the last cell (with data) in
column
> A and then AutoFill down one cell.
>
>
- Next message: Stephen Rasey: "Re: Hash a range, output a Long Integer?"
- Previous message: Cecilkumara Fernando: "Re: Converting two column compare macro to vba in Excel"
- In reply to: Patrick Simonds: "Autofill help"
- Messages sorted by: [ date ] [ thread ]
