Re: $$Excel-Macros$$ need help to write a macro

2014-05-13 Thread Vaibhav Joshi
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

$$Excel-Macros$$ need help to write a macro

2014-05-13 Thread shashi Krieger
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