HI,
Please visit this Page to know more about Worksheet Events..
Regards
Rajan
On Sat, Oct 1, 2011 at 10:53 AM, Mr excel excelkeec...@gmail.com wrote:
HI group,
This is a Great amazing group in learning excel vba..
*Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel
Select cell or column then right click format cell ...then in
number tab go to date and select date format then ok
On Fri, Sep 30, 2011 at 11:03 AM, Sanjib Chatterjee
chatterjee.kolk...@gmail.com wrote:
Dear
I like to put the date format in Excel as dd/mm/, and
Hi, Anil
I think u want to keep in ur file that data also which comes 2 or 3 time but
after removing 2nd or 3rd data which is repeating in ur file if i'm ri8.
Then u sud chose A to z in example data then simply write in 2nd column
=A2=A3 then drag them n it will return True of False.
False value
Hey Rajan Babu,
which page?
On Sat, Oct 1, 2011 at 11:52 AM, rajan verma rajanverma1...@gmail.comwrote:
HI,
Please visit this Page to know more about Worksheet Events..
Regards
Rajan
On Sat, Oct 1, 2011 at 10:53 AM, Mr excel excelkeec...@gmail.com wrote:
HI group,
This is a Great
Please VIsit this Page..
http://www.cpearson.com/excel/Events.aspx
On Sat, Oct 1, 2011 at 12:09 PM, XLS S xlst...@gmail.com wrote:
Hey Rajan Babu,
which page?
On Sat, Oct 1, 2011 at 11:52 AM, rajan verma rajanverma1...@gmail.comwrote:
HI,
Please visit this Page to know more about
Hi,
if you dont want to use Function then Replace the Space.
On Fri, Sep 30, 2011 at 6:42 PM, dguillett1 dguille...@gmail.com wrote:
=SUBSTITUTE(F9, ,)
*From:* big smile bigsmile...@gmail.com
*Sent:* Friday, September 30, 2011 6:54 AM
*To:* EXCEL MACRO GROUP
On Sat, Oct 1, 2011 at 1:23 PM, Sourabh Salgotra rhtdmja...@gmail.comwrote:
thanks for help
but in this sheet all the data returned from the selected sheet searching
not working.
i want 2 solutions
1 choose sheet
2 search data (which is in c3 cols) if u type singh in c3 then result
not working
On Sat, Oct 1, 2011 at 10:40 AM, Sam Mathai Chacko samde...@gmail.comwrote:
USE
Thanks rajan babu, for that link.Can anybody quote some more examples in
detail.I just got a little understanding of the function with arguments.But
to enhance my knowledge i would like to study more examples...Pls provide me
with any other examples.
On Sat, Oct 1, 2011 at 12:18 PM, rajan
Hello All,
Hope you all are doing well. I'm here as usual, need your assistance. I'v
text data which have percentage numbers (50% or 60%), I need to extract
minimum percentage number. Kindly help me to sort out this problem.
Text is : minimum qualification pcm with 50% or MCA 60%
Result should
Hi
ur %ages are in ascending order in a cell try this
formula IFERROR(MID(A2,FIND(%,A2)-2,3),)
On Sat, Oct 1, 2011 at 3:08 PM, karan 1237 karan1...@gmail.com wrote:
Hello All,
Hope you all are doing well. I'm here as usual, need your assistance. I'v
text data which have percentage
This is easy enough to do with a macro. However, please consider leaving all
in one file and simply use
datafilterautofilter.
-Original Message-
From: Chidurala, Shrinivas
Sent: Saturday, October 01, 2011 6:04 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Splitting of
I solved it with a combination of VLookup to get the date that is X
days (X is the number of days of play that I want to average) prior to
the current date (VLookup by default picks the value in the data that
is less than the specific number/date if no match is found, if I did
not play on a
I am running a multivariate mixing model to estimate the relative
contributions of the suspended sediment source areas to a particular
sediment sink on the basis of measured geochemical properties of the sink
and the potential sources. For each property, a linear equation is
constructed
Well, I haven't used error handler in the first post, but if you use one of
the formulas from my second post, you will not get that #NUM error. Check
the attached file in my previous post.
Sam
On Sat, Oct 1, 2011 at 10:12 PM, Sourabh Salgotra rhtdmja...@gmail.comwrote:
VERY VERY THANKS SIR FOR
I HAVE CHECKED ITS WORKING BUT PROBLEM IS THAT THIS FORMULA IS ON MY TIPS
. SO THAT'S WHY I WANT ERROR HANDLER ON THIS
On Sat, Oct 1, 2011 at 10:18 PM, Sam Mathai Chacko samde...@gmail.comwrote:
Well, I haven't used error handler in the first post, but if you use one of
the formulas from my
Shorter one...
Hi Shrinivas
Try :
Sub Mtest()
Dim Rng As Range
Dim ws As Worksheet
Dim shname As String
Dim i As Integer
Dim shn As Long
Dim mx As Variant
Dim x As Integer
Dim LR As Long
Dim sPath As String, sFileName As String
On Error Resume Next
Application.DisplayAlerts = False
Sheets(Temp).Delete
very very thanks sir for helping me.
On 10/1/11, Sam Mathai Chacko samde...@gmail.com wrote:
Shorter one...
Here is one I like to use for setting variables (Options) in a file
that is used by other Macros.
Using the Macro below; I can toggle between True and False on the
Options and Colors for specific cells.
Available Options
Star Font Size =16
Label
Hip Hip Hurry.. For sure you deserve that NOORAIN u rock dear ...keep
rocking way to go in this group
Thanks
Surya
Sent from BlackBerry® on Airtel
-Original Message-
From: Ayush Jain jainayus...@gmail.com
Sender: excel-macros@googlegroups.com
Date: Sun, 2 Oct 2011 00:43:24
To:
hi
i Need VB lines codes for
Alert MsgBox Pair duplicate entry in row
Column D function account and duplicates alerts (NO Problem!)
Attach File , thank you all
--
Visita ; http://sites.google.com/site/chilexcel/Home
Visita ; http://www.youtube.com/user/timextag41
--
Fabulous work Noorain. You make a difference, and all of us in the
forum appreciate your contribution. Carry on the excellent work.
Sam Mathai Chacko (GL)
On 10/2/11, suryaprasad...@gmail.com suryaprasad...@gmail.com wrote:
Hip Hip Hurry.. For sure you deserve that NOORAIN u rock dear
Hi Noorain,
Congrats
*Best Regards,*
*Venkat *
*Chennai*
*My Linked in profile http://in.linkedin.com/pub/venkatesan-c/21/492/a71*
On Sun, Oct 2, 2011 at 12:43 AM, Ayush Jain jainayus...@gmail.com wrote:
Hello Everyone,
Noorain Ansari has been selected as 'Most Helpful Member' for the
Hi Noorain
Excellent work Noorain.
Regards
Nikhil
On Sun, Oct 2, 2011 at 12:43 AM, Ayush Jain jainayus...@gmail.com wrote:
Hello Everyone,
Noorain Ansari has been selected as 'Most Helpful Member' for the month of
Sept'11
He has posted 140 posts in sept 2011 and helped many people
Hi Noor,
Congratulation
Thanks
On Sun, Oct 2, 2011 at 10:17 AM, Nikhil Shah nikhil201...@gmail.com wrote:
Hi Noorain
Excellent work Noorain.
Regards
Nikhil
On Sun, Oct 2, 2011 at 12:43 AM, Ayush Jain jainayus...@gmail.comwrote:
Hello Everyone,
Noorain Ansari has been selected as
Hello everyone,
I have recognised the achievement on discussexcel.com as well.
Here is the
linkhttp://www.discussexcel.com/google-group/most-helpful-member/most-helpful-member-of-the-month/noorainansari-sept11
Regards
Ayush Jain
On Sun, Oct 2, 2011 at 12:43 AM, Ayush Jain
Hi suman,
I have a address software in which data enterd by other opprters and I think
some data is double so i want to export data from there in excel short out
double data than i will remove that data from software. so i wanted to
printout that double address.
Anil
--
28 matches
Mail list logo