Getting Range to move 1 column left and resize by 1
 

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

Getting Range to move 1 column left and resize by 1
 

look at offset
i.e

Set Start = .Range("m5").Offset(i, 0) 'first cell = m6

"mozart" wrote in
message ...

I have a range selected. I want to move this range selection 1 column to
the left and i wish to chop 1 cell off from the top and the bottom at
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

Mozart


--
mozart
------------------------------------------------------------------------
mozart's Profile:
http://www.excelforum.com/member.php...o&userid=13314
View this thread: http://www.excelforum.com/showthread...hreadid=398487