'Run' return value
 

Say I have a Function initParms() as Integer and spreadsheet cell(5,4)
contains "initParms" (I do not want to use the formula "=initParms()"). I
call the function with
Run Cells(5,4).Value
Run is supposed to return the same result as initParms(). How do I reference
the integer result in order to save it to another cell?

'Run' return value
 

On Tue, 29 Jul 2008 15:46:00 -0700, cyberpro
wrote:

Say I have a Function initParms() as Integer and spreadsheet cell(5,4)
contains "initParms" (I do not want to use the formula "=initParms()"). I
call the function with
Run Cells(5,4).Value
Run is supposed to return the same result as initParms(). How do I reference
the integer result in order to save it to another cell?

Dim i as Integer

i = Application.Run(Cells(5,4).Value)
--
Dick Kusleika
Microsoft MVP-Excel
http://www.dailydoseofexcel.com