excel - I need help fixing vba macro -


After

I have a dataset that is made up of a number of rows and columns such as 

  a1 B1A2B2B3A3A4B4A5 B5   
 I want to type the code that loop through cells once it's (A2-A1) One column in the calculation of an index / (A2 + A1). I want to save the result to Sheet 2.  
 I have used this code but I am getting an error where it breaks on where I am trying to save the result for Sheet2  
 I help Need to fix this code:.   Sub-combination () dim the range as jCell Range dimmer in the form of Kcell in each JCell ActiveSheet.UsedRange result in ActiveSheet.UsedRange results for each Kcell = Double Sheet2.Cells.Clear (JCell.Value - kCell.Value) / (jCell.Value + kCell.Value) Sheet2.Cell ("Result"). Value = Sheet1.Cell ("Result"). Price Next Kcell Next jCell End Sub   
 Thanks in advance   
 
 
 One is that I have never seen the syntax like this:.  
  Sheet2.Cell ("Result") value = Sheet1.Cell ("Result".). The second is that string type data eg "A1" b1 in your dataset - why do you want to do mathematical operations with strings? Do you try to combine them together? Otherwise, you can only get stupid numbers if you do arbitrarily mathematical operations with strings.  
 One third is that you have to write one of the two letters in line with the output To do this, you might want to use a counter, this is an example of all that works - I'm not sure if this is what you want to do or if it helps you: / P>   sub-combination () dim jcl range dim the range as the result of the kcl string as the result of the dematerialisation i have integer i = 1 sheet 2 for each JCL in ActiveSheet.UsedRange each KCL For ActiveSheet.UsedRange Results for jCell.Value and KCell.Value Sheet2.Cells (i, 1) .Cells.ClearCalarValue = Result I = I + 1 Next KCell Next JCL and Sub   
 Good Luck.

Comments

Post a Comment

Popular posts from this blog

Python SQLAlchemy：AttributeError: Neither 'Column' object nor 'Comparator' object has an attribute 'schema' -

I tried to create a new database in my project, but when I run the script, I get this error, I have another project, this type of definition worked before, but now it gets a single error. I am using Python 2.7.8 and the version of SQLAlchemy module is 0.9.8. By the way, using a project flask- SQLAlchemy, it works well, I'm confused. Traceback information is as follows: Traceback (most recent call final): File "D: / Projects / IOM / db_create.py", line 4, & lt; Module & gt; From the models the base file "D: \ Projects \ OO-IM \ models.py", in line 15, in the & lt; Module & gt; Column ( 'followed_id', int (), ForeignKey ( 'user.id')) file "C: \ Python27 \ lib \ site-packages \ SQLAlchemy \ SQL \ schema.py", line 369, __new__ schema = metadata. Schema file "C: \ Python27 \ lib \ site-packages \ SQLAlchemy \ SQL \ elements.py", line 662, AttributeError in __getattr__ key): Neither 'column' object nor ...
Read more

java - How not to audit a join table and related entities using Hibernate Envers? -

I use Eners to be hibernate to audit my institutions. I have an audit entity, Foo , which includes a list & lt; Bars & gt; However, I do not want to audit the bar institutions, in the form of properties, I have written that: @inti @edicated public class Foo {@JoinTable (name = "T_FOO_BAR", joinColumns = @JoinColumn (name = "FOO_ID"), inverseJoinColumns = @JoinColumn (Name = "BAR_ID")) @ManyToMany (Cascade = Persist) @ Indited (targetAuditMode = RelationTargetAuditMode.NOT_AUDITED ) Public listing & lt; Bars & gt; GetBars () {Return bars; }} Now, I want to retrieve an amendment of foo : AuditReader reader = AuditReaderFactory.get (GetEntityManager ()); FU modification = (FU) reader.CreativeTeA () .entensEtrevision (Foo Class, 42) .getSingleResult (); Unfortunately, when I want to retrieve all the data (i.e. when it loads lazy times ), error me ORA-00942: table or view is not present , because Tried to query this: Sel...
Read more

mongodb - CakePHP paginator ignoring order, but only for certain values -

While pagging my user model in kppp, I can sort with some values, but not others. For example, I can order results from created or email , for example, but username or reputation seems to come back order by arbitrary command for example with a list of users: $ this-> paginate = array ('condition' => array ( 'User.is_active' = & gt; true), 'border' => 24, 'order' => array ('User.created' => DESC)); Works as expected, but $ this - & gt; Paged = array ('conditions' = & gt; array (' user.isIactive '= & gt; true),' border '= & gt; 24,' command '= & gt; array (' user repeats' = ' & Gt; DESC ')); No, no. I first thought that this could be a database issue, but when I search the database directly, sorted as expected. Note: I am using Mangodebi with the Mongo DB plugin of Ichikawa for the KPPHP; Pagnetizing users are used to work properl...
Read more