Let's say I want to use an item from a cell I don't know yet, but I can find the number with a formula, which turns out to be 6 at one instance, is it possible to call A6 like this?
Let's say I want to use an item from a cell I don't know yet, but I can find the number with a formula, which turns out to be 6 at one instance, is it possible to call A6 like this?
Hi, welcome to the forum
If you already know what the 6 will be, but that it may change, you could probably use the INDIRECT() function. Something like this...
=INDIRECT("A"&6)
you could either hardcode 6 or reference it from another cell
However, I have a feeling that you also probably use 1 of the regular built-in lookup functions for this, such as vlookup or index/match.
If you give more detail then perhaps we can put something together for you?
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks