refer to worksheet title
Posted: Sat Aug 13, 2011 1:31 am
dear all,
is there a possibility to refer to the title of the active worksheet when naming a series or group automatically?
i would like to automate the creation of groups in a program: however each group should be named like the respective worksheet it is in -
as i have very many worksheets in many workfiles it would be a lot of work to do this manually!
the result should look something like this
group "name of the worksheet" rs*
is there a way to "name of the worksheet" term?
thanks!
is there a possibility to refer to the title of the active worksheet when naming a series or group automatically?
i would like to automate the creation of groups in a program: however each group should be named like the respective worksheet it is in -
as i have very many worksheets in many workfiles it would be a lot of work to do this manually!
the result should look something like this
group "name of the worksheet" rs*
is there a way to "name of the worksheet" term?
thanks!