Re: $$Excel-Macros$$ Tricky tricks - 1

Function eval(str As String)     word = Split(str, "+")     For Each wrd In word     add_1 = WorksheetFunction.Sum(WorksheetFunction.Substitute(wrd, "'", ""))     add2 = add2 + add_1     Next     eval = add2      End Function From: xlstime To: excel-macros@goog

Re: $$Excel-Macros$$ date difference problem

thank u deepak its working On Sat, Jul 27, 2013 at 12:09 AM, Deepak Barnwal wrote: > PFA > > Regards > > deepak > > > On Fri, Jul 26, 2013 at 11:28 PM, vba wrote: > >> PFA >> >> Actually years should be 37 & not 36!! >> >> HTH//Cheers >> >> >> On Fri, Jul 26, 2013 at 10:12 AM, Shankar Bheema >>

Re: $$Excel-Macros$$ Help to Calculate Half day leave in Attendance

Thank you so much ur formula is working .. sir On Tuesday, 29 January 2013 22:28:19 UTC+5:30, Excel Beginner wrote: > > Hi Hemanath, > > Use the following formula or more clarity find the > attachment. > > =COUNTIF(*C3:AG3*,"H")*0.5 > > > > > > > >

RE: $$Excel-Macros$$ vba formatting if value match reference cell

Hi, Please find the attachment. Regards, >>Excel Beginner<< From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of ha...@mst.edu Sent: Tuesday, July 30, 2013 11:07 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$

$$Excel-Macros$$ vba formatting if value match reference cell

Basically I want to compare a cell to a reference cell(range A) in the same sheet and highlight that cell for example A B C D Home HomeHotel Hotel Hotel Airport

Re: $$Excel-Macros$$ Re: Prince Kumar - Most Helpful Member Jan'13

please check you group setting -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Plea

Re: $$Excel-Macros$$ Tricky tricks - 1

Good one ..very simple code . Enjoy Team XLS On Tue, Jul 30, 2013 at 5:43 PM, Prafull Jadhav wrote: > Sir , > > Can we do this by using Macro > > Sub prafull() > > For Each x In Range("B2:B10") > x.Value = "=" & x.Value > Next > End Sub > > Regards, > Prafull > > > On

$$Excel-Macros$$ Double click event for different column HELP!!!

Dear Experts, I have attached my file, here different column double clicking and data should paste in different columns, I have done only in one column and other is unable to do. please co-operate me to complete my assignment. Awaiting your positive response Regards Sajid Memon

Re: $$Excel-Macros$$ Copy Data from Reference file to Master file

you may share your current code, maybe we can find whats wrong with it Pada 30/07/2013 18:36, Puttu * menulis: Really i tried my best, but didn't worked out. thus the reason seeking for help On Tue, Jul 30, 2013 at 3:59 PM, De Premor > wrote: Hi Putu, While

Re: $$Excel-Macros$$ Tricky tricks - 1

Sir , Can we do this by using Macro Sub prafull() For Each x In Range("B2:B10") x.Value = "=" & x.Value Next End Sub Regards, Prafull On Tue, Jul 30, 2013 at 12:31 PM, xlstime wrote: > if we have more then thousands of records than? > > . > > Enjoy > Team XLS > > > >

Re: $$Excel-Macros$$ Want Excel Games

Dear Vijay, My system administrator blocked such game sites. that why i asked excel games to mail me. all games's websites are blocked. but by mail, I have no problem. please mail more games, not links. Links are useless for me. and thanx for these games. Regards, Waseem Saifi On Tue, Jul 30,

Re: $$Excel-Macros$$ Copy Data from Reference file to Master file

Really i tried my best, but didn't worked out. thus the reason seeking for help On Tue, Jul 30, 2013 at 3:59 PM, De Premor wrote: > Hi Putu, > > While you're waiting for a groups response, why dont you start writing your > own code, you might want to read more about : > > Select a file usi

Re: $$Excel-Macros$$ How to split Data based on last comm,

Dear Rajkumar, Please find attached file with solution. Regards, Waseem Saifi On Tue, Jul 30, 2013 at 3:48 PM, Raj Kumar wrote: > Dear Group, > > We have lots of records and Segregate the data based on only last comma > and consider the same > > Like, > *Data

Re: $$Excel-Macros$$ Copy Data from Reference file to Master file

Hi Putu, While you're waiting for a groups response, why dont you start writing your own code, you might want to read more about : Select a file using Application.GetOpenFilename Open a workbook using Workbooks.Open Assign a value to variable using Set... = Looping each worksh

$$Excel-Macros$$ How to split Data based on last comm,

Dear Group, We have lots of records and Segregate the data based on only last comma andconsider the same Like, *Data Result Shold be* Raj, Kumar, Bharti Bharti Sadan, Kumar, SinhaSinha Madan, Kuma

Re: $$Excel-Macros$$ Copy Data from Reference file to Master file

please please advise, it's very important for me... On Sat, Jul 27, 2013 at 4:55 PM, Puttu * wrote: > Hi Experts, > > Need a help on copying the data from one workbook (Reference) to another > workbook (master). I know asking too much, appreciate could you please help > me on this coding. >

Re: $$Excel-Macros$$ Re: Prince Kumar - Most Helpful Member Jan'13

Hi Do one thing, check your spam box & if you dont find there also. or else Unsub & Re-Sub. Thanks On Tue, Jul 30, 2013 at 2:33 PM, PrIyAnKa wrote: > Please help me ,i'm not getting emails from group ,i'm still member of the > group > > > On Sat, Feb 9, 2013 at 11:24 AM, PrIyAnKa wrote: > >

Re: $$Excel-Macros$$ Re: Prince Kumar - Most Helpful Member Jan'13

Please help me ,i'm not getting emails from group ,i'm still member of the group On Sat, Feb 9, 2013 at 11:24 AM, PrIyAnKa wrote: > Congratulations Prince ji.. >> > > Regards > Priyanka > >> >> On Saturday, February 2, 2013 11:49:07 AM UTC+5:30, Ayush Jain wrote: >>> >>> >>> Dear members, >

$$Excel-Macros$$ Want Excel Games

Somebody Please give me Excel Games. Regards, Waseem Saifi -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles.

Re: $$Excel-Macros$$ Copy Data from Reference file to Master file

Experts really need your help on this macro.. please please On Sat, Jul 27, 2013 at 4:55 PM, Puttu * wrote: > Hi Experts, > > Need a help on copying the data from one workbook (Reference) to another > workbook (master). I know asking too much, appreciate could you please help > me on this c

$$Excel-Macros$$ Print webpage to pdf file

HI All, Can you please help me out in solving the issue. I have few websites in which i have to enter few values and click on a specific button and once the data is loaded, need to take the print of the webpage in a pdf format with a specific name. we can take any website for doing so which has a

Re: $$Excel-Macros$$ Tricky tricks - 1

if we have more then thousands of records than? . Enjoy Team XLS On Mon, Jul 29, 2013 at 9:41 PM, Secret Shot wrote: > Put "=" sign in cell A2 itself at the bagining of the text... :P > > > On Sun, Jul 28, 2013 at 1:46 PM, De Premor wrote: > >> create defined name i