I have a range selected. I want to move this range selection 1 column t
the left and i wish to chop 1 cell off from the top and the bottom a
the same time.

Eg My original selection is C1:C5

I need my new selection to be B2:B4

Is there a nice way of doing this with code?

I am going to eventually set this to equal a range variable

Thanks

Mozar

--
mozar
-----------------------------------------------------------------------
mozart's Profile: http://www.excelforum.com/member.php...fo&userid=1331
View this thread: http://www.excelforum.com/showthread.php?threadid=39848