You know how in excel how when you right a formula in A1 and then drag it down across several rows it will change all the reference cells by 1 for each row it goes across.
Example: My formula is,
=MATCH(A2,Additions!A1:A125,0)
When you drag it down to copy it to the next row it turns into,
=MATCH(A3,Additions!A2:A126,0)
I want it to be after dragging down to the next row to be,
=MATCH(A3,Additions!A1:A125,0)
Anybody know a way to do that?
Hello,
Please try this formula
If you add "$" to both side of a column letter, like $A$1, it will not change if you drag it horizontally or vertically.
Please Login or Register to view this content.
If it's only on the left side, like $A1, you can drag it vertically but NOT horizontally (down and up but not left and right)
Similarly, A$1 can only be dragged horizontally (left and right), not vertically (up and down)
Hope this help.
(copy pasta from Ford)
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
Regards,
Lem
Nice. I didn't know about the $ symbol being used for this. That solves my problem. Thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks