I have attached the file which will hopefully make it easier. The macr
in question is called "Name Ranges" and I have placed '*' where I thin
that the problem lies.

I have produced a table, Data, which supplies the chart with the dat
that it needs. And it works fine until I add additional rows to th
table located within Data.

I would appreciate it if I could have some assistance in adding ne
rows to this table which will allow the chart to be updated wit
additional information. I think that it has something to do wit
Intergers, Variants and Ranges but I have looked through it thi
morning without sucess.

If anyone can aid me in this, that would be fantastic.

Regards,
Kieron White
:confused

Attachment filename: audit tracker.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=53111
--
Message posted from http://www.ExcelForum.com