$$Excel-Macros$$ Re: Udf

2014-12-10 Thread Mandeep Baluja
Sub CONCATENATE() 'CONCATENATE A RANGE OF CELLS eXCEPT DUPLICATES AND HIDDEN CELLS. Dim NoDupe As New Collection On Error Resume Next Set Rng = Selection

Re: $$Excel-Macros$$ Re: Udf

2014-12-09 Thread Vaibhav Joshi
why dont you share with us.. + *I did not do this for you. God is here working through me for you.* On Wed, Dec 10, 2014 at 12:08 PM, Mandeep Baluja wrote: > MADE FOR MYSELF, NO NEED TO REPLY > :) > > > On Wednesday, December 10, 2014 10:53:31 AM UTC+5:30, Mandeep Baluja wrote: >> >> I want

$$Excel-Macros$$ Re: Udf

2014-12-09 Thread Mandeep Baluja
MADE FOR MYSELF, NO NEED TO REPLY :) On Wednesday, December 10, 2014 10:53:31 AM UTC+5:30, Mandeep Baluja wrote: > > 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 a

$$Excel-Macros$$ Re: UDF convert to Macro

2013-10-28 Thread Prafull Jadhav
Dear All, Thanks to Everybody...It is really working fine... Regards, Prafull Jadhav 9920553518 On Tue, Oct 29, 2013 at 10:11 AM, Prafull Jadhav wrote: > 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 > Spac

$$Excel-Macros$$ Re: UDF to pull data from Remote Server

2013-04-08 Thread Prince
Application.Calculate=xlCalculationManual *'Your code* Application.Calculate=xlCalculationAutomatic regards Prince On Monday, April 8, 2013 6:45:31 PM UTC+5:30, Divaker Pandey wrote: > > Hi Expert, > > > I made a UDF function that pull data form server on the basis given > parameter. > > > When

Re: $$Excel-Macros$$ Re: UDF to sum range

2012-09-12 Thread Vabz
* * >> >> *=SUM(OFFSET($A4,,ROWS($L$3:L3),1,4))* >> >> * * >> >> * * >> >> *Regards* >> >> *Rajan verma* >> >> *+91 7838100659 [IM-Gtalk]* >> >> * * >> >> *From:* excel-...@googlegroups.com [mailto:

Re: $$Excel-Macros$$ Re: UDF to sum range

2012-09-12 Thread Kuldeep Singh
*Vabz > *Sent:* 12 September 2012 9:52 > *To:* excel-macros@googlegroups.com > *Subject:* $$Excel-Macros$$ Re: UDF to sum range > > ** ** > > hi > > ** ** > > Question was really tuff..but not impossible.. > > ** ** > > I could manage t

RE: $$Excel-Macros$$ Re: UDF to sum range

2012-09-12 Thread Rajan_Verma
=SUM(OFFSET($A4,,ROWS($L$3:L3),1,4)) Regards Rajan verma +91 7838100659 [IM-Gtalk] From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Vabz Sent: 12 September 2012 9:52 To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Re: UDF to sum

Re: $$Excel-Macros$$ Re: UDF to sum range

2012-09-12 Thread ashish koul
IN J4 TYPE = SUM(OFFSET(A4,0,ROW(A1),1,4)) On Wed, Sep 12, 2012 at 9:52 PM, Vabz wrote: > hi > > Question was really tuff..but not impossible.. > > I could manage to solve without UDF > > PFA.. Soln is in K column.. > > Cheerz.. > > Rgds//Vabz > > > On Friday, August 17, 2012 11:28:51 AM UTC+5

$$Excel-Macros$$ Re: UDF to sum range

2012-09-12 Thread Vabz
hi Question was really tuff..but not impossible.. I could manage to solve without UDF PFA.. Soln is in K column.. Cheerz.. Rgds//Vabz On Friday, August 17, 2012 11:28:51 AM UTC+5:30, Amol J wrote: > > Hi experts, I need your help, I tried myself but unfortunatly its not > working. > I need

Re: $$Excel-Macros$$ Re: UDF for all worksheets

2012-09-07 Thread Paul Schreiner
__ From: "noorain.ans...@gmail.com" To: excel-macros@googlegroups.com Sent: Thu, September 6, 2012 4:48:03 PM Subject: Re: $$Excel-Macros$$ Re: UDF for all worksheets Excellent description, we salute you Paul all group members are lucky because you, Asa and Don are with us.

Re: $$Excel-Macros$$ Re: UDF for all worksheets

2012-09-06 Thread noorain . ansari
@googlegroups.com Subject: Re: $$Excel-Macros$$ Re: UDF for all worksheets Is your function in a "Standard" module? or a "Sheet" module? Perhaps we need a discussion about "scope". --- First, let&#x

Re: $$Excel-Macros$$ Re: UDF for all worksheets

2012-09-06 Thread Paul Schreiner
-- “Do all the good you can, By all the means you can, In all the ways you can, In all the places you can, At all the times you can, To all the people you can, As long as ever you can.” - John Wesley - From: "chhajersand...@gmail.com" To

Re: $$Excel-Macros$$ Re: UDF for all worksheets

2012-09-06 Thread chhajersandeep
s.com Date: Thu, 6 Sep 2012 04:23:22 To: Reply-To: excel-macros@googlegroups.com Cc: Subject: $$Excel-Macros$$ Re: UDF for all worksheets Hi sandeep, i hope scope of ur function or sub is private, so please make it public. If it does not work then pls share the ur workbook with us. regards P

$$Excel-Macros$$ Re: UDF for all worksheets

2012-09-06 Thread Prince Dubey
Hi sandeep, i hope scope of ur function or sub is private, so please make it public. If it does not work then pls share the ur workbook with us. regards Prince On Thursday, September 6, 2012 4:15:13 PM UTC+5:30, sandeep chhajer wrote: > Dear all, > > I have made a UDF (formula) in personal.

$$Excel-Macros$$ Re: UDF as trigger

2011-01-20 Thread The Frog
Can you post your code for the UDF so we can see what you are trying to do. I have had no issue changing multiple cells / worksheets / workbooks from a single UDF. But maybe we are not talking the same thing. Can you share with us what you are doing? The Frog -- -