Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VB CODE for moving the range of cells down by one row?
DEAR ALL
I have managed to get a range marked from active cell to the last row of the data to colum K. Need to shift this whole range by one or two rows as required to insert fresh information. At least pls suggest how to shift the range by one row, which will also solve my data entry as I have to select the cell and use a command button to shift the range by one cell each time. I can even high light how many rows i want to shift and get rows.count and do, i guess but will first learn to shift by one row first. NOTE: cannot insert a new row bcos of hard coding in VB for copying the values and pasting. Pls help. BRGDS/CAPTGNVR |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Moving text around cells without moving boarder lines | Excel Discussion (Misc queries) | |||
CODE 4 MOVING WITHIN A RANGE-TAB | Excel Discussion (Misc queries) | |||
Arrow Keys Moving Window Frame instead of Moving Between Cells | Excel Discussion (Misc queries) | |||
VBA code for averaging a range of cells | Excel Programming | |||
Moving between a cell that is selected to include a range of cells in that row | Excel Programming |