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