Why does my macro in VBA is not as it should !?

Hi, I have a macro programmed in Excel 2010 VBA and it works FAST! Why does not it does exactly what it should do, is beyond me .... Here's the source code: http://www.codecopy.de/?action=show&q=1f8885 And to what do if someone to trigger macro the entire row in which the ActiveCell is copied and transferred to the sheet! So far this worked. If I now have a line containing a name and any other is, for example Maximilian ..... then it copies the line in the other worksheet and adds them to the next blank line. I can with this one line, is on the Maximilian, so often I want to do, he adds the line wherever he is now if I want to transfer to another line .... BUT, in the Alexander .. ..., is, then copies them even in the other sheet, but all that was there before is overwritten (except for the first targets) of the new copy !!! How can I change this, or what is the code wrong ?! It is namely not override all, but simply the new copy may also be inserted in the next blank line! Thanks for your answers in advance!

PS: That the date is not important and does!

The best answer

Hello agent888,

I program in general in a different style, and never use the property 'UsedRange' actually. Stattdesen I use the method 'SpecialCells'. And since it is so that when a row is inserted, it is determined only correct when the file was saved. So try to use 'ThisWorkbook.save' before the line 'UsedRange'.

Honestly intentioned Tip: Look at C #. You'll thank me!

VBA is my view waste

Date: 2012-12-03 Views: 0

Related articles

  • Why does the landlord the information is not made if the apartment is already gone? 2014-09-12

    Why does the landlord the information is not made if the apartment is already gone? That's too many waste of time for the viewfinder! What is wrong with such owner? --answer-- had not yet time to forget it or to those interested do not want to rent t

  • why does my nose piercing from behind not get out? 2014-11-27

    Property me 2 weeks ago can shoot when I have taken the health plug out today and my new piercing did with ball behind purely a nose piercing (nasenflugel), I've noticed that the new piercing, behind does not come out. Why is that so ?" --answer-- By

  • Why does the spider sense of Spiderman not really? 2012-02-17

    How it already from the two Spiderman movie series knows (Spiderman with Tobey Maguire & The Amazing Spiderman with Andrew Garfield) is bitten Peter Parker from a genetic spider and then gets superpowers and becomes Spiderman. For this he gets the sp

  • Why does the FRG then issued passports not for GDR citizens fleeing? 2012-06-04

    One would have to smuggle FRG passports in the GDR, so DDR citizens could leave to Germany without an exit order. My second question is: Got GDR citizens, which escape was successful in the West a BRD Pass in the west? --answer-- I once traveled back

  • Why does the gestation in dogs is not as long? 2013-03-15

    Hello, and although I wanted to ask why so does not take a pregnancy in the bitch as long you times. If the cell division just much faster or has other reasons to be? I've often seen pregnant bitches, what could be seen from the outside hardly anythi

  • Why does echo $ USER / etc / xdg / autostart not? 2014-05-16

    Hello, from experimental setup times tried echo $ USER> ~ / usertest in a bash script to write and / etc / xdg / autsostart open. Unfortunately that did not work. About shc (bash shell script compiler does this work) why? mfg bluedxca93 --answer-- Be

  • Why does the light or electromagnetic radiation not a medium to spread out? 2014-11-27

    --answer-- That was long disputed. It was assumed that electric waves propagate in the so-called light ether. The experiment of Michelson and Morley described here has then proved that this ether does not exist. https://de.wikipedia.org/wiki/Michelso

  • why does burning series pretty little liars not with me? 2012-02-13

    Since hrute morning the website is not available, someone knows why? --answer-- The site is frequently down, after few hours it would have to go back;)

  • Why does EOS (Echo of Soul is not? 2012-04-16

    So the following problem if I want to start EOS or the associated program Aeria Ignite is because there was an attempt to open a file with the wrong format. Can you give me somehow thank help: D --answer-- I would recommend you times the drop in on p

Links

Domicile|Sante|

Copyright (C) 2019 m3tch.com, All Rights Reserved.

M3tch all rights reserved.

processed in 0.928 (s). 10 q(s)