excel vba - arrays vba - type mismatch: array or user-defined type expected -

-

i having issue passing array sub (receiving type mismatch: array or user-defined type expected). have worked array structures in other languages , must missing here in vba since can't work. have posted code snippets below comment:

private sub x()     dim ssn_vals(1 9) string     dim ssn_cells(1 9) string      'define employee object      dim emp employee       'create new employee foreach row       set emp = new employee      'ssn values         ssn_vals(1) = cell.offset(0, 60)         ssn_vals(2) = cell.offset(0, 61)         ssn_vals(3) = cell.offset(0, 62)         ssn_vals(4) = cell.offset(0, 63)         ssn_vals(5) = cell.offset(0, 64)         ssn_vals(6) = cell.offset(0, 65)         ssn_vals(7) = cell.offset(0, 66)         ssn_vals(8) = cell.offset(0, 67)         ssn_vals(9) = cell.offset(0, 68)            'ssn cell addresses         ssn_cells(1) = cell.offset(0, 60).address         ssn_cells(2) = cell.offset(0, 61).address         ssn_cells(3) = cell.offset(0, 62).address         ssn_cells(4) = cell.offset(0, 63).address         ssn_cells(5) = cell.offset(0, 64).address         ssn_cells(6) = cell.offset(0, 65).address         ssn_cells(7) = cell.offset(0, 66).address         ssn_cells(8) = cell.offset(0, 67).address         ssn_cells(9) = cell.offset(0, 68).address          emp.setssn = ssn_vals         emp.setssn_cells = ssn_cells          'validate ssn         emp.validatessn (ssn_vals)  end sub

i have sub defined inside employee class

'validate ssn public sub validatessn(ssn() variant)     dim integer     'dim orig_array(1 9) variant     dim multipler_array(1 9) integer     dim summation_array(1 9) integer       multipler_array(1) = 1     multipler_array(2) = 2     multipler_array(3) = 1     multipler_array(4) = 2     multipler_array(5) = 1     multipler_array(6) = 2     multipler_array(7) = 1     multipler_array(8) = 2     multipler_array(9) = 1        if me.getsinort = "sin"         = lbound(ssn(i)) ubound(ssn(i))            summation_array(i) = (int(ssn(i)) * int(multipler_array(i)))            debug.print summation_array(i)     next      else        end if   end sub

any suggestions on how fix trivial thing appreciated. in advance, michael

you using cell range, have not dim'ed or set it. there may other problems


Comments

Post a Comment

Popular posts from this blog

mysql - FireDac error 314 - but DLLs are in program directory -

-
i getting when trying access mysql database : [firedac][phys][mysql]-314. cannot load vendor library [libmysql.dll or libmysqlld.dll] this did not happen (unchanged) code, however, have upgraded windows 10 , had reinstall delphi xe8, system configuration matter. in order try solve problem, copied both of files c:\windows\sysytem32. when did not seem work, copied them \win32\debug, generated .exe resides. i imagine doing rather stupid, can't see what. the proper solution place driver file (eg., libmysql.dll ) in application's folder, or place installation location in fddrivers.ini file: [mysql] vendor=<folder>\libmysql.dll (recent versions of documentation seem use vendorlib instead of vendor in ini file.) see rad studio documentation topics configuring drivers (firedac) , connect mysql server (firedac) more information.
Read more

git - How to list all releases of public repository with GitHub API V3 -

-
so per documentation https://developer.github.com/v3/repos/releases/#list-releases-for-a-repository get /repos/:owner/:repo/releases should list relases , https://api.github.com/repos/jquery/jquery/releases should list releases in jquery project , not , why ? because repository doesn't have releases. has tags github presenting in releases page. for more clear example, see: https://github.com/hashicorp/terraform/releases which has both releases , tags showing on page, api shows releases: https://api.github.com/repos/hashicorp/terraform/releases
Read more

c++ - Getting C2512 "no default constructor" for `ClassA` error on the first parentheses of constructor for `ClassB`? -

-
my situation follows. let there header file classdeclarations.h , have following classes declared: class classa; class classb; class classa { public: classa(int x); classa(double y); int returninteger(void) { return m_x; } double returndouble(void) { return m_y; } private: int m_x; double m_y; } class classb { public: classb(int x); int returninteger(void) { return m_x; } private: int m_x; classa m_instancea_1; } let there *.cpp file called classdefns.cpp , define methods of classes declared in classdeclarations.h : #include classdeclarations.h classa::classa(int x) : m_x(x) { } classa::classa(double y) : m_y(y) { } classb::classb(int x) : m_x(x) { // line build error occurs m_instancea_1 = classa(0); } note have commented line compiler says there error: error c2512: 'classa' : no appropriate default constructor avai...
Read more