'Run' return value

C

cyberpro

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?
 
D

Dick Kusleika

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top