Change chart source data range

Something about charting VBA that drives me nuts!!!

I'm attempting to change the range callout for a chart range.

In the following code the hard-coded range in the 1st instance of .Chart.SetSourceData........ works great, however i need the flexibility to expand/contract the range of cells, hence the routine below to capture the row number in column F with values greater than zero. I should note that the database has been sorted such that the order of cells in column F is in descending order.

The intent was then to use the icount variable in the range callout for the chart range.

The strange thing is i get an error message, Run-time error '1004': but the code appears to change the range correctly but then i need to abort the remainder of the code, any help would be appreciated.

Please Login or Register  to view this content.

Hi,

change this line of code :

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

as icount is a variable.