Hi Jitendra.kumarverma,
Find the Attachment. Hope it will help you.
feel free to ask again if it is not clear.
Regard,
Thamu
On Wed, Jan 5, 2011 at 10:27 AM, Raj Mahapatra wrote:
> hi Jitendra,
>
> First, Define the name range of the countries as "Country"
> Second, Define the name range of
hi Jitendra,
First, Define the name range of the countries as "Country"
Second, Define the name range of states as Country Name e.g. For all indian
states give name range "India"
Third, In first column use data validation of country
in Second column use this formulat in Data Validation in List as
Dear Anju,
Hope you are doing well & Happy New Year !!
For your information, The functions return values and not formats. Hence No
custom UDF can change physical characteristic of a cell. If you want to
change the color of cell , Then use conditional formatting.
I hope it answers your question
Can any one answer the below or only simple questions are answered here just
to become MVP
-- Forwarded message --
From: Anju
Date: Mon, Jan 3, 2011 at 12:44 PM
Subject: $$Excel-Macros$$ Custom UDF
To: excel-macros@googlegroups.com
Hi Team,
Can anyone give me a Custom UDF whi
I moved it to a subroutine called Init and called it from Auto_Open
and got the exact same error message
On Jan 4, 12:01 pm, "OpenExcel.com" wrote:
> Dear Excel User,
>
> Move your code to module and then call it in Auto_Open or Workbook_Open.
>
> ___
> Thanks
Hi Friends,
*What is 'Custom Format' ?:* Microsoft Office Excel provides many built-in
number formats, but in some cases they do not meet our needs, we can
customize a built-in number format to create our own.
*Why 'Custom Format' and not 'Conditional Formatting'?:* because to cure
'Common Col
Dear Excel User,
Move your code to module and then call it in Auto_Open or Workbook_Open.
___
Thanks & Regards
Ashish Jain
(Microsoft Certified Application Specialist)
(Microsoft Certified Professional)
http://www.excelitems.com
http://www.openexcel.com
Getting this error when trying to execute the following statement in
Auto_Open macro:
Application.Calculation = xlCalculationAutomatic
We have a group of Excel templates where the Workbook is password
protected, as well as some sheets that are protected. We also
use .xlam file that contains som
I am hoping someone can help me out with a problem that I am having.
I have a macro that I am working on in Excel 2003 right now that takes
multiple fields from a spreadsheet and makes a text string. It was
working great, until I had to add a few fields that were deemed
necessary to have. I have t
Dear group,
I have initiated a series to collect your 'out of the box' ideas and
suggestions on Microsoft Excel. The idea can be new feature, functionality,
bug fixing, suggestion, or any new thing you want to view in excel.
Till now, Only 33 ideas are submitted and 86 votes have supported them
Congrats Dilip
On Tue, Jan 4, 2011 at 7:37 PM, sharad gupta wrote:
> Hi Dilip Sir,
> Congratulations to you . That is good news on new year 2011.
>
> sharad gupta
> On Mon, Jan 3, 2011 at 7:32 PM, Manoj kumar <
> manoj.vishwakarma...@gmail.com> wrote:
>
>> Congrats Dilip...
>>
>>
>> Best Regar
Hi All,
I have a question related to data validation in excel.
Below is the description..
I want to create two dropdown list using the data validation list. one is
for countries and other is for State of the countries.
My question is if i select country from first dropdown thee second dropdown
p
See attachement
On Mon, Jan 3, 2011 at 10:30 PM, Kenil Gala wrote:
> Hi group,
> i want to draw a graph for skewness and kertosis for some random numbers,
> but i am unable to it. could anyone help me out with problem?.i am little
> weak in this.The random nos are:
>944.1 892.3 948.75 94
Dear Sharma,
I have no idea of your requirement but the file seems to be like willing to
know the password predictions algorithms. Or Hacking password techniques.
Please clarify on this or correct me if i failed to understand your file.
Thanks & Regards
Ahmed Bawazir
On Mon, Jan 3, 2011 at 11:14
Hi Dilip Sir,
Congratulations to you . That is good news on new year 2011.
sharad gupta
On Mon, Jan 3, 2011 at 7:32 PM, Manoj kumar
wrote:
> Congrats Dilip...
>
>
> Best Regards,
> Manoj Kumar
>
> On Mon, Jan 3, 2011 at 8:50 AM, ashish koul wrote:
>
>> congrats dilip
>>
>>
>> On Mon, Jan 3,
Thanks u So much Experts.
Thanks,
Chandrabhan Singh
On Tue, Jan 4, 2011 at 3:37 PM, Rohan Young wrote:
> Hi,
>
> Please find the attachment
>
> Thanks & Regards
>
> ROHAN
> 9818247278, 8860567680
>
>
> On Tue, Jan 4, 2011 at 2:10 PM, ashish koul wrote:
>
>> ignore the previous mail check thi
Dear Ashish Ji,
i hv a question, i am looking your attachment where u r using an array
formula and the average col. many of cells is empty where the no. of calls
having value (1 or 2) is it ok? or the calculating method of mine for
average is correct.
please clear me, or suggest me if my working
pl stop this
On Tue, Jan 4, 2011 at 2:07 PM, ashish koul wrote:
> check the attachment see if it helps
>
>
>
> On Tue, Jan 4, 2011 at 11:58 AM, Born to Win wrote:
>
>> Hi Friends,
>>
>> Please help me to Apply sum & Average Formula at the end of Month however
>> when i am taking more than 30 Ar
hi gurumurthy,
you are right. I want to see the description in our macro function as we
see for microsoft functions.
hi Haigreeva,
as per the comments by the gurumurthy, I want to see the description in our
macro function as we see for microsoft functions.
hi Kiran,
i am using Excel 2007 ve
Hi, Dilip
Congratulations for the great success..
Sanjay
On Mon, Jan 3, 2011 at 3:31 PM, Ayush wrote:
Dear Group,
>
>I am very very very very happy to share a good news with you. One of our
>dearest
>group member "Dilip Kumar Pandey" is awarded Microsoft MVP award on 1st
>January
Hi gurumurthy,
i dont think he means what u said. he means lets say we write =sum(A1+A2) in
excel cell you will see some info for sum function which is provided by
microsoft itself.
but if we have developed our own function (lets say ofunct) and we type this
function in any cell like =ofunct()
21 matches
Mail list logo
