Astrophishon
New Member
- Joined
- Jun 6, 2013
- Messages
- 1
I have created a table and my function uses the array ranges within the table:
Table Name: Vendor
Label Names: Vendor Name, Vendor Status, Vendor Class ID[TABLE="width: 233"]
<tbody>[TR]
[TD][/TD]
[/TR]
[TR]
[TD]Corresponding Ranges:
A2:A2000, B2:B2000, C2:C2000
[/TD]
[/TR]
[TR]
[TD]I would use the array in my function such as
Vendor[Vendor Name]
When I log off and open the file on another day it reverts to the hardcoding:
instead of
Vendor[Vendor Name]
it becomes
$A$2:$A:$2000
[/TD]
[/TR]
</tbody>[/TABLE]
How can I keep it to the Table[Array Name] and prevent it from reverting to the hardcoding?
Table Name: Vendor
Label Names: Vendor Name, Vendor Status, Vendor Class ID[TABLE="width: 233"]
<tbody>[TR]
[TD][/TD]
[/TR]
[TR]
[TD]Corresponding Ranges:
A2:A2000, B2:B2000, C2:C2000
[/TD]
[/TR]
[TR]
[TD]I would use the array in my function such as
Vendor[Vendor Name]
When I log off and open the file on another day it reverts to the hardcoding:
instead of
Vendor[Vendor Name]
it becomes
$A$2:$A:$2000
[/TD]
[/TR]
</tbody>[/TABLE]
How can I keep it to the Table[Array Name] and prevent it from reverting to the hardcoding?
