Hi All,
I have the following code to collect only one of the values in row C into a ComboBox1.
Now I want to change the code so that it still does the same, but than collect only the values from the visible cells.
Please Login or Register to view this content.
Last edited by Wijnand1; 01-26-2019 at 06:12 AM. Reason: fault
Did you try SpecialCells yet ?
Avoid using Select, Selection and Activate in your code. Use With ... End With instead.
You can show your appreciation for those that have helped you by clicking the * at the bottom left of any of their posts.
Yes, but not sure if the SpecialCells was placed right in the code, as it dot not work.
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks