Excel to Copy Last row data till row Number 5000

Chandresh

Board Regular
Joined
Jul 21, 2009
Messages
123
HI All,

Could you all please help me with a macro that can copy the last used row data till row number 5000.

Ex:
My last used row if row number 5 (row changes based on data)
I need a help in macro which can copy the data from row number 5 and paste it till row number 5000.

Thanks
Chan
 

Some videos you may like

Excel Facts

Enter current date or time
Ctrl+: enters current time. Ctrl+; enters current date. Use Ctrl+: Ctrl+; Enter for current date & time.

MARK858

MrExcel MVP
Joined
Nov 12, 2010
Messages
13,977
Office Version
  1. 365
  2. 2010
Platform
  1. Windows
  2. Mobile
Maybe (although I would restrict the number of columns)...

VBA Code:
Sub Chandress()
Dim lr As Long

Application.ScreenUpdating = False
lr = ActiveSheet.Cells.Find("*", , xlValues, , xlByRows, xlPrevious).Row
Rows(lr + 1 & ":" & 5000).Value = Rows(lr).Value
Application.ScreenUpdating = True
End Sub
 
Solution

MARK858

MrExcel MVP
Joined
Nov 12, 2010
Messages
13,977
Office Version
  1. 365
  2. 2010
Platform
  1. Windows
  2. Mobile
You're welcome
 

Watch MrExcel Video

Forum statistics

Threads
1,127,443
Messages
5,624,806
Members
416,055
Latest member
EJGAJG

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top