vbacoder
Active Member
- Joined
- Jul 7, 2007
- Messages
- 354
Hi everybody,
If I apply a name to cells in a worksheet, and use these names as variables in VB code, do the names follow the cells when changes are made to the worksheet, or are they fixed? If they move, how can they be fixed to point to a certain location, irrespectice to cut/paste operations on the worksheet?
Many thanks,
vcoder
If I apply a name to cells in a worksheet, and use these names as variables in VB code, do the names follow the cells when changes are made to the worksheet, or are they fixed? If they move, how can they be fixed to point to a certain location, irrespectice to cut/paste operations on the worksheet?
Many thanks,
vcoder