Ok
what I am trying to do is cycle through a woorkbook looking for cells set to a specific style in this case "TestRef" in all viewable (i.e not hidden) worksheets
The text within the cells found to have the specified style is then listed in a list box
<This I have done>
Next thing I want to...
I am trying to select a range of cells between to specific cells based on there style
I can pick as tart point and an end point easy enough
but when I try to define the area between the two as a range then I am getting the following error/
"Application-Defined or object-defined error"
I have...
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.