Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
sending parameter of another cell value
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
sending parameter of another cell value
Oops, this does work, I did not have my active cell set properly
Dim intMaterial As Integer intMaterial = ConvertMaterial(ActiveCell.Offset(0, -15).value) Arnold |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
sending parameter of another cell value
I had a vague rememberance of what I thought was your function (did you post
it some time ago?) and had the impression you were passing in an address string - so I guess I didn't pay as close attention as I should have since your code shows you were passing in the value. Value would be the property to use as you have discovered. -- Regards, Tom Ogilvy "Arnold Klapheck" wrote: Oops, this does work, I did not have my active cell set properly Dim intMaterial As Integer intMaterial = ConvertMaterial(ActiveCell.Offset(0, -15).value) Arnold |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
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 |