View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
John_John John_John is offline
external usenet poster
 
Posts: 40
Default Redefine a Range

Hi!
One way is below:

With rngCur
Set rngCur = .Rows(2 & ":" & .Cells.Count)
End With

...but is not the only one!

Ο χρήστης "Gary''s Student" *γγραψε:

I am given a range which is part of a single column, say D31:D257
I need an easy way to clip off the top cell, leaving D32:D257

Thanks in Advance
--
Gary''s Student - gsnu200908