Reference Worksheet based on cell value
-
her.rockstar -
May 8, 2017 at 6:59 PM -
Thread is marked as Resolved.
-
-
-
-
Re: Reference Worksheet based on cell value
KjBox - Do you use the bracket notation to shortcut using .Range?
-
Re: Reference Worksheet based on cell value
Yes, the square brackets really mean "evaluate" so when they enclose a range reference they tell the computer to evaluate that range. Since Value is the default property of a range there is no need to include it.
will all return the same thing - the value of cell F3. -
Re: Reference Worksheet based on cell value
Thanks for your help! I got it to work, but I had to use .Value after the square brackets. Thanks again!
-
-
Re: Reference Worksheet based on cell value
Cool, thanks KjBox.
Participate now!
Don’t have an account yet? Register yourself now and be a part of our community!