Thread: Coding Up Histogram with dynamic range

Hi I have the dynamic Range "newPrice"

And would like the output range for the histogram table to be in cell "G10"


Is there a way to code this?

I have attempted the following with no luck:

Application.Run "ATPVBAEN.XLA!Histogram", .Range("newPrice"), .Range("G10"), , False, False, False, False

Many Thanks

would a moderator be able to move this into the charting sub-forum?
sorry

thanks