Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I move data from a row range to a column range | Excel Discussion (Misc queries) | |||
how do I resize a range of cells in a column in excel? | Excel Discussion (Misc queries) | |||
How do I Move column A, B, etc. to left side. | New Users to Excel | |||
Move/Resize PlotArea | Charts and Charting in Excel | |||
move y-axis labels on column chart from left to right side | Charts and Charting in Excel |