Hi,
This works great. Thanks for your efforts and help. Though I have a small
need as well.
The code gives the output through message box. Due to this I am unable to
copy the value (i.e) Output.
Also the code is only execute for the input AGREEMENT. THE ADOPTION THE
ADULT OR MARRIED MINOR. What
Good solution Dililp,
The data scenario sure presents the conflict you have mentioned. What
can be done to work around it?
Warm regards,
Anand Kumar
anand...@gmail.com
On Oct 27, 11:26 am, SAJID MANSOOR sajidmansooral...@gmail.com
wrote:
Good!
On Sun, Dec 13, 2009 at 6:01 PM, Dilip Pandey
Hi Everyone,
I am building a series of wizards for handling some internal processes
at my office. We are extracting data from from '3rd party' data
sources into excel worksheets. To further process this data by hand is
slow, so I was asked to write a few macros etc to speed things up. The
issue I
Welcome Ted,
Please feel free to post your queries. Hope we all learn together
Warm regards,
Anand Kumar
On Oct 26, 7:47 pm, Ted suicid...@gmail.com wrote:
Hi, just joined the group to take a look at what I could learn. I'll
be posting any questions I have shortly.
--
Hi,
You can test for a non-contiguous selection with the following line of code:
A = Selection.Areas.Count
Use this in an If statement - eg
If Selection.Areas.Count 1 then msgbox You can't use non-contiguous cells.:
Exit Sub
Hope this helps.
Regards - Dave.
Date: Thu, 28 Oct 2010
hi Ashish
Thanks for ur reply, but i am using windows XP,I coukdn't open the
file u send.let me know what to do.
Regards
Rajesh
On 10/28/10, ashish koul koul.ash...@gmail.com wrote:
check the attachment for custom filter on dates. in case you are using
background colors .
On Wed, Oct 27,
I don't understand
which linguage do you use?
In visual basic as I have proposed is a function you can pass any text and
use its result
regards
r
2010/10/28 amrahs k amrahs...@gmail.com
Hi,
This works great. Thanks for your efforts and help. Though I have a small
need as well.
The
Hi Excel Gurus,
I would like to prepare the consolidated file on daily basis using macro. I am
using excel 2010.
My team is working daily on some excel files(around 25-50 files). All excel
files are save in a particular folder on daily basis with name containing the
date stamp. I would like
Hi,
Forst Select your dat then go to format in the Home Menu(if your using Excel
2007) or format if you are using older versions.In the format menus dialog
box you can select date formats as you like.At the last the is Customs
format. If you select that and specify what ever type of format you
Hi,
You can download an add-in called asUltimate add-in which is available for
Excel @007 and for older versions also(Excel 2000.2003,2005 etc). It
contains a tool called Duplicate remover. There are also mainy other very
useful tool in that add-in which will be very useful to you.But make sure
Hi Rakesh,
You can also change gridline colour or give colours to the cells in which
you want to see your Cursor.To change thecoulour of gridline(if you are
using excel 2007) Go to the Excel ribbon Button then go to the Excel option
Button In that go to that advanced option. In that advanced
try attached file see if it helps .
On Thu, Oct 28, 2010 at 3:46 PM, Hiren Sheth hiren.sh...@viteos.com wrote:
Hi Excel Gurus,
I would like to prepare the consolidated file on daily basis using macro. I
am using excel 2010.
My team is working daily on some excel files(around 25-50
Sub applyfilter()
If ActiveSheet.AutoFilterMode = True Then
ActiveSheet.AutoFilterMode = False
End If
ActiveSheet.Range($A$1:$B$27).AutoFilter Field:=2, Criteria1:= _
=10/31/2010, Operator:=xlAnd, Criteria2:==11/18/2010
End Sub
Sub RemoveFilter()
If ActiveSheet.AutoFilterMode = True
Perfect solution sir.
Thanks a million.
Regards
Hiren
From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] On
Behalf Of ashish koul
Sent: Thursday, October 28, 2010 8:07 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ How to consolidate the data using
Hello!
If you have your distribution 1 to 1000 for exemple.
So, do =*RANDBETWEEN*(1:1000)
Sorry if I posibly understand wrong
Best Regards
André Luiz D´Avila - Auditor
Moore Stephens Audit
2010/10/27 busboy10 andrew.var...@gmail.com
Hi All,
Trying to do some modeling where I would like Excel
15 matches
Mail list logo