View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Ray Batig Ray Batig is offline
external usenet poster
 
Posts: 74
Default <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