Try this code.
Sub unprotecsheet()
Dim wb As Workbook
Dim sh As Worksheet
Set wb = ThisWorkbook
For Each sh In wb.Sheets
sh.Unprotect "AAABAABABBAR"
Next
End Sub
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Prabhakar S H
Sent:
Hi,
Another way!!
=SUM((E$1=$B$2:$B$10)*($C2=$A$2:$A$10))
Warm Regards,
Ravi Kumar.
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Anoop K Sharma
Sent: Wednesday, September 18, 2013 10:03 AM
To: excel-macros@googlegroups.com
Subject
Hi Expert,
Any idea how to break the links in chart object in powerpoint through VBA
code.
--
Thanks & regards
Satheeshkumar
--
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.co
Hi Prabhu,
I can help you if you can share data with me...
On Wednesday, September 18, 2013 8:59:41 AM UTC+5:30, prabhupink80 wrote:
>
> Hi Experts,
>
>
> i have historical pattern of last few month daywise daily offered. is
> there possible to calculate the next month overall volume by using ex
Check the Attachment...
On Tue, Sep 17, 2013 at 8:45 PM, ashish koul wrote:
> xy1? what does this mean do you want to count RS with point 1 and so on
>
> Regards
> Ashish
>
>
> On Tue, Sep 17, 2013 at 5:59 PM, Chandra Shekar <
> chandrashekarb@gmail.com> wrote:
>
>> Hello,
>>
>> I need for
Hi Experts,
i have historical pattern of last few month daywise daily offered. is there
possible to calculate the next month overall volume by using excel.
if anyone have this kind of template please share.
Thanks & Regards,
Prabhu R
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do
I created a UserForm. The form has several "frames" (for VB folks, VBA
"frames" are called "groups" in VB for some reason). I created a sub
routine:
Private Sub fraMyFrame_Click()
DoStuff
End Sub
If I click *inside* the frame then the click event is triggered and DoStuff
runs.
In a se
Hi,
I am looking for some attrition calculator spreadsheet.
I am working on creating the attrition calculation which calculates
attrition “Tenure wise, Process Wise, Location Wise, Leaving reasons,
Day/night” etc…
Need your support on that. Any template will help a lot.
Regards,
Sushil
Hi all
I am new to this group so I hope someone can kindly assist..
To say I am a novice in macros is an understatement so please forgive my
ignorance..
I tried to solve this but do not have the knowledge to do so and therefore
appreciate your help...
Currently my Macro should:
1. Tur
Hi Ashish,
Its working perfectly. Thank you very much for all the help :-)
Regards,
Shraddha
On Tue, Sep 17, 2013 at 7:12 PM, ashish koul wrote:
> try this see if it helps
>
>
> Sub replace_tracker()
> Dim i As Long, j As Long
>
>
> For i = 2 To Sheets("Tracker").Range("a65356").End(x
Dear Experts thanks alot
Hi *De Premor / Enrique Martin**
**
*thanks for giving this macro
this would be save my time alot and alot
thanks
On Tuesday, 17 September 2013 01:46:47 UTC+5:30, renuka chari wrote:
>
> Dear experts.
>
>
> please solve my query its very very urgent
>
> macro for requ
Can u share a sample file
On Tue, Sep 17, 2013 at 10:05 PM, Rejeeb Abdulrahiman
wrote:
> Hi Friends,
>
> In Excel 2010, I would like to create a list of name in Sheet 1 and
> residing to that names I need check boxes; If i click any check box the
> name residing to it should go to the list in S
Hi Friends,
In Excel 2010, I would like to create a list of name in Sheet 1 and
residing to that names I need check boxes; If i click any check box the
name residing to it should go to the list in Sheet 2. How is it possible
to create a Excel sheet using the above information.
With Hope And
I dont have any idea about this .
Try this addon Iesplit 2.1
http://www.softpedia.com/get/Internet/Other-Internet-Related/IE-Split.shtml
Regards
Ashish
On Tue, Sep 17, 2013 at 3:40 PM, Abhidha Dixit wrote:
> Hi Ashish
>
> the reqirement is attached as Bing And yahoo is on the same window in
xy1? what does this mean do you want to count RS with point 1 and so on
Regards
Ashish
On Tue, Sep 17, 2013 at 5:59 PM, Chandra Shekar <
chandrashekarb@gmail.com> wrote:
> Hello,
>
> I need formula to count no of points based on condtion please find
> attached file.
>
> Thanks,
>
> Chandra
try this see if it helps
Sub replace_tracker()
Dim i As Long, j As Long
For i = 2 To Sheets("Tracker").Range("a65356").End(xlUp).Row
With Application.WorksheetFunction
If .CountIf(Sheets("Daily Report").Range("a:a"),
Sheets("Tracker").Range("a" & i).Value) = 1 Then
j = .Matc
try
d3 = =LEFT(B3,3)
e3 = =LEFT(RIGHT(B3,LEN(B3)-FIND(",",B3)-1),3)
see if it helps
On Tue, Sep 17, 2013 at 10:22 AM, Prabhu Pinky wrote:
> Hi Experts,
>
> Please find the attached file, please revert with appropriate formula for
> my requirement
>
> Thanks & Regards,
> Prabhu R
>
> --
>
Hello,
I need formula to count no of points based on condtion please find attached
file.
Thanks,
Chandra
--
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
Can u explain the requirement in details with image of screen if possible
Sent on my BlackBerry® from Vodafone
-Original Message-
From: Abhidha Dixit
Sender: excel-macros@googlegroups.com
Date: Tue, 17 Sep 2013 13:10:57
To: excel-macros
Reply-To: excel-macros@googlegroups.com
Subject:
Hey Guys
Does splitting of single window is possible on IE through VB programming ?
Regards
Abhidha
--
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
PLS PROVIDE LINK OF THAT WEBSITE.
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Murali prasad
Sent: Tuesday, September 17, 2013 12:29 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Stock prices data fetching through VBA
im trying to
21 matches
Mail list logo
