I have a sheet called result and It has Products and Machines field
Machines.I am trying to count the number of columns the machines
have.Everytime I insert column my range changes.I have to insert column
if the depending on some validation.Default is two columns.That works
fine.When I insert another column it should give the count as 3 not 2.
I don't know if I should use Dynamic range or not.If I have to please
help me with the code.

See attached document and the code comments,Thanks!!!!

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