Thread: refer
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
JE McGimpsey
 
Posts: n/a
Default 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