Thanks to all
Just one question for Knowledge
I run the script by both way
1.By Making true at the end
2.Without making true at end
I could not notice any difference.
So please can any one explain me
What is the purpose of making true at end?
Aging I ma repeating this is just for Knowledge.
Sub DoSomething()
Sheet1.Unprotect Pwd
'Your code goes here
Sheet1.Protect Pwd
End sub
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Pravin
Hi Gurus,
Please help me in this formula
increase the sheet number in formula
=IF(IF(ISNUMBER(SEARCH(C$2,*Sheet1*!$B1)),TRUE,0)=TRUE,TRIM(RIGHT(*
Sheet1*!$B1,LEN(*Sheet1*!$B1)-FIND(:,SUBSTITUTE(*Sheet1*!$B1, ,:,LEN(*
Sheet1*!$B1)-LEN(SUBSTITUTE(*Sheet1*!$B1, ,)),0)
I would like to increase
can u share excel file
On Sat, Oct 20, 2012 at 12:24 PM, Sundarvelan N nsund...@gmail.com wrote:
Hi Gurus,
Please help me in this formula
increase the sheet number in formula
=IF(IF(ISNUMBER(can u share SEARCH(C$2,*Sheet1*
!$B1)),TRUE,0)=TRUE,TRIM(RIGHT(*Sheet1*!$B1,LEN(*Sheet1*
Thanks Sir and If I want to calculate on 6days week format how Can I do it.
rajesh
On Wednesday, October 17, 2012 4:55:33 PM UTC+5:30, Aamir Shahzad wrote:
PFA
Aamir Shahzad
On Wed, Oct 17, 2012 at 3:16 PM, Rajesh Agarwal
raje...@gmail.comjavascript:
wrote:
Dear Sir
I want to put
Thanks Sir and If I want to calculate on 6days week format how Can I do it.
rajesh
On Wednesday, October 17, 2012 6:51:47 PM UTC+5:30, Rajan_Verma wrote:
*Is it you are looking for?*
* *
*=NETWORKDAYS(A2,A2+25,$E$2:$E$17)*
* *
* *
* *
*Regards*
*Rajan verma*
*+91 7838100659
j3 =IF(AND(E3=E2,F3=F2,G3=G2),True,False)
and drag it down
On Sat, Oct 20, 2012 at 1:30 PM, Pravin Gunjal isk1...@gmail.com wrote:
*Hello Friends,*
* *
*I need a formula which can be find out the same record of the above
line, if correct then it says “TURE” otherwise “FALSE” (all the
can u share the file and password of sheet
On Sat, Oct 20, 2012 at 1:36 PM, Pravin Gunjal isk1...@gmail.com wrote:
*Hi Rajan*
*
*
*Pl let me know where it should be given. As I have tried but it's not
working.*
*And my excel sheet name is : Field Emails*
*
*
*Please do the needful.*
You can use NetworkDays.INTL() parameters are same as previous
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of rajeyssh
Sent: 20 October 2012 1:31
To: excel-macros@googlegroups.com
Subject: Re:
Thanks a lot. It works.
Regards.
Daniel
De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De
la part de Rajan_Verma
Envoyé : samedi 20 octobre 2012 06:31
À : excel-macros@googlegroups.com
Objet : RE: $$Excel-Macros$$ Excel 2007 - VBA - Chart format
Try this
Here are a simplest example,
You can use this code to understand the thing about screen updating
True/False
ScreenUpdating is Application Property , so it works on application level,
means once it set to False then it will be false for every procedure until
it is not set to TRUE,
Try
PFA
Aamir Shahzad
On Sat, Oct 20, 2012 at 1:29 PM, Rajan_Verma rajanverma1...@gmail.comwrote:
*You can use NetworkDays.INTL() parameters are same as previous *
* *
* *
*Regards*
*Rajan verma*
*+91 7838100659 [IM-Gtalk]*
* *
*From:* excel-macros@googlegroups.com [mailto:
Dear Experts,
i want to import text data from scanned documents (JPG format) please help
me if there is any solution for it.
Thanks Best Regards
M. Rashid
Email:- *mr.rashidme...@gmail.com*
Cell: 0323-3289198
--
Join official facebook page of this forum @
http://www.onlineocr.net/
Regards,
Kuldeep Singh
On Sat, Oct 20, 2012 at 3:37 PM, rashid memon mr.rashidme...@gmail.comwrote:
Dear Experts,
i want to import text data from scanned documents (JPG format) please help
me if there is any solution for it.
Thanks Best Regards
M. Rashid
Hello all,
I need a macro to send email using excel with the Selected range of data.
Refer the attachment for more details:
1. We have a number of customers.
2. And we have a number of products of each customer.
3. I want to send to a Customer all its Products, Amount Date using the
email
Dear All,
Suppose I have column of data which is linked with column d of another sheet.
Like
'Sheet1!D5
'Sheet1!D6
'Sheet1!D7
'Sheet1!D8
'Sheet1!D9so on.
Now I want the destination column of entire linked column to be changed to e
like
'Sheet1!e5
'Sheet1!e6
'Sheet1!e7
'Sheet1!e8
Hi
Use indirect function.
Rgds//vabs
Sent on my BlackBerry® from Vodafone
-Original Message-
From: chhajersand...@gmail.com
Sender: excel-macros@googlegroups.com
Date: Sat, 20 Oct 2012 11:12:54
To: excel-macros@googlegroups.com
Reply-To: excel-macros@googlegroups.com
Subject:
Hi
Go to this site for help:
www.rondebruin.nl/sendmail.htm
You will get lots of info there.
Rgds//Vabs
Sent on my BlackBerry® from Vodafone
-Original Message-
From: Rahim Sharieff rahim.shari...@gmail.com
Sender: excel-macros@googlegroups.com
Date: Sat, 20 Oct 2012 16:13:51
To:
Hi
Try this type in cell A1
=indirect(''Sheet1!'B1row())
And in B1 type E
Now Drag Down..
Cheerz//Vabs
Sent on my BlackBerry® from Vodafone
-Original Message-
From: chhajersand...@gmail.com
Sender: excel-macros@googlegroups.com
Date: Sat, 20 Oct 2012 11:12:54
To:
Hi
Download this extension and Install.
www.microsoft.com/en-us/download/details.aspx?id=7
Rgds//Vabs
Sent on my BlackBerry® from Vodafone
-Original Message-
From: Constantin Zamfir cos...@euritmicgrup.ro
Sender: excel-macros@googlegroups.com
Date: Fri, 19 Oct 2012 20:58:18
To:
Hi,
All I want to buy good laptop for my personal use, pl experts suggest on it.
Min. Configuration required:
4GB Ram, Intel I5, 1TB HD..
It should be value for money also..
Which company to go for ..
Thanks a lot..
Cheers//Vabs
Sent on my BlackBerry® from Vodafone
--
Join official
Its good.
2012/10/20 v...@vabs.in
Hi,
All I want to buy good laptop for my personal use, pl experts suggest on
it.
Min. Configuration required:
4GB Ram, Intel I5, 1TB HD..
It should be value for money also..
Which company to go for ..
Thanks a lot..
Cheers//Vabs
Sent on my
Hi Emerson
Can you pl suggest name of co. ?
Sent on my BlackBerry® from Vodafone
-Original Message-
From: Emerson Informática ecard...@gmail.com
Sender: excel-macros@googlegroups.com
Date: Sat, 20 Oct 2012 09:28:07
To: excel-macros@googlegroups.com
Reply-To:
Either Dell or Lenovo
Sent on my BlackBerry® from Vodafone
-Original Message-
From: v...@vabs.in
Sender: excel-macros@googlegroups.com
Date: Sat, 20 Oct 2012 12:30:29
To: excel-macros@googlegroups.com
Reply-To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Good Laptop to
Hi,
Thanks Joseph.
Rgds//Vabs
Sent on my BlackBerry® from Vodafone
-Original Message-
From: joseph.cam...@gmail.com
Sender: excel-macros@googlegroups.com
Date: Sat, 20 Oct 2012 14:00:52
To: excel-macros@googlegroups.com
Reply-To: excel-macros@googlegroups.com
Subject: Re:
Add a new blank column before A in both the workbooks and use below formula
in cell a2 and fill it down
IF(B2,B2C2,LEFT(A1,FIND(C1,A1))C2)
then use simple vlookup to get the status
Regards
Ashish
On Sat, Oct 20, 2012 at 6:14 PM, Manish Bankoti
genious.fore...@gmail.comwrote:
Hi,
Reposting - any help on this please?
Regards
On Wednesday, October 17, 2012 10:20:15 PM UTC+4, prkhan56 wrote:
Hello there,
Thanks for the reply
Can you guide me how to setup my data please?
Regards
Rashid Khan
On Tuesday, October 16, 2012 9:31:53 PM UTC+4, Sushil Kumar wrote:
Hi Rashid,
Hi expert
I want ABC in a column. So can u help me on this. In a column ABC from a
to z.
Thanks
Manoj
--
Join official facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES (1120+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor
type this in a1 and drag it right till column Z
=MID(ADDRESS(1,COLUMN(A2)),2,LEN(ADDRESS(1,COLUMN(A2)))-3)
On Sat, Oct 20, 2012 at 10:05 PM, Manoj Kumar kmrmanoj1...@gmail.comwrote:
Hi expert
I want ABC in a column. So can u help me on this. In a column ABC from a
to z.
Thanks
Manoj
hi ,
i have generated chart using macro.
the thing is,i have to extract the chart alone and send it using mail to
other id using excel macro(mail also should be created)
Kindly help .
--
Vignesh .S.R
--
Join official facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM
In each cell put =CHAR(ROW()+64)) If the list doesn't start in row 1
you will need to decrease the 64 accordingly
Regards
David Grugeon
On 21 October 2012 02:35, Manoj Kumar kmrmanoj1...@gmail.com wrote:
Hi expert
I want ABC in a column. So can u help me on this. In a column ABC from a
I wonder if it would speed it up if you set calculation to xlmanual?
Regards
David Grugeon
On 21 October 2012 03:23, Asa Rossoff a...@lovetour.info wrote:
Hi Diamond Dave,
I started out planning to give you a few general thoughts just based on your
email, without having seen the workbook.
Hi David,
True. The worksheet as posted had no formulas, but it is worth trying and
would likely be beneficial if the macro will be used on a sheet with
formulas.
The fast version of the function probably only has 4 lines of VBA that
could trigger calculation(one shifts the values with a
33 matches
Mail list logo