LinkBack URL
About LinkBacks
hi all
i understand how to stop a range changing when i am referring to Cells such as $A$12 however can someone tell me how i stop the formula moving
=COUNTIFS(List1[COY],"A",List1[COACH 35-55],"<>")
i want to stop [coy] list moving or changing
hi all
i understand how to stop a range changing when i am referring to Cells such as $A$12 however can someone tell me how i stop the formula moving
=COUNTIFS(List1[COY],"A",List1[COACH 35-55],"<>")
i want to stop [coy] list moving or changing
Assume you have a formula in A1 that is correct and you want to drag it to G1.
Start in cell A1 and select A1 to G1. Hit Ctrl+r.
<----- If you were helped by my posts you can say "Thank you" by clicking the star symbol down to the left
If the problem is solved, finish of the thread by clicking SOLVED under Thread Tools
I don't wish to leave you with no answer, yet I sometimes miss posts. If you feel I forgot you, remind me with a PM or just bump the thread.
Hmm... If you want to stop one from moving but not the other I suggest building up the name with & and evaluate it with INDIRECT.
Instead of: =COUNTIFS(List1[COY]
you can use: =COUNTIFS(INDIRECT("List1["&$B$2&"]"
put "COY" in B" ofcourse
JACC yes control R that works however it copes all across the cells, i only want the part where it says Coy to stay
i cannot get the indirect to work mate
That looks like a formula from a Table? If si, maybe try typing in that particular reference manually - so that if "List1[COY]," is actually A2, then type in A2 and absolute as needed ($A$2, cell abs...$A2, col abs...A$2, row abs)
If that still doesnt work, I think to avoid guesswork, it would help if you uploaded a sample o what you are working with?
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
You need double "" around the A, I think.
I just did this before I realized there might be an issue with "". I'll post it anyway.
JaccOriginally Posted by Jacc
I just did this before I realized there might be an issue with "". I'll post it anyway.
i like it a lot mate thank you, will keep this in mind for future projects
mick
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks