Hi
U can try below code also...
Sub Rename_sheet()
Sheets(2).Activate
ActiveSheet.Name = "Sheet ka name Change hua"
End Sub
On Mon, May 14, 2012 at 11:56 AM, hilary lomotey wrote:
> tnks boss
>
>
> On Mon, May 14, 2012 at 5:44 PM, Seraj Alam wrote:
>
>> Hi
>>
>> You can below code also
>>
tnks boss
On Mon, May 14, 2012 at 5:44 PM, Seraj Alam wrote:
> Hi
>
> You can below code also
>
> Sub change_sheetName()
> Sheets(1).Activate
> ActiveSheet.Name = "New Sheet"
> End Sub
>
>
>
>
> On Mon, May 14, 2012 at 4:42 AM, hilary lomotey wrote:
>
>> working Perfectly. thanks Maries
>>
Hi
You can below code also
Sub change_sheetName()
Sheets(1).Activate
ActiveSheet.Name = "New Sheet"
End Sub
On Mon, May 14, 2012 at 4:42 AM, hilary lomotey wrote:
> working Perfectly. thanks Maries
>
>
> On Mon, May 14, 2012 at 11:35 AM, Maries wrote:
>
>> Hi,
>>
>> It can be VBA T
working Perfectly. thanks Maries
On Mon, May 14, 2012 at 11:35 AM, Maries wrote:
> Hi,
>
> It can be VBA Try below code,
>
> Sub ShNmeChng()
> Dim nme As String
> nme = InputBox("Enter sheet name here...")
> ActiveSheet.Name = nme
> End Sub
>
> Regards,
>
> MARIES.
>
> On Mon, May 14, 2012 a
Hi,
It can be VBA Try below code,
Sub ShNmeChng()
Dim nme As String
nme = InputBox("Enter sheet name here...")
ActiveSheet.Name = nme
End Sub
Regards,
MARIES.
On Mon, May 14, 2012 at 4:27 AM, hilary lomotey wrote:
> EXCELLENT IT WORKED but i guess u cant change the sheet name with a
> fo
EXCELLENT IT WORKED but i guess u cant change the sheet name with a formula
On Mon, May 14, 2012 at 11:23 AM, Maries wrote:
> Try it,
>
> =MID(CELL("filename"),FIND("]",CELL("filename"))+1,LEN(CELL("filename")))
>
>
> On Mon, May 14, 2012 at 4:16 AM, hilary lomotey wrote:
>
>> the name of the c
Try it,
=MID(CELL("filename"),FIND("]",CELL("filename"))+1,LEN(CELL("filename")))
On Mon, May 14, 2012 at 4:16 AM, hilary lomotey wrote:
> the name of the current sheet into one of the cells
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Po
