IT IS WORKING THANK YOU VERY MUCH FOR YOUR HELP
>
>
>
--
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 forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread titles. Poor
Check this out is this you're looking for !! Regards, Mandeep baluja
Sub GetDetails_of_Sheet()
Dim ws As Worksheet
Dim i As Long: i = 2
On Error Resume Next
Application.ScreenUpdating = False
Application.DisplayAlerts = False
For Each sht In ActiveWorkbook.Sheets
If sht.Name = "Info"