Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Resize Range Question
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Resize Range Question
maybe:
with range("Mine") .offset(-1,0).resize(.rows.count+50).name = "myTable" end with (or should that be +51???) Ray Batig wrote: 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 -- Dave Peterson |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Resize Range Question
Ray Batig wrote:
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 Your terminology is a little confusing. Range("Mine").Resize(50).Name = "MyTable" doesn't add 50 rows to Mine; it changes the size of Mine to 50 rows. If Mine started out with 40 rows, it adds 10; If Mine started out with 55 rows, it subtracts 5. The following will name as "MyTable" a 51-row range with as many columns as Mine started out with, and beginning one row above the row on which Mine started out. Is that what you wanted? Range("Mine")(0,1).Resize(51,Range("Mine").Columns .Count).Name="MyTable" Alan Beban |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
<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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Resize Range - Macro | Excel Worksheet Functions | |||
Range Resize | Excel Programming | |||
Range Resize property | Excel Programming | |||
Resize Range Problem | Excel Programming | |||
Resize and a question | Excel Programming |