refer

J

JE McGimpsey

If you really want to delete the rows, one way:

Range(ActiveCell.Row & ":3000").Delete


If you just want to delete the cells in the range from ActiveCell to
U3000, one way:

Range(ActiveCell, Cells(3000,21)).Delete Shift:=xlUp
 
P

Pasmatos

Hi.
Please help me.

I need to select a range based on a start location that's diferent sheet by
sheet.
I tried but i couldn't make it.
The start position it's variable depends on that i have select cell, and the
final position is U3000. I want select this range and them delete all the
rows of the range.

Rows(ActiveCell.select:u3000).Select
 
D

Dave Peterson

You've got another reply in .misc.
Hi.
Please help me.

I need to select a range based on a start location that's diferent sheet by
sheet.
I tried but i couldn't make it.
The start position it's variable depends on that i have select cell, and the
final position is U3000. I want select this range and them delete all the
rows of the range.

Rows(ActiveCell.select:u3000).Select
Click to expand...
 
Top