In cell A1 I have =$B$11
In A2 I have Formula...which contains $Z$11, $G$11, $M$11 .....
Can I say in A2 : $Z$(right,A1,2)......$M$(right,a1,2) ?
In cell A1 I have =$B$11
In A2 I have Formula...which contains $Z$11, $G$11, $M$11 .....
Can I say in A2 : $Z$(right,A1,2)......$M$(right,a1,2) ?
You would need to check out the indirect() function
I think you need to be a bit more specific here.
What formula are you using?
What do you want to change in it?
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