Dragging a regular formula DOWN will not adjust the column numbers, only the row numbers, no matter how you absolute or notlooking to drag down the entire 12 cells for about 50 rows and just for the m to change to n, o, p
You would need to use something else like OFFSET or INDIRECT
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)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks