Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
currently am using code:
Dim intMaterial As Integer Dim strMaterial As String strMaterial = ActiveCell.Offset([0], [-15]) intMaterial = ConvertMaterial(strMaterial) the above works, but was going to try to reduce by two lines to: Dim intMaterial As Integer intMaterial = ConvertMaterial(ActiveCell.Offset(0, -15)) 'runtime error 1004 object defined error -or- Dim intMaterial As Integer intMaterial = ConvertMaterial(ActiveCell.Offset(0, -15).Address(0,0)) 'returns cell reference, not value -or- Dim intMaterial As Integer intMaterial = ConvertMaterial(ActiveCell.Offset(0, -15).value) 'runtime error 1004 object defined error ConvertMaterial is my own function that takes in a string and returns an int. Any ideas how to do this? thanx |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I use a cell value as a parameter | Excel Worksheet Functions | |||
How to choose if I use a parameter or not in a parameter query | Excel Discussion (Misc queries) | |||
Sending the current row number as a parameter to a function | Excel Programming | |||
Sending a parameter to a Userform | Excel Programming | |||
Format when sending a range as parameter to a custom function | Excel Programming |