I have a log that has dozens of worksheets named employees names (Last Name, First Name), I have a VBA that takes said names and creates a table of contents with hyperlinks. Now I have a formula that I enter that references those worksheets and tells me the value of a cell. But when I run the VBA to update the table of contents, the formula gets erased and I have to reenter it.
Can someone help me incorporate it into my VBA?.
Formula:andPlease Login or Register to view this content.
VBA:Please Login or Register to view this content.
Please Login or Register to view this content.
Bookmarks