You may get some sample code that does this...

But if you explain what you're doing, you may find you get alternate
suggestions.

sancht wrote:

Hi

I have an excel sheet with over 50 columns. I was wondering if I could
write a macro (i'm a novice programmer) or record one to create name
ranges on each column. I am using the offset and count function to
name the ranges as I would be adding new rows (to the same columns)
every few days.

I hope someone cal help me.

Thanks,

ST

--

Dave Peterson