I assumed the when Gary''s Student included this line as part of the
description...

"I am given a range which is part of a single column"

that he was ruling out the possibility of an entire column being selected.

--
Rick (MVP - Excel)


"Peter T" <peter_t@discussions wrote in message
...
normally you can, but not always, eg

Set rngCur = Columns(1)
With rngCur
Debug.Print .Rows(2 & ":" & .Count).Address
Debug.Print .Rows(2 & ":" & .Cells.Count).Address
End With

Regards,
Peter T

"Rick Rothstein" wrote in message
...
You can shorten that slightly by leaving the Cells references out...

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

--
Rick (MVP - Excel)


"John_John" wrote in message
...
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