Hi Daniel
Wow, works wonderfully well. Very much appreciated.
Regards
Charlie
On Sun, Sep 4, 2011 at 11:54 PM, Daniel dcolarde...@free.fr wrote:
See attached workbook.
** **
HTH
** **
Daniel
** **
*De :* excel-macros@googlegroups.com
If (Range(c32) Range(c33)) Then
On Sep 5, 6:06 am, David Lanne djl99_28...@yahoo.com wrote:
Sub OTX()
'
' OTX Macro
'
'
If (c32 c33) Then
End If
If (c32 = c33) Then
Range(g32:g33).Select
Application.Run OT
End If
End Sub
Doesn't this mean if
Hi Expert,
still waiting for ur solution
On Fri, Sep 2, 2011 at 4:12 PM, Divaker Pandey divake...@gmail.com wrote:
Hi Expert.
Is there any way to write and read cookies through vba.
Thanks in advance.
Divaker
--
- Original message
From:Source One Management Services Pvt.Ltd farhee...@msourceone.com
Date: 5 Sep 11 12:33:34
Subject: mis executive, chennai, CONTRACT 2 HIRE
To:
The sender of this email is registered with Naukri.com as Source One
Management Services Pvt.Ltd Dear Candidate,Hi
Dear MSEXL Learner
Correcting a mistake won't be treated as hurting -: I am fully agree with u
but u can correct a mistake by polite way (Never create and suggest
formula's based on the articles you read in internet or book, understand the
concept how the functions are working and it's concept
I am running into the problem that some VBA code is not processed in
time before a next statement can be executed. For example i want to
put a certain Excel graph into the Windows Clipboard and then echo it
in an image control on a userform. After that comes a 2nd graph in
another image control
You have to write [C32] and [C33] (or Range(“C32”), Range(“C33”)). C32 is
considered a variable name, not a range.
HTH
Daniel
De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De
la part de David Lanne
Envoyé : lundi 5 septembre 2011 07:06
À :
Hi Noorain,
This helped me a lot but there is a single case in the code, how to add many
cases if the select any other country and opt for other check boxes, please
refer to the attachment
Please help
Thanks
Prasad.
On Mon, Sep 5, 2011 at 8:34 AM, NOORAIN ANSARI noorain.ans...@gmail.comwrote:
Hai all gurus.
Good evening. I heard that excel is having Report generation option
for its database. May I have the add-in to build report for my
database ? Hope your kind support for me.
--
--
Some important
Hi All,
I have a spreadsheet that can have up to 5 data column entries per row
asscociated to a date etc. The problem is there is multiple rows and i
really want to move it all into 2 columns and keep the date associated
with the data i am moving as i intend to put these in a graph.
I could do
hi,
what type of report do you need to create, which is your database.. please
provide description about that..
On Mon, Sep 5, 2011 at 4:13 PM, Bheema Shankar shankar.n...@gmail.comwrote:
Hai all gurus.
Good evening. I heard that excel is having Report generation option
for its database.
application.enableevents=false
code block
application.enableevents=true
-Original Message-
From: John Holland
Sent: Monday, September 05, 2011 3:28 AM
To: MS EXCEL AND VBA MACROS
Subject: $$Excel-Macros$$ processor to slow for proper sequential processing
of vba code ?
I am
You could maybe use a macro or a simple vlookup formula
From: Shankar Bheema
Sent: Monday, September 05, 2011 8:13 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Report generation for Excel 2003
I am attaching the VBA project and a sample spreadsheet form. I want build a
Dear Experts,
I would request a macro, which can copy the Sheets(two) from one Master file
to other different Excel Files(12 files).
I would appreciate your help in this matter.
Thanks,
Sridhar BL
--
--
Some
Dear Pankaj,
Please try itand see attached sheet..
*Function Count_text(s As Range)
For i = 1 To Len(s)
If VBA.Asc(Mid(s, i, 1)) 65 And VBA.Asc(Mid(s, i, 1)) 90 Or
VBA.Asc(Mid(s, i, 1)) 96 And VBA.Asc(Mid(s, i, 1)) 123 Then
Count_text = Count_text VBA.Mid(s, i, 1)
End If
Next
Thanks Noorain,
for your Quick Help. but actually my requirement is Formula, is there any
inbuilt formula or combination of inbulilt formulas??
On Mon, Sep 5, 2011 at 9:09 PM, Intelligent But Crazy
secrets...@gmail.comwrote:
Dear Group,
Is there any formula which can give the count of
Dear Sridhar,
Please use below link to solve ur query
http://akoul.blogspot.com/search/label/Merge%20Data%20from%20multiple%20workbooks%20for%20specific%20sheets%20only
Hi Noorain,
Please help
Thanks
Prasad
Sent from BlackBerry® on Airtel
-Original Message-
From: Mr Excellent suryaprasad...@gmail.com
Date: Mon, 5 Sep 2011 17:10:47
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Need a help in Combo and Check Boxes
Hi Noorain,
This
thank you for replying me. But scrolling means not scroll bar. its
the caption text of the label have to move from left to right of the
screen. just like marquee function in HTML
On Sep 5, 7:52 am, NOORAIN ANSARI noorain.ans...@gmail.com wrote:
Dear Bheema,
Please see attached sheet it it
=SUMPRODUCT(LEN(A1)-
LEN(SUBSTITUTE(UPPER(A1),CHAR(ROW(INDIRECT(65:90))),)))
from
http://www.excelfox.com/forum/showthread.php?135-Count-Alpha-In-AlphaNumeric-Text
GL
On Sep 5, 9:09 pm, Intelligent But Crazy secrets...@gmail.com wrote:
Thanks Noorain,
for your Quick Help. but actually my
Hello Everyone,
Rajan Verma has been selected as 'Most Helpful Member' for the month of
August'11
He has posted 152 posts in August 2011 and helped many people through his
expertise. He has been consistent contributor to this excel forum and has
acheived this recognition for second time
Rajan, you make us proud. Thanks for the excellent contribution to
this forum. Your dedication and commitment to help the online
community has been exemplary. Keep up the good work.
Regards,
Sam Mathai Chacko (GL)
On Sep 5, 10:29 pm, Ayush Jain jainayus...@gmail.com wrote:
Hello Everyone,
Congrate rajan babu...
On Mon, Sep 5, 2011 at 10:59 PM, Ayush Jain jainayus...@gmail.com wrote:
Hello Everyone,
Rajan Verma has been selected as 'Most Helpful Member' for the month of
August'11
He has posted 152 posts in August 2011 and helped many people through his
Congratulation Rajan Babu
also Noorain, Venkat, Don Guillett, and other folks
On Mon, Sep 5, 2011 at 10:59 PM, Ayush Jain jainayus...@gmail.com wrote:
Hello Everyone,
Rajan Verma has been selected as 'Most Helpful Member' for the month of
August'11
He has posted 152 posts in August 2011
Great Solution SAM
On Mon, Sep 5, 2011 at 10:48 PM, GoldenLance samde...@gmail.com wrote:
=SUMPRODUCT(LEN(A1)-
LEN(SUBSTITUTE(UPPER(A1),CHAR(ROW(INDIRECT(65:90))),)))
from
http://www.excelfox.com/forum/showthread.php?135-Count-Alpha-In-AlphaNumeric-Text
GL
On Sep 5, 9:09 pm, Intelligent
Hi all,
Can anyone help me on this??
Regards
Prasad
Sent from BlackBerry® on Airtel
-Original Message-
From: Mr Excellent suryaprasad...@gmail.com
Date: Mon, 5 Sep 2011 17:10:47
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Need a help in Combo and Check Boxes
Hi
Chris, doesn't look like anything is wrong with your settings. If A3
wouldn't be a problem, try changing the paper size to A3, from A4
Sam
On Sep 5, 10:24 pm, Chris Boxall ch...@boxall.info wrote:
Apparent corruption with .PageSetup.Zoom
I fear that I have corrupted my installation of Excel
Dear Surya,
Please see attached sheet if it help to u..
-- Forwarded message --
From: suryaprasad...@gmail.com
Date: Mon, Sep 5, 2011 at 11:15 PM
Subject: Fw: $$Excel-Macros$$ Need a help in Combo and Check Boxes
To: excel-macros@googlegroups.com
**Hi all,
Can anyone help me
Hi Noorain,
Thank you for this , one doubt here can we Have a faded or shaded check box
instead if hiding them?
Thanks
Prasad.
On Tue, Sep 6, 2011 at 12:07 AM, NOORAIN ANSARI noorain.ans...@gmail.comwrote:
Dear Surya,
Please see attached sheet if it help to u..
-- Forwarded
Hi team,
I have a form where i have a check box where i need to update a date value
in it, so what i need is a option of calender to enter the value of date in
the given check box.
Please help, as attached.
Thanks
Prasad.
--
CountIFS is a NEW function that does not work in earlier that xl2007. So you
will need a combination of countif (no S) OR Sumproduct
example
=sumproduct((a2:a22=2)*(b222=”b”))
From: Amit Desai (MERU)
Sent: Monday, September 05, 2011 1:52 PM
To: excel-macros@googlegroups.com
Subject: RE:
Dear Surya,
Please see attached sheet...
You can add Date Time Picker Box
Step :
*Tool Box-Right Click-additional Controls-Check Microsoft Date Time
Picker Controls*
--
Thanks regards,
Noorain Ansari
*http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/
Thanks
From: Daniel dcolarde...@free.fr
To: excel-macros@googlegroups.com
Sent: Monday, September 5, 2011 5:39 AM
Subject: RE: $$Excel-Macros$$ Doesn't this mean?
You have to write [C32] and [C33] (or Range(“C32”), Range(“C33”)). C32 is
considered a variable name, not a range.
HTH
Daniel
Thanks
From: NOORAIN ANSARI noorain.ans...@gmail.com
To: excel-macros@googlegroups.com
Sent: Monday, September 5, 2011 3:00 AM
Subject: Re: $$Excel-Macros$$ Re: Doesn't this mean?
Dear David,
Pls try it..
Sub Example()
If Sheet1.Range(C32).Value = Sheet1.Range(C33).Value Then
Thanks
From: lifescholar steve.ja...@lifescholar.net
To: MS EXCEL AND VBA MACROS excel-macros@googlegroups.com
Sent: Monday, September 5, 2011 2:47 AM
Subject: $$Excel-Macros$$ Re: Doesn't this mean?
If (Range(c32) Range(c33)) Then
On Sep 5, 6:06 am, David Lanne djl99_28...@yahoo.com
Congratulations
Rajan Verma , Sunny, Noorain, Don Guillett, and Everyone...
*Best Regards,*
*Venkat *
*Chennai*
*My Linked in profile http://in.linkedin.com/pub/venkatesan-c/21/492/a71*
On Mon, Sep 5, 2011 at 10:59 PM, Ayush Jain jainayus...@gmail.com wrote:
Hello Everyone,
Rajan Verma has
Congratulations BRO u rock :-)
Sent from BlackBerry® on Airtel
-Original Message-
From: Venkat CV venkat1@gmail.com
Sender: excel-macros@googlegroups.com
Date: Tue, 6 Sep 2011 10:43:07
To: excel-macros@googlegroups.com
Reply-To: excel-macros@googlegroups.com
Subject: Re:
37 matches
Mail list logo