Hi,

I am using an inputbox to get a range a data from the user.

Set rngToChart = Application.InputBox(Prompt:="Select the range you wish to chart!", Title:="Select a range", Type:=8)
This works ok if the user selects a range, however if i select the cancel button i get a Run-time error 424, object required.

jonnyuk3