| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Offset Type Lookup | Excel Worksheet Functions | |||
| Selection type | Excel Programming | |||
| type of selection if selection is chart | Excel Programming | |||
| Object Type of a selection... counting rows in a selection | Excel Programming | |||
| Offset and Range Selection | Excel Programming | |||
![webby2006[_7_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
