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