MrExcel Publishing
Your One Stop for Excel Tips & Solutions

sheet name as a variable


Posted by mark bazemore on November 01, 2001 5:09 PM

how can you replace the sheet name (tab name) to be a variable in procedures. For example, if you have someone enter a sheet name from an input box, how can you then use that in the VB procedure to select that sheet?...as in sheets("variablename").select


Posted by Qroozn on November 01, 2001 6:53 PM

sheetnamevar = inputbox "please enter sheet name"

this line will set the vaiable "sheetnamevar" to equal what they type