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" wrote
in message ...
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