Hi,
1) Below code will result cell C2 as "=VLOOKUP($A2,'Jul-Dec''12'!C382:AI405,33,FALSE)", how to make the C382:AI405 to $C$382:$AI$405?
Please Login or Register to view this content.
Hi,
1) Below code will result cell C2 as "=VLOOKUP($A2,'Jul-Dec''12'!C382:AI405,33,FALSE)", how to make the C382:AI405 to $C$382:$AI$405?
Please Login or Register to view this content.
Last edited by viva2kh; 10-18-2012 at 02:15 AM.
Hello viva2kh,
Just highlightand press F4C382:AI405
Please consider:
Be polite. Thank those who have helped you. Then Click on the star icon in the lower left part of the contributor's post and add Reputation. Cleaning up when you're done. If you are satisfied with the help you have received, then Please do Mark your thread [SOLVED] .
Hello Winon,
Sorry, I should make my statement clear.
I mean I need the result in C2 to appear as "=VLOOKUP($A2,'Jul-Dec''12'!$C$382:$AI$405,33,FALSE)" automatically after run the macro.
Thank you for your reply.
hi viva2kh,
Please Login or Register to view this content.
Last edited by watersev; 10-18-2012 at 04:06 AM.
Thanks guys! I just change to
.address(1,1)
and the $ is appear now after run the macro.
Hello viva2kh,
I am still a bit confused here.
You can try:
If that does not work, could you please upload a sample WorkBook, showing what you have, and showing what you would like to have?Please Login or Register to view this content.
Thank you.
Last edited by Winon; 10-18-2012 at 04:15 AM. Reason: Corrected Code
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks