compilation - Sub line gives compile error: variable not defined -


upon trying run code error "compile error: variable not defined" , highlights sub line. here code reference.

sub ri_processing()     dim single     dim output() single 'define dynamic array solver output  process dmso data     = 1 45 step 1         workbooks("calibration range 1 normalized profiles.xlsx").activate         rawdata.range("c10:c649") = sheet1.columns("i").values         solverok setcell:="$e$7", maxminval:=2, valueof:=0, bychange:="$b$2:$b$4", _         engine:=1, enginedesc:="grg nonlinear"         solversolve         workbooks("simulated fresnel function.xlsx").activate         output(i, 1) = sheet1.range("b4").values      next      = 0      ' process nacl data     = 1 102 step 1         workbooks("calibration range 1 normalized profiles.xlsx").activate         rawdata.range("c10:c649") = sheet2.columns("i").values         solverok setcell:="$e$7", maxminval:=2, valueof:=0, bychange:="$b$2:$b$4", _         engine:=1, enginedesc:="grg nonlinear"         solversolve         workbooks("simulated fresnel function.xlsx").activate         output(i, 2) = sheet1.range("b4").values      next      = 0      ' process sucrose data     = 1 72 step 1         workbooks("calibration range 1 normalized profiles.xlsx").activate         rawdata.range("c10:c649") = sheet3.columns("i").values 'copies data of 'i' columns raw data solver         solverok setcell:="$e$7", maxminval:=2, valueof:=0, bychange:="$b$2:$b$4", _         engine:=1, enginedesc:="grg nonlinear"         solversolve 'run solver         workbooks("simulated fresnel function.xlsx").activate         output(i, 3) = sheet1.range("b4").values 'put solver output matrix 'output' in appropriate columns      next  end sub 


Comments

Popular posts from this blog

twig - Using Twigbridge in a Laravel 5.1 Package -

jdbc - Not able to establish database connection in eclipse -

Kivy: Swiping (Carousel & ScreenManager) -