variable sheet name

Hello, I have an excel with few hidden and unhidden tabs. I have written a VBA code for one of these tabs and then I hid the tab. I will send this excel to someone else, and that someone will change the name of this tab. How can I make the VBA code to get this variable name and run the code...

I could not find this in another thread so please point me there if it exist. I've been using INDIRECT when I need to use a refer to tab name based on a value in a cell, but it uses the volatile INDIRECT formula. Is there a better way to do this using INDEX or something that isn't volatile...

Hello there! How can I use "HYPERLINK(link_location, [friendly_name])" with variable workbook and sheet name and spece between their names. I linked the "[friendly_name]" to sheet name.The argument "[friendly_name]" doesn't allow the hyperlink to work if there's a space between either...

I am working on a macro that enables automation of data collection from different sheets into one sheet in the same workbook. I think I have the code as it should be in logic, but there are inconsistenicies in the syntax. I have highlighted these two lines in red below. I tried to help...

Hi,<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> <o:p></o:p> <o:p></o:p> In Sheet 01, cell C58 holds the month (as text), D58 holds the day number (as extracted from sheet name), and E58 holds the year (as number). I have other cells on this sheet that...

I'm trying to do a vlookup (in a cell, not VBA) where the range is determined by a variable stored in another cell. =VLOOKUP(TRIM(A3)&"*",'\\030-DC1\Company$\ADOE 30\re-entry calc\[ReEntry Calculations.xlsx]August 13'!$A$2:$N$150,6,0)That is the lookup without the variable. It works great. I...