VBA error in Excel: Invalid Use of Property -

-

I've written the code at CommandButton_Click () , but it returns the following error:

/ P>

Error Compiled: Invalid use of property. 

  Folk Sub SectorName () as a slow score string, the result of integer as integer as an integer = 1 to 473 score = category ( "AB" + a_counter). If the score = "Technology and FM" then results = "25" als score = "operating equipment and supplies" then results = "26" als score = "interior and design" followed by result = "27" als score = "outdoor And Result Experience "then Results =" 28 "Els Score =" Horaco "then Results =" 29 "Els Score =" Retail and Franchise "Then Results =" 30 "Els Score =" Design "Then Results =" 33 "Els Score = "Health and Fitness Exits, P & S" After Results = "32" Else score = "Entertaining fun and am p; Adventure" then result = "31" or the result = "35" category ("AC" + a_counter) Price End If Next a_counter End sub

please help me find a solution.

You have some minor problems:

  1. Getting on: 

      Range ("AC" + a_counter). Value

    I believe you have to: 

      range ("AC" + a_counter). Value = result

  2. This: range ("AB" + a_counter) and this: range ("AC" A_counter) should use & amp; and not + to add the strings, otherwise you will be able to enter the and range ("AC" and )

    3. < Li>

    I have just edited your question and with better indentation, I have also noticed that your is the end if is < Strong> after range ("AC" + a_counter). Value should be first , otherwise your result will be specified in the Other case and not for anyone else.

Therefore, your last code should look like this: 

  public sub region name () String as a slow score, result round As integer as integer, a_counter = 1 to 473 score = range ("AB" and "a_counter"). If the score = "Technology and FM" then results = "25" als score = "operating equipment and supplies" followed by result = "26" als score = "interior and design" then results = "27" als score = "outdoor "Result =" 28 "Else score =" Horaco "then Results =" 29 "Els Score =" Retail and Franchise "Then Results =" 30 "Els Score =" Design "Then Results =" 33 "Els Score = "Health and Fitness Eqpts, P & S", then W Reason = "32" Els Score = "Entertainment Fun and Adventure" Then R Esult = "31" Other Results = "35" End If Range ("AC" & A_counter) Value = results next a_counter termination sub

Now you should work as expected.


Comments

Post a Comment

Popular posts from this blog

java - org.apache.http.ProtocolException: Target host is not specified -

-
I have written a simple httprequest / response code and I am getting this error below: I used to type in my classpath httpclient, httpcore, common -Codecs and general logging. I am very new to Java and I do not know what's going on here. Please help me. code: import org.apache.http.client.HttpClient; Import org.apache.http.client.methods.HttpGet; Import org.apache.http.HttpResponse; Import org.apache.http.impl.client.HttpClientBuilder; Import org.apache.http.Header; Import org.apache.http.HttpHeaders; Public class UnshorteningUrl {public static zero main (string [] args throws exception {HttpGet request = zero; HTTP Client Client = HTTP ClientBuilder.credit (). Build (); Try {Request = New HTTP Gate ("trib.me/1lBFzSi"); HttpResponse httpResponse = client.execute (request); Header [] header = httpResponse.getHeaders (HttpHeaders.LOCATION); // Preconditions.checkState (headers.length == 1); String new url = header [0] .getValue (); System.out.println ("new url...
Read more

java - Gradle dependencies: compile project by relative path -

-
Is it possible to specify a dependency on another gradeal project in the granular (in android studios) outside the current project limits? For example, with a relative path like this: dependence {collection project ('../../ stdlib / dagger'}} MyApp (path / user / foo / workspace / mypad) The app (Path / User / Foo / Workspace / MyPass / App) And I have an Android Library Project with 3 subdomules: stdlib (path is / user / foo / Utilities (Path / User / Foo / Workspace / Stadlib / Utilis) http (Path / User / Foo / Workspace / Stadlib / HT) / Li> What I have to do is compile the Dagger, Util, http module in the MyApp project. The Stidelib Library module under heavy development And MyApp will grow in the form of Growth, so I do not want to push them into a Mewen repository. I am a little change. is likely to add another Gredle projects in some way? I will push the study library into the Maven repository after the source is in search of a temp...
Read more

ruby on rails - Object doesn't support #inspect when used with .include -

-
So I have participated in a glitch error that I do not even know how to debug. I am very new to the railing, so it has kicked my ass well when I use the .includes (school) seen by the student, it gives a blue box error, But when I look at any other model and .includes (school) , the school works just fine. class student & lt; ActiveRecord :: Base has has_many: relationships, foreign_key: "liker_id", dependent :: has_many: matches, foreign_key: "student_1_id", dependent :: deleted belong_to: school belong_to: conference belong_to: would_you_rather belong_to: home city belong_to: year is_to: Major and class school & lt; on the console activatecord :: Affiliate for the base: conference includes: respondent, class: "school", foreign_key: "rival_id" (e.g. For: School) Select SQL generated Select "School". * "School" from "school" "ID" IN (1) error message back NoMethodError: u...
Read more