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

html - Firefox flex bug applied to buttons? -

-
i'm trying apply flex button on firefox i'm having problem on chrome doesn't happens. this css: .button { display: inline-flex; align-items: center; } as can see in fiddle, "caret" word moved new line, happens if element <button> tag, <div> works expected. http://codepen.io/anon/pen/xblmgx is firefox bug or there css i'm missing? nevermind, looks "mr firefox" doesn't idea... <button> not implementable (by browsers) in pure css, bit of black box, perspective of css. means don't react in same way e.g. <div> would. this isn't specific flexbox -- e.g. don't render scrollbars if put "overflow:scroll" on button, , don't render table if put "display:table" on it. stepping further, isn't specific <button> . consider <fieldset> , <table> have special rendering behavior: data:text/html,<fieldset style="d...
Read more

html - Missing border-right in select on Firefox -

-
Image
when put select div width , padding-left, options have no border on right. more, happend if select have width 118px , parent have 15px of padding left! have idea, going on? my code: <!doctype html> <html> <head lang="en"> </head> <body> <div style="width: 1000px; padding-left: 15px;"> <select style="width: 118px;"> <option>a</option> <option>b</option> <option>c</option> </select> </div> </body> </html> and result: here plunker: click it happend on firefox on windows. tested on 40.0.2 version -webkit-box-sizing: border-box; -moz-box-sizing: border-box; -ms-box-sizing: border-box; box-sizing: border-box; source: https://stackoverflow.com/a/11390432/4431269 source of problem: https://bugzilla.mozilla.org/show_bug.cgi?id=924068 and use of google ! edit: (source of problem, explained) after rea...
Read more

python - build a suggestions list using fuzzywuzzy -

-
i building suggestion engine database. i'm using fuzzywuzzy module match user input string existing database shown below. if request.method == "get": display_dict = {} user_input = request.get["user_input"] # user input match_dict = {} food_items_obj = food_items.objects.all() # fetch objects table items in food_items_obj : match = fuzz.ratio(user_input.lower(),items.name.lower()) # try match user input existing names match_dict[match] = items.name # put 1 dictionary matched_dict = ordereddict(sorted(match_dict.items(),reverse = true)) # sort dictionary if max(matched_dict.keys()) == 100: # if exact match put in dict , return display_dict[100] = matched_dict[100] else : # if not found try best matching words.. ###########this part need help! ############# k,v in matched_dict.items(): if user_input in v : display_dict[k]...
Read more