Getting Range to move 1 column left and resize by 1

[mozart]

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

[Geeves]

look at offset
i.e

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

"mozart" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>