VBA To Create Named Ranges

I'm new to VBA so I definitley need some help. I have a large Excel file that has multiple worksheets and I need to create named ranges for it. I'm looking for a code that will look into the named worksheet and create a named range for every column Starting with Column Q and continuing to column AB. The columns vary in length, so the named range needs to start in row 4 and extend to the last cell that contains a number. The name for each range needs to be whatever is in row 3 of that column.

I'm hoping that this will save on time and I'll be able to apply it to each needed worksheet.

Please do not duplicate post

http://www.excelforum.com/excel-prog...ed-ranges.html

Have you tried using Value to make sure it is looking at the results and not the cell contents?