excel - VBA Range and String confusion -

-

think i'm having problem difference between ranges , strings. trying search cells in range of winners spit out point value. 

sub it() dim round1 range dim round2 range dim lngcnt long dim winner() string dim pointsum double redim winner(1 4)     winner(1) = "mohler"     winner(2) = "scotter"     winner(3) = "dkgay"     winner(4) = "lassie" set round1 = range("l3,l11,l22,l32").text each winner in round1 lngcnt = lngcnt + 10 winner(lngcnt) = pointsum.value next msgbox pointsum.value     end sub

you need 2 loops:

sub it() dim round1 range dim round2 range dim lngcnt long dim winner() string dim pointsum double dim rng range dim long redim winner(1 4)     winner(1) = "mohler"     winner(2) = "scotter"     winner(3) = "dkgay"     winner(4) = "lassie" set round1 = range("l3,l11,l22,l32") each rng in round1     = 1 ubound(winner)         if rng.value = winner(i)             pointsum = pointsum + 10             exit         end if     next next rng  msgbox pointsum.value end sub

the first loops through ranges second through string array. when finds equal adds 10.


Comments

Post a Comment

Popular posts from this blog

php - Passing multiple values in a url using checkbox -

-
Image
i know may answered not able find related this. here thing struggling :- i have 2 value passing in check box :- <input name='class[]' type='checkbox' class='checkbox' value='".$x_value['type1'].":".$x_value['type2']."'> on running :- <input name="class[]" type="checkbox" class="checkbox" value="2681:14175"> so want how can pass these value separated ":" in url. something :- http://domainname.com/approve.php?type1=2681&type2=14175 purpose :- actually getting value api response curl , generating multiple checkboxes. each checkbox contains 2 value separated ":". now want run separate api in different file values url. update : below complete code :- <?php foreach($apiresponse['response']['data'] $x =>$x_value) { foreach($x_value $x => $x_value) { echo "...
Read more

java - nested exception is org.hibernate.exception.SQLGrammarException: could not extract ResultSet Hibernate+SpringMVC -

-
i trying fetch records database , having above error this classs appropriate getters , setters public class user { private int id; private string username; private string password; private string email; i have create database , inserted data below configuration <bean id="datasource" class="org.apache.commons.dbcp2.basicdatasource" destroy-method="close"> <property name="driverclassname" value="com.mysql.jdbc.driver"/> <property name="url" value="jdbc:mysql://localhost:3306/usersdb"/> <property name="username" value="root"/> <property name="password" value=""/> </bean> this complete stacktrace severe: servlet.service() servlet [appservlet] in context path [/spring] threw exception [request processing failed; nested exception org.hibernate.exception.sqlgrammarexception: not ...
Read more

sql - Postgresql tables exists, but getting "relation does not exist" when querying -

-
Image
i have postgresql db number of tables. if query: select column_name information_schema.columns table_name="my_table"; i list of columns returned properly. however, when query: select * "my_table"; i error: (programmingerror) relation "my_table" not exist 'select *\n "my_table"\n' {} any thoughts on why can columns, can't query table? goal able query table. you have include schema if isnt public one select * <schema>."my_table" or can change default schema show search_path; set search_path my_schema; check table schema here select * information_schema.columns for example if table on default schema public both works ok select * parroquias_region select * public.parroquias_region but sectors need specify schema select * map_update.sectores_point
Read more