Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I am trying to select a range in column B and then have
the information cut, and pasted into column A at the bottom of the information in column A. How can this be done simply? Thanks, David |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Try this, maybe not the best but it works
I asume you have the range selected: Sub test() Selection.Cut Cells(Range("A65000").End(xlUp).Row + 1, 1).Paste ActiveSheet.Paste End Sub Regards, John -----Original Message----- I am trying to select a range in column B and then have the information cut, and pasted into column A at the bottom of the information in column A. How can this be done simply? Thanks, David . |
#3
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
try the following
Sub CopySelection() If Selection.Rows.Count < Rows.Count - Range("B" & Rows.Count).End(xlUp).Row Then Selection.Copy Range("B" & Rows.Count).End(xlUp).PasteSpecial Else MsgBox "Cannot paste selection - not enough rows" End If End Sub very easy to change this to an addin to you can have it as a button on toolbar for all spreadsheets - let me know if u need this. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
selecting a range | Excel Discussion (Misc queries) | |||
Please help with selecting a range | Excel Discussion (Misc queries) | |||
Selecting range in list of range names depending on a cell informa | Excel Discussion (Misc queries) | |||
Selecting a Range | Excel Discussion (Misc queries) | |||
Selecting a Worksheet Range | Excel Worksheet Functions |