Klash Ville
Board Regular
- Joined
- Sep 19, 2017
- Messages
- 83
Hello everyone, I have the following code that simulates the user selecting the content (in this case, visible cells of a table column header):
Although, when this VBA code is executed, despite being originated from the recorder, it selects all cells, even hidden ones...
But when I do this manually, it only selects the visible ones, in this case, only 2 visible cells among 900 that are hidden.
Someone knows an alternative? If possible avoid loops... it just takes way too much loading time...
Code:
Range("Table2[Found]").Select
Although, when this VBA code is executed, despite being originated from the recorder, it selects all cells, even hidden ones...
But when I do this manually, it only selects the visible ones, in this case, only 2 visible cells among 900 that are hidden.
Someone knows an alternative? If possible avoid loops... it just takes way too much loading time...