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