type missmatch on Selection.Offset

Please Login or Register  to view this content.

Please Login or Register  to view this content.

I am getting type missmatch. What is the correct data type should I be passing as argument?

Thank you.

Webby,

The comma isn't a string so you don't need quotes around it. So.....

Selection.Offset(iOffset1, iOffset2).Select

....will work.

Best regards

John


"webby2006" <webby2006.2c0hte_1154688605.7147@excelforum-nospam.com> wrote
in message news:webby2006.2c0hte_1154688605.7147@excelforum-nospam.com...
>
> Code:
> --------------------
> Sub DuplicateColumns(iOffset1 As Integer, iOffset2 As Integer)
>
> Selection.Offset(iOffset1 & ", " & iOffset2).Select
>
> End Sub
> --------------------
>
>
> Code:
> --------------------
> Call DuplicateColumns(0, 3)
> --------------------
>
>
> I am getting type missmatch. What is the correct data type should I be
> passing as argument?
>
> Thank you.
>
>
> --
> webby2006
> ------------------------------------------------------------------------
> webby2006's Profile:
> http://www.excelforum.com/member.php...o&userid=36744
> View this thread: http://www.excelforum.com/showthread...hreadid=568268
>

Originally Posted by John

Webby,

The comma isn't a string so you don't need quotes around it. So.....

Selection.Offset(iOffset1, iOffset2).Select

....will work.

Best regards

John

John,
an insight info I cannot forget, thanks a million.
webby