Greetings,

Mine is a range in a column. I would like to build Mytable having the same
number of rows as Mine, but, 30 columns wide.

I tried

Range("Mine").Resize( ,30).Name = "Mytable

but it gives me the error Method "Range" of object'_Global' failed.

How do I fix this? Are there some references that explain this approach?

Thanks in advance for your help!

ray