Thank you all! I actually figured it out after I read from your posts what the problem was. I changed the order in which i did things in code. Like instead of copying first and changing autofilters off after that I changed filters first and copied then :) Well this aint perfect solution as this...
I have a problem. I have button that copies a row from one sheet and pastes it on another sheets first empty row. It works just fine, untill autofilter is used on page. When some of the parts are filtered the table gets shorter and when that button described above is used it leaves empty space...
Thanks that helped :)
Now I have some new problems, but ill try first by myself. Last time i used excel was about 5 years ago and ive never programmed with VB, so this aint really too easy :)
I have a problem with Excel. Ive made a button that copies pre-made information from row and adds it on first empty row at end of a table on another sheet. Problem is that when a row is removed or cleared the first empty row is actually row after the row where data was last time copied.
Like...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.