VBA Excel object required passing string array variable -


i attempting pass array of strings function variable , getting '424 object required' error when try compare values in array values in given cell. new vba may simple syntax error cannot seem figure out. here's code:

method being called:

sub initializecharts()     'set's array checking data names in social groups     dim socialarray variant     socialarray = array("chores", "meat & potatos", "work", "wind down", "reward")     '...     call chartlogic(range("'activitytracker'!b12"), range("'groups'!f4"), socialarray) end sub

chartlogic method:

sub chartlogic(datacell range, tablecell range, socialarray variant)     dim temp double     dim count integer      '...     'loops through table , looks social cells same name, adding them chart     until isempty(datacell)         count = lbound(socialarray) ubound(socialarray)             if socialarray(count).value = datacell.value   '<---error here                 temp = socialcell.offset(count, 0).value                 socialcell.offset(count, 0).value = temp + datacell.offset(0, 4).value             end if         next         set datacell = datacell.offset(1, 0)     loop end sub

thanks in advance!

as andrew pointed out - socialarray(count).value = cause error because it's variant. can store local variable this.

arrval = socialarray(count) 

for count = lbound(socialarray) ubound(socialarray)     arrayval = socialarray(count)      if arrayval = datacell.value   '<---error here         temp = socialcell.offset(count, 0).value         socialcell.offset(count, 0).value = temp + datacell.offset(0, 4).value     end if next

or take off .value it's not cell , not worksheet object variant.

if socialarray(count) = datacell.value

-

Popular posts from this blog

Apache NiFi ExecuteScript: Groovy script to replace Json values via a mapping file -

i working apache nifi 0.5.1 on groovy script replace incoming json values ones contained in mapping file. mapping file looks (it simple .txt): header1;header2;header3 a;some text;a2 i have started following: import groovy.json.jsonbuilder import groovy.json.jsonslurper import java.nio.charset.standardcharsets def flowfile = session.get(); if (flowfile == null) { return; } flowfile = session.write(flowfile, { inputstream, outputstream -> def content = """ { "field1": "a" "field2": "a", "field3": "a" }""" def slurped = new jsonslurper().parsetext(content) def builder = new jsonbuilder(slurped) builder.content.field1 = "a" builder.content.field2 = "some text" builder.content.field3 = "a2" outputstream.write(builder.toprettystring().ge...
Read more

node.js - How do I prevent MongoDB replica set from querying the primary? -

read-operations-only: is there way have mongodb replica set, make mongodb instance on box connected to, mongodb gets queried? i have 3 ec2 instances behind aws load balancer. on each ec2 instance runs mongodb, part of replica set. i have express endpoints on nodejs , connect replica set follows mongodb.mongoclient.connect('mongodb://1.1.1.1,2.2.2.2,3.3.3.3.', function (err, db) { if (err) { complete('{}'); } else { i distribute load of queries evenly across 3 instances of mongodb replica set instead of default having queries routed ec2 instance primary mongodb defined, because destroys point of load balancer (which balance load of queries across 3 instances evenly). my understanding when connecting mongodb replica set, primary instance selected unless primary instance down, , therefore purpose of every secondary instance serve backup. in example people call hot,cold,cold. because there 2...
Read more