Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Selecting Non-Consecutive Variables
Hello Experts! I've written some code that prompts the user to indicate which column two type of data appear in. I then want to select those two columns, which may not be next to each other, to copy to another sheet. I've tried both versions below but neither work! Can anyone tell me where I'm going wrong? Columns(ISBNCol & "," & QtyCol).Select Columns(ISBNCol, QtyCol).Select Thanks Colin -- Colin Vicary ------------------------------------------------------------------------ Colin Vicary's Profile: http://www.excelforum.com/member.php...o&userid=10472 View this thread: http://www.excelforum.com/showthread...hreadid=507283 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Selecting Non-Consecutive Variables
Union(Columns(ISBNCol), Columns(QtyCol)).Select
But you don't usually have to select a range to work with it. Colin Vicary wrote: Hello Experts! I've written some code that prompts the user to indicate which column two type of data appear in. I then want to select those two columns, which may not be next to each other, to copy to another sheet. I've tried both versions below but neither work! Can anyone tell me where I'm going wrong? Columns(ISBNCol & "," & QtyCol).Select Columns(ISBNCol, QtyCol).Select Thanks Colin -- Colin Vicary ------------------------------------------------------------------------ Colin Vicary's Profile: http://www.excelforum.com/member.php...o&userid=10472 View this thread: http://www.excelforum.com/showthread...hreadid=507283 -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Selecting Non-Consecutive Variables
Colin,
It depends on what ISBNCol and QtyCol a numbers, ranges, strings? If numbers (3, 5, for example) or strings ("C", "E", for example): Union(Columns(ISBNCol), Columns(QtyCol)).Select If ranges: Union(ISBNCol.EntireColumn, QtyCol.EntireColumn).Select HTH, Bernie MS Excel MVP "Colin Vicary" wrote in message news:Colin.Vicary.22k66y_1138810501.1725@excelforu m-nospam.com... Hello Experts! I've written some code that prompts the user to indicate which column two type of data appear in. I then want to select those two columns, which may not be next to each other, to copy to another sheet. I've tried both versions below but neither work! Can anyone tell me where I'm going wrong? Columns(ISBNCol & "," & QtyCol).Select Columns(ISBNCol, QtyCol).Select Thanks Colin -- Colin Vicary ------------------------------------------------------------------------ Colin Vicary's Profile: http://www.excelforum.com/member.php...o&userid=10472 View this thread: http://www.excelforum.com/showthread...hreadid=507283 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Selecting Non-Consecutive Variables
Genius! Thank you, worked perfectly. Colin -- Colin Vicary ------------------------------------------------------------------------ Colin Vicary's Profile: http://www.excelforum.com/member.php...o&userid=10472 View this thread: http://www.excelforum.com/showthread...hreadid=507283 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
counting consecutive absences | Excel Worksheet Functions | |||
Count Intervals of 2 Consecutive Values in same Row and Return Count across Row | Excel Worksheet Functions | |||
adding three consecutive columns | Excel Worksheet Functions | |||
Passing Variables | Excel Discussion (Misc queries) | |||
Return Consecutive Values - Pairs | Excel Worksheet Functions |