Thank you very much for the video. But, I can only the code in step into mode(F8), and not able to execute it (F5), the file get close whenever I execute the code, hence please help how to fix the problem!
I would like to create a chart in vba where the input data range changes based on user input. So for example I sometimes have 10 rows which should be displayed in the chart, but the next time the code gets run it might be 15 rows. Any idea how I could do that or is there a video/tutorial that talks about this?
Hi, I noticed that when you do it, the cell A1 is not picked up by the chart, which is correct; but when I do it, it picks it up as a series. Is there a setting I need to change somewhere? Thanks,
Hi. The general principle of copy and paste is covered in this vid ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-2n2qaT6KuH0.html. You would apply this to the chartobject.
Too advanced. You already have a filtered table. you use 'set ='. can you please explain it simply? like, the only most basic things to someone who's new?