I want a Udf or macro to concatenate a range with two special criteria.
First:- in Range it select only visible cells
Second :- remove duplicates.
Kindly don't provide me any website as I have checked numerous of codes but
no code is achieving this combined result.
Regards,
Mandeep Baluja
Learni
)
End If
T.Offset(0, 1) = WorksheetFunction.Trim(k)
Next
Next
End Sub
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Prafull Jadhav
Sent: Tuesday, October 29, 2013 10:12 AM
To: excel-macros@googlegroups.com; excelvbacli...@googlegroups.com
Subject: $$Excel-Macro
)
End If
T.Offset(0, 1) = WorksheetFunction.Trim(k)
Next
Next
End Sub
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Prafull Jadhav
Sent: Tuesday, October 29, 2013 10:12 AM
To: excel-macros@googlegroups.com; excelvbacli...@googlegroups.com
Subject: $$Excel-Macro
)
End If
T.Offset(0, 1) = WorksheetFunction.Trim(k)
Next
Next
End Sub
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Prafull Jadhav
Sent: Tuesday, October 29, 2013 10:12 AM
To: excel-macros@googlegroups.com; excelvbacli...@googlegroups.com
Subject: $$Excel-Macro
Dear All,
Very Good Morning ..and Have a Great Day Ahead!
I got below Function from our group . I have modified it . We can put Space
between word
for example
PrafullJadhav then output is Prafull Jadhav
AjayNareshRane then output will be Ajay Naresh Rane
MY question is Can we create Macro by usin
Hi Expert,
I made a UDF function that pull data form server on the basis given
parameter.
When user put the multiple formula on sheet and when he press for
calculate, it take s more time to download data.
Is there any way to make it fast.
like i send all formula parameter in one shot (using x
Dear Sandeep,
Please change scope Public instead of Private.
else
share your UDF with group.
On Thu, Sep 6, 2012 at 4:14 PM, wrote:
> Dear all,
>
> I have made a UDF (formula) in personal.xls file. Though it is working
> when I am working @ personal file but when ever I am trying to use it in m
Dear all,
I have made a UDF (formula) in personal.xls file. Though it is working when I
am working @ personal file but when ever I am trying to use it in my other
worksheet the formula is not working. Please help.
Sandeep Chhajer.
Sent on my BlackBerry® from Vodafone
--
Join official facebook
Hi Experts,
I have done this using Indirect(), Can you please help with UDF.
I waiting for your valuable reply
Regards,
Amol J
On Sunday, August 19, 2012 2:46:36 PM UTC+5:30, Amol J wrote:
> Hi All,
>
> Please help me with this problem. its related to range reference . When we
> dra
Hi All,
Please help me with this problem. its related to range reference . When we
drag any formula into columns. it adjust cell accordingly and increase the
columns. but what i want is If i drag sum udf into columns it will increase
columns as well as rows
On Saturday, August 18, 2012 9:
Dear Amol,
Please Try it.*
Function Udf_sum(rng As Excel.Range)
Dim cell As Range
For Each cell In rng
If VBA.IsNumeric(cell) And cell.Value <> "" Then
Udf_sum = Udf_sum + cell
End If
Next cell
End Function
*
On Fri, Aug 17, 2012 at 11:32 AM, Amol J wrote:
> Hi experts, I need your help, I tr
Hi experts, I need your help, I tried myself but unfortunatly its not
working.
I need UDF to sum range.
1) first my range will be B4:E4 and
I am going to drag udf into columns to next range will be C5:E5,
Means when I will drag my udf function it will increase in range by
1column and 1 row
Hi experts, I need your help, I tried myself but unfortunatly its not
working.
I need UDF to sum range.
1) first my range will be B4:E4 and
I am going to drag udf into columns to next range will be C5:E5,
Means when I will drag my udf function it will increase in range by
1column and 1 row
With these solution.. check the function name if you are not typing
correctly..
-Original Message-
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Eddie
Sent: Jan/Mon/2012 06:43
To: MS EXCEL AND VBA MACROS
Subject: Re: $$Excel-Macros$$ UDF
I&#
a1:b10
> 3. RefCell is asking for a cell such as b12
> Hope this helps
>
> Don Guillett
> SalesAid Software
> dguille...@gmail.com
>
>
>
> -Original Message-
> From: Eddie
> Sent: Monday, January 09, 2012 6:54 AM
> To: MS EXCEL AND VBA MACROS
> Subj
: Eddie
Sent: Monday, January 09, 2012 6:54 AM
To: MS EXCEL AND VBA MACROS
Subject: $$Excel-Macros$$ UDF
How do I get this UDF to function correctly? I keep getting #name? in
the destination cell.
Thanks in advance.
Ed.
' This User Defined Function can be called to calculate which Dec
How do I get this UDF to function correctly? I keep getting #name? in
the destination cell.
Thanks in advance.
Ed.
' This User Defined Function can be called to calculate which Decile a
single cell
' falls within a larger range of cells
Public Function DECILE_RANK(DataRange, RefCell)
'DECILE_R
Hello to every excel expert
I very very urgently needed a UDF which will enhance the possibilities
of giving criterias in the function DSUM
For Example
Dsum(database,field,criteria)
currently I am able to select like this dsum(A1:J100,C1,M1:R2)
that means only 1 field can be selected and one
y u r asking to send mail personally to u.
On Tue, Aug 16, 2011 at 7:31 PM, Excel VBASQL wrote:
> I can do this email me at excelvba...@gmail.com
>
>
> On Tue, Aug 16, 2011 at 11:02 AM, ICWAI Help wrote:
>
>> Please provide me UDF functino for below requirement
>>
>> example:)
>>
>> if the cell
CWAI Help
Sent: Tuesday, August 16, 2011 4:04 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ UDF Function for conditoin formetting
Please find the attached file and give me the solution :)
if the perticuler cell value is 4 then next 4 coloumn cells in same row shoudl
be highl
17, 2011 2:34 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ UDF Function for conditoin formetting
Please find the attached file and give me the solution :)
if the perticuler cell value is 4 then next 4 coloumn cells in same row
shoudl be highleted .
On Tue, Aug 16, 2011 at
On 8/16/11, Excel VBASQL wrote:
> I can do this email me at excelvba...@gmail.com
>
> On Tue, Aug 16, 2011 at 11:02 AM, ICWAI Help wrote:
>
>> Please provide me UDF functino for below requirement
>>
>> example:)
>>
>> if the cell value is 4 then including active cell next 4 cell in a row
>> should
Sub
> Range(Cells(tr, 2), Cells(tr, Target + 1)) _
> .Borders(xlEdgeBottom).LineStyle = xlContinuous
> End Sub
>
> *From:* ICWAI Help
> *Sent:* Tuesday, August 16, 2011 11:02 AM
> *To:* excel-macros@googlegroups.com
> *Subject:* $$Excel-Macros$$ UDF Function for c
et) Or _
Len(Application.Trim(Target)) < 1 Then Exit Sub
Range(Cells(tr, 2), Cells(tr, Target + 1)) _
.Borders(xlEdgeBottom).LineStyle = xlContinuous
End Sub
From: ICWAI Help
Sent: Tuesday, August 16, 2011 11:02 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ UDF Function for condi
I can do this email me at excelvba...@gmail.com
On Tue, Aug 16, 2011 at 11:02 AM, ICWAI Help wrote:
> Please provide me UDF functino for below requirement
>
> example:)
>
> if the cell value is 4 then including active cell next 4 cell in a row
> should be higleted with color.
> ex
> if
> a1 is 4
Please provide me UDF functino for below requirement
example:)
if the cell value is 4 then including active cell next 4 cell in a row
should be higleted with color.
ex
if
a1 is 4 then a1 ,b1 ,c 1, d 1, f 1 should be higleted.
Thansk,
Rakesh.
--
-
hello people
there is a limitation of UDF(User Defined Function) that they cant
change the value of cell except the one they called in...so i created
a sub...now i want to trigger this sub using UDF,but i cant...sop
please suggest me solution.
Thanks & Regards
Akhilesh Airen
--
I made a User Defined Function that generates a random number from a
cumulative frequency distribution (see below). The function works
properly when the workbook is recalculated when the sheet that
contains the function is active. However, the function returns a #NUM!
if a different sheet is activ
Is it possible for a UDF to automatically list the necessary variables
below the Functions bar?
For example, when using Excel's "LEFT" function the following appears
below the Functions bar while typing the formula: "LEFT(text,
[num_chars])".
If possible please inform of how to accomplish. Thank
29 matches
Mail list logo
