refer
 

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

In article ,
"Pasmatos" wrote:

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

refer
 

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

refer
 

You've got another reply in .misc.

Pasmatos wrote:

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

--

Dave Peterson