<Dave & Alan Resize Range Question
Thanks to you both. Either solution worked. I appreciate your help!
Ray
Ray Batig wrote in message
ink.net...
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
|