Error with Dynamic named range

Hi,

I referenced this post http://www.excelforum.com/excel-prog...eader-row.html to create vba for to name the range for a workbook based onheaders that don't start in row one.

Attached is a sample of the workbook i am using this in, with the code in Module 1. The data starts in A7 so at the prompt for the top leftmost cell of the table i am entering A7 (am i instead supposed to put the cell of the leftmost header?). I am getting the 1004 error message: I am guessing it is because i have unacceptable characters in my headers. How do i adjust the code to replace any unacceptable characters (such as %, (, -) with an _?

Help would be greatly appreciated (I am a bit of a vba novice, so I apologize if this seems like it should be easy to do).

Here's my code:

Please Login or Register  to view this content.

Thanks,
Angela