(let me apologize in advance for not using ANY of the proper lingo...)
Can anyone offer guidance on if it's possible to use defined cell names in formula codes instead of variables?
For instance, if I have a function with a defined term of StartWeek, ... in the line:
ActiveCell.Offset(2, 0).Range("A1").Select
would it be possible to replace the variable coordinates "Offset(2,0)" with my defined "StartWeek"? I'm trying to write a function that I can call up in any cell , horizontally or vertically, but will always look to the same locked cell position for a variable.
If you can make sense of this question, you're help will be greatly appreciated.
Thanks!
Can anyone offer guidance on if it's possible to use defined cell names in formula codes instead of variables?
For instance, if I have a function with a defined term of StartWeek, ... in the line:
ActiveCell.Offset(2, 0).Range("A1").Select
would it be possible to replace the variable coordinates "Offset(2,0)" with my defined "StartWeek"? I'm trying to write a function that I can call up in any cell , horizontally or vertically, but will always look to the same locked cell position for a variable.
If you can make sense of this question, you're help will be greatly appreciated.
Thanks!