Goodmorning,
I am trying to use a worksheetfunction in VBA to win some time. I want to use the MATCH function to retrieve the row in which a certain item is stored. In this case I don't have to loop through an array.
Function finditem(dataItem)
Dim row DD as variant
rowDD =...
Good afternoon,
I've written some functions of my own which I want to use in several Excel Workbooks. So I created an Add-in (.xla) file to enable me to use the functions is several workbooks but only have to maintain one.
In the .xla file the are also some subprocedures / functions I would...
Goodmorning,
I am working with Excel and for protectional reasons I hide some columns. This gives a problem with charts as the hidden data is not reflected in the charts.
Question: Is there a way to show hidden data in charts? I am using embedded charts in Excel XP.
Kind regards,
Yuri
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.