The code I tried so far is: Dim I As Integer I am not a CS major and new to VBA - sorry if this question is silly and thank you very much for your help!
Only one chart has been created among the worksheets, and there is no data in it (the chart code is copied from running a macro). If I keep pressing OK VBA would crash, and if I press Cancel, only the last worksheet generates the table. The code I have so far does not generate the table and whenever I run it a window pops up and asks me to press OK to overwrite data. The table should be located at cell AK23 and the graph should be spanning N2:S20 in each worksheet.
(2) the Bin Range (the interval I want to use for the analysis), represented by "pasteRange2" in my code.Ĭreate both the histogram table and histogram graph. (1) the Input Range (the data I want to analyze), represented by "pasteRange"in my code. In each worksheet, I have these two columns of values: Hi I am trying to create a histogram for each worksheet in a workbook.
0 kommentar(er)
