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
