Hello guys, I made filtered ComboBox, which is done by using SpecialCells(xlCellTypeVisible), but now I have a problem with data paste. RowIndex, which I use for this, count all rows, not just the filtered rows. Is there a way, how to do something like this: RowIndex.SpecialCells(xlCellTypeVisible) = Me.ComboBox1.ListIndex ? Here is the code, which I need to "repair" Any help you can offer would be hugely appreciated. (Code, 31 lines)

RowIndex count match only with visible rows

Don’t have an account yet? Register yourself now and be a part of our community!

This site uses cookies. By continuing to browse this site, you are agreeing to our use of cookies. More Details Close

Your browser has JavaScript disabled. If you would like to use all features of this site, it is mandatory to enable JavaScript.