Thread: type missmatch on Selection.Offset
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
webby2006[_7_] webby2006[_7_] is offline
external usenet poster
  
Posts: 1
Default type missmatch on Selection.Offset

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

Reply With QuoteReply With Quote