Greetings,

I am confused. This code,

Range("Mine").Resize(50).Name = "MyTable"

takes the number of columns from Mine and takes the row from Mine and then
adds 50 rows and then uses these references for MyTable.

How would I modify this resize to build MyTable maintaining the same columns
as Mine, but starting one row above the Mine row and also adding 50 rows?

Thanks in advance for your help.

Ray