Use WorkSheetFunctio. (dot) and select the available function.
Although the Histogram is not a standard function. So you'll have to
track creation with the Macro recorder and then modify the code for it
to do what you want in VBA.
Use WorkSheetFunctio. (dot) and select the available function.
Although the Histogram is not a standard function. So you'll have to
track creation with the Macro recorder and then modify the code for it
to do what you want in VBA.
found it out up to that point up to now.
But when I try to call this macro or use it from vba I allways get
errors, don't found the according xla file, don't found the macro
I have clicked all references in excel and vba to the analysis file
nothing helps, many peaople seems to have problems with calling
the analysis functions from macros / vba.
found it out up to that point up to now.
But when I try to call this macro or use it from vba I allways get
errors, don't found the according xla file, don't found the macro
I have clicked all references in excel and vba to the analysis file
nothing helps, many peaople seems to have problems with calling
the analysis functions from macros / vba.
There Seems to be a problem with the German
atpvbaen/de file it does not work for some reason.
I had to setup a new link in the vba references pointing to the
english
atpvbaen.xla file and now can use the english version of the command
(histogram)
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
