Hi
Try this: Enter sheet name in Row A2 to A10
Sub AddSheets()Dim cell As Excel.RangeDim wsWithSheetNames As
Excel.WorksheetDim wbToAddSheetsTo As Excel.Workbook
Set wsWithSheetNames = ActiveSheetSet wbToAddSheetsTo =
ActiveWorkbookFor Each cell In wsWithSheetNames.Range("A2:A10") '
Change ra
I need a macro where if i enter a data in the column of first worksheet i
want those to be the names of another worksheets accordingly.
please kindly help me
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this f