Selecting Non-Consecutive Variables

[Colin Vicary]

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

[Bernie Deitrick]

Colin,

It depends on what ISBNCol and QtyCol are: 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" <[email protected]> wrote in message
news:[email protected]...
>
> 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]

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

[Colin Vicary]

Genius!

Thank you, worked perfectly.

Colin