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])) ConvertMaterial is my own function that takes in a string and returns an int. Any ideas how to do this |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel lookups should have a return paramater if not found | Excel Worksheet Functions | |||
Display Paramater value in a cell | Excel Discussion (Misc queries) | |||
Paramater driven value | Excel Worksheet Functions | |||
Naming Pivot Table Paramater Report | Excel Discussion (Misc queries) | |||
Newbie question: function call | Excel Programming |