Reference A2 cell in individual sheets Vba Script
I have below Vba Script where all the name of individual sheet get transfered in A column of new sheet called " Sheet Names" which is fine but what I would like to add to the script is all the A2 reference appearing in those indivual sheets also appearing in B column next to individual sheet names in sheet "Sheet Names".
Please Login or Register to view this content.
Thank you
Last edited by tek9step; 06-11-2009 at 07:40 AM.
Something along the lines of the below perhaps ?
Please Login or Register to view this content.
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
Re: Reference A2 cell in individual sheets Vba Script
Cheers it works perfect.. !!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks