| Home |
| Search |
| Today's Posts |
|
#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 |
| 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 | |||
Threaded Mode
