Hi,
Thanks a lot its working fine :)
On Wed, Jul 17, 2013 at 8:18 PM, ashish koul wrote:
> Sub sample()
> Sheets(1).Range("a65356").End(xlUp).CurrentRegion.Copy
> Sheets(2).Range("a65356").End(xlUp).Offset(1, 0)
> End Sub
>
>
>
> On Wed, Jul 17, 2013 at 8:00 PM, Chandra Shekar <
> chandras
Sub sample()
Sheets(1).Range("a65356").End(xlUp).CurrentRegion.Copy
Sheets(2).Range("a65356").End(xlUp).Offset(1, 0)
End Sub
On Wed, Jul 17, 2013 at 8:00 PM, Chandra Shekar <
chandrashekarb@gmail.com> wrote:
> Hi,
>
> Thanks for your reply. I need to know which is the last range and pas
Hi,
Thanks for your reply. I need to know which is the last range and paste it
in sheet2. Is there anyway to do this.
Please find attached updated excel & there will be many ranges in sheet1
but I should know which is last range and paste same in sheet2.
Regards,
Chandra
On Wed, Jul 17, 2013
try this
Sub abc()
MsgBox ActiveCell.SpecialCells(xlLastCell).CurrentRegion.Address
End Sub
On Tue, Jul 16, 2013 at 8:44 PM, Chandra Shekar <
chandrashekarb@gmail.com> wrote:
> Hi,
>
> How to know how many ranges are there in the attached workbook and how to
> select last range using Area
