Re: $$Excel-Macros$$ Trace Precedents and Trace Error

2012-08-03 Thread ChilExcel
Mr Sam Mathai Chacko Yes i make last comment ...!! You start a discussion unutil only to draw attention? or just bothering I do not know how you use your time but mine is important Now yes.. I end up here Chilexcel 2012/8/3 Sam Mathai Chacko > :) ending this here. No comme

Re: $$Excel-Macros$$ Trace Precedents and Trace Error

2012-08-03 Thread ChilExcel
t all the text again, there is an effort by someone else, ..thanks for posting the link 3) I clearly understand the question, you are who do not understand rajan did not want links or anything He wanted an answer this reviewer Rajan.. is what matters !!! Chilexcel 2012/8/3 Sam M

Re: $$Excel-Macros$$ Trace Precedents and Trace Error

2012-08-03 Thread ChilExcel
Mr.Sam Mathai Chacko I only answer queries or questions .. if you do not like my answer you propose another solution .. and everyone happy!!! Chilexcel 2012/8/3 Sam Mathai Chacko > Rajan isn't asking about Formula Auditing, which I am sure he is aware of. > His question i

Re: $$Excel-Macros$$ Trace Precedents and Trace Error

2012-08-03 Thread ChilExcel
mulas that nest many functions within them. Chilexcel 2012/8/3 Rajan_Verma > * * > > *Hi Group,* > > * * > > *Is there any difference in Trace Precedents and Trace Error in Excel??* > > * * > > *I don’t need any link to see because I have already Google

Re: $$Excel-Macros$$ Formula Evaluator Shows Text but comes out blank

2012-07-31 Thread ChilExcel
Hi Hilary Lomotey you have Custom Cell Formatting _(* #.##0,00_);_(* (#.##0,00);_(* "-"??_);_(@_) you must change by: _(* #.##0,00_);_(* (#.##0,00);_(* ""??_);_(@_) or another of your choice Chilexcel 2012/7/31 Hilary Lomotey > thanks Dave > > > On Tue,

Re: $$Excel-Macros$$ pls help in conditional formating

2012-07-12 Thread ChilExcel
Hi Mohammed Please see attached file, I think is what you need Chilexcel 2012/7/12 Mohammed Hamed Ajaz > Pls help in conditional formatting > > Example > > Column A Column B name Column C due date columne D last due > date > > 5/7/12 col

Re: $$Excel-Macros$$ Nokia PC Suit API !!

2012-07-08 Thread ChilExcel
Hi Rajan Please see attached link .. (you must translate) http://jose-juan.computer-mind.com/jose-juan/PC-Suite-Connectivity-API.php Chilexcel 2012/7/8 Rajan_Verma > *Hi Group,* > > * * > > *I am searching for PC Suit API, if anybody have any good link where I > can downlo

Re: $$Excel-Macros$$ Re: VBA Code for inserting a row in table in protected sheet

2012-07-06 Thread ChilExcel
B Sharma Please see attached file ,I think is what you need Chilexcel 2012/7/6 ChilExcel > B Sharma > > Please see attached file ,I think is what you need > > > Chilexcel > 2012/7/6 B Sharma > >> Dear Friend Noorain, >> Thanks for your quick reply...

Re: $$Excel-Macros$$ Re: VBA Code for inserting a row in table in protected sheet

2012-07-06 Thread ChilExcel
B Sharma Please see attached file ,I think is what you need Chilexcel 2012/7/6 B Sharma > Dear Friend Noorain, > Thanks for your quick reply... > > I tried this but failed, I was unable to insert rows in the table. > I have attached a file for your reference too. > >

Re: $$Excel-Macros$$ Rajan Verma - Most helpful Member(June​'12)

2012-07-04 Thread ChilExcel
Rajan Congratulations . " Excellent !!!! " Chilexcel 2012/7/4 Ayush Jain : > Hello Everyone, > > Rajan Verma has been selected as 'Most Helpful Member' for the month of > June'2012. This is third time in row. :) > He has posted 149 posts in June

Re: $$Excel-Macros$$ Excel Function_Code

2012-07-04 Thread ChilExcel
Please see attached Add-Ins, I think is what you need open excel add ins and then search functions "user defined" you should always add add ins before using Chilexcel 2012/7/4 dguillett1 : > http://www.add-in-express.com/docs/net-excel-xll-addins.php > > Don Guillet

Re: $$Excel-Macros$$ age month days calculations - Reg

2012-06-22 Thread ChilExcel
Excelent Rajan fine solution Chilexcel 2012/6/22 Suman : > Tkanks Rajan ji > > Regards, > @Suman > Send on the move with Galexy y. > > On Jun 22, 2012 5:58 PM, "Rajan_Verma" wrote: >> >> Here are two vba solution for  that : >&g

Re: $$Excel-Macros$$ Re: Introduce Yourself !!

2012-06-21 Thread ChilExcel
post questions regarding breaking or bypassing any > security measure. 4) Acknowledge the responses you receive, good or bad. 5) > Cross-promotion of, or links to, forums competitive to this forum in > signatures are prohibited. NOTE : Don't ever post personal or confidential > data in a

Re: $$Excel-Macros$$ All Ideas matter : Need your support here.

2012-06-21 Thread ChilExcel
Sorry response to another question Chilexcel 2012/6/21 ChilExcel : > please add in nodule > > Function User() As String > > User = Application.UserName > > End Function > > > Chilexcel > > 2012/6/19 Ayush Jain : >> Dear members, >> >>

Re: $$Excel-Macros$$ Formula for Username in a cell

2012-06-21 Thread ChilExcel
please add in Module Function User() As String User = Application.UserName End Function Chilexcel 2012/6/21 santosh subudhi : > Hi Group, > > Is there a formula to get the user name in a cell the way we get it in > VBA i.e application.username > > My comp doesn't all

Re: $$Excel-Macros$$ All Ideas matter : Need your support here.

2012-06-21 Thread ChilExcel
please add in nodule Function User() As String User = Application.UserName End Function Chilexcel 2012/6/19 Ayush Jain : > Dear members, > > Last year,I started an initiative to collect ideas for improvements in > excel. The initiative received the great response of 165 id

Re: $$Excel-Macros$$ Saving Photos from webpage

2012-06-20 Thread ChilExcel
ation) > > 1) Use concise, accurate thread titles. Poor thread titles, like Please > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will > not get quick attention or may not be answered. > > 2) Don't post a question in the thread of another member. > > 3) Don't post questions regarding breaking or by

Re: $$Excel-Macros$$ Saving Photos from webpage

2012-06-20 Thread ChilExcel
Kiran Please you use: 1 you should use "DownThemAll , add on for firefox ", and download all photos in a folder 2 use chilexel add ins for working with images I send a copy in file posted above ..I not delayed 1 minute to download all images Insertar Imagenes Excel

Re: $$Excel-Macros$$ Re: How to creat digital watch in excel

2012-06-19 Thread ChilExcel
Rajan only commented the work I've done 1 .- move the cursor and enter hours 2 .- hours Clickleft button entry 3 .- add ins stopwatch to determine differences 4 .- formulated to test differences Atte Chilexcel 2012/6/19 Suman > Thanks a lot r

Re: $$Excel-Macros$$ Re: How to creat digital watch in excel

2012-06-19 Thread ChilExcel
Rajan .. I created an add ins to add to the clock its purpose is to determine the timecode breaks talk about its usefulness example Stat End time difference 21:49:23,66 21:49:28,61 00:00:04,95 Chilexcel 2012/6/19 Rajan_Verma

Re: $$Excel-Macros$$ Translating

2012-06-15 Thread ChilExcel
and see http://office.microsoft.com/en-us/support/translate-text-HA010351422.aspx?CTT=5&origin=HA010215829 Chilexcel 2012/6/15 ChilExcel : > please see > > http://office.microsoft.com/en-us/excel-help/where-are-the-translation-options-HA010215829.aspx > > > Chilexc

Re: $$Excel-Macros$$ Translating

2012-06-15 Thread ChilExcel
please see http://office.microsoft.com/en-us/excel-help/where-are-the-translation-options-HA010215829.aspx Chilexcel 2012/6/15 Kiran Kancharla : > > Hi All, > > Request you to please let me know, is there any Inbuilt formula or a Macro > to translate words in Excel. > >

Re: $$Excel-Macros$$ Re: VLOOKUP FROM A RANGE OF SHEETS

2012-06-09 Thread ChilExcel
Please replace previous Please see attached 2012/6/9 ChilExcel : > Please see attached > > 2012/6/9 Vivek : >> >> Dear All, >> Please find enclosed herewith the sample file. >> Thanks >> CA Vivek Jain. >> >> On Friday, 8 June 2012 10:12:45 U

Re: $$Excel-Macros$$ Re: VLOOKUP FROM A RANGE OF SHEETS

2012-06-09 Thread ChilExcel
--- > To post to this group, send email to excel-macros@googlegroups.com > > To unsubscribe, send a blank email to > excel-macros+unsubscr...@googlegroups.com -- Visita ; http://sites.google.com/site/chilexcel/Home Visita ; http://www.youtube.

Re: $$Excel-Macros$$ User Form

2012-05-24 Thread ChilExcel
Good Job Noorain Ansari !!! Chilexcel 2012/5/24 NOORAIN ANSARI : > Dear Deba, > > Please see attached Userform, hope it will help you. > > > -- > Thanks & regards, > Noorain Ansari > www.noorainansari.com > www.excelmacroworld.blogspot.com > > On T

Re: $$Excel-Macros$$ Count & sum color cell, cells have conditional formatting

2012-05-10 Thread ChilExcel
I understand Thank you for your attention and for your time, I have nothing more to add thanks again Chilexcel 2012/5/10 Asa Rossoff : > Hi Chilexcel, > The problem for me comes because if the person requesting help does not look > at themselves as a student in the relationship

Re: $$Excel-Macros$$ Count & sum color cell, cells have conditional formatting

2012-05-10 Thread ChilExcel
Microsoft could pay me Incentive for Sale (jejeje), thx Asa Rossoff Chilexcel 2012/5/10 Asa Rossoff : > Excellent.  I hope I didn't give the impression I was unwilling to help > more.  I am happy to.  But if you need more help, I prefer a specific > question than just giving a com

Re: $$Excel-Macros$$ Count & sum color cell, cells have conditional formatting

2012-05-10 Thread ChilExcel
Hi Asa Rossoff I'm working on a solution, with the help of friends, when finished. I send a result Chilexcel 2012/5/8 Asa Rossoff : > Hi Chil, > Did you try to use those functions, and if so, please post your effort and > what trouble you are having. > > Asa >

Re: $$Excel-Macros$$ Count & sum color cell, cells have conditional formatting

2012-05-08 Thread ChilExcel
Thx Don Guillett ,all this I know, also the links 2012/5/8 dguillett1 : > http://www.xldynamic.com/source/xld.ColourCounter.html > > > > Don Guillett > Microsoft MVP Excel > SalesAid Software > dguille...@gmail.com > -Original Message- From: ChilExcel >

Re: $$Excel-Macros$$ Count & sum color cell, cells have conditional formatting

2012-05-08 Thread ChilExcel
Thx Asa Rossoff ,all this I know, also the links Please Rajan you help !!! ... Chilexcel 2012/5/7 Asa Rossoff : > Chil, > Also see Bob Phillip's method @ > http://www.xldynamic.com/source/xld.CFConditions.html > > > -Original Message- > F

Re: $$Excel-Macros$$ Rajan verma : Most Helpful Member- Apr'2012

2012-05-02 Thread ChilExcel
Congratulations Rajan, a great contribution to the forum Thanks also for your patience and help A hug! Chilexcel from Chile 2012/5/2 Asa Rossoff > Congratulations Rajan, you're very generous with your time and expertise! > > > Asa > > ** ** &

Re: $$Excel-Macros$$ Sum_Hours week

2012-04-27 Thread ChilExcel
Fantastic work , Rajan , I am very grateful was what I needed thank you very much Chilexcel 2012/4/27 Rajan_Verma > HI > > Please try this Code > > *Worksheet Is attached * > > ** ** > > Sub MakeTotal() > > > > Dim rngSum

Re: $$Excel-Macros$$ New Videos excel by Chilexcel

2012-04-20 Thread ChilExcel
Yes...!!! ok 2012/4/20 Rajan_Verma > Hi Bro, > > Can u develop it in English.. > > ** ** > > Rajan. > > ** ** > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] *On Behalf Of *ChilExcel > *Sent:*

Re: $$Excel-Macros$$ Re: Help needed- Converting JPG format file to Excel file via VBA

2012-04-20 Thread ChilExcel
Please see http://www.minipdf.com/ I tried it and it works fine ...jpg at xls Chilexcel 2012/4/20 Shekhar Sharma > Hey Kris, > > Thanks for the quick response, however I am looking for the code for not > just adding the image in excel. > I want to use the the data available in

Re: $$Excel-Macros$$ Help needed- Converting JPG format file to Excel file via VBA

2012-04-20 Thread ChilExcel
Please download ; http://www.minipdf.com/ I tried it and it works fine ... Chilexcel 2012/4/20 Rajan_Verma > I think No, you can’t change. > > ** ** > > You can convert it in PDF and make it readable by One Adobe Tools [name I > don’t remember)

Re: $$Excel-Macros$$ New Videos excel by Chilexcel

2012-04-20 Thread ChilExcel
Rajan In the video is a download link Download here please http://sites.google.com/site/chilexcel/descargas-gratis Regards Chilexcel 2012/4/20 Rajan_Verma > Amazing J it would be great if you can share the code behind it. > > ** ** > > Rajan. > > ** ** >

$$Excel-Macros$$ New Videos excel by Chilexcel

2012-04-20 Thread ChilExcel
Hello all group I share my new videos uploaded to my youtube page Please see this link Chilexcel "PunteroCelda.xla" http://www.youtube.com/watch?v=lZOsLCBSR2w&context=C487180dADvjVQa1PpcFNtKYvBzpQ5HbSYGT3M8FSjxtRwaVrbdaM = All videos http://www.youtube.com/user/timextag41 Chilex

Re: $$Excel-Macros$$ Most helpful Member - March 12- Don Guillett

2012-04-16 Thread ChilExcel
Don I also worked at ING (Chile) Congratulations again Chilexcel 2012/4/16 ChilExcel > Congratulations Don. thanks for your help !!! > > Chilexcel > > > > > 2012/4/15 Somnath Khadilkar > >> Happy Birthday Mr. Don, >> >> >> &g

Re: $$Excel-Macros$$ Most helpful Member - March 12- Don Guillett

2012-04-16 Thread ChilExcel
Congratulations Don. thanks for your help !!! Chilexcel 2012/4/15 Somnath Khadilkar > Happy Birthday Mr. Don, > > > > May God Bless you with Long Life & Peaceful Future > > Somnath Khadilkar > > On 4/14/12, Ayush Jain wrote: > > Dear members, >

Re: $$Excel-Macros$$ Call a Function

2012-04-05 Thread ChilExcel
project name, and then click *OK*. 3. Check the name of the routine. 2012/4/5 ChilExcel > Please attach example, to better understand > > > Chilexcel > > 2012/4/5 Matt > >> Hello, I'm trying to call a public function in one module from another >>

Re: $$Excel-Macros$$ Call a Function

2012-04-05 Thread ChilExcel
Please attach example, to better understand Chilexcel 2012/4/5 Matt > Hello, I'm trying to call a public function in one module from another Sub > procedure in another module and it won't call the the function. I get an > error that says.."sub function not defined

Re: $$Excel-Macros$$ Re: Exact names Find

2012-04-03 Thread ChilExcel
Great job Haseeb !!! thank you chilexcel 2012/4/3 Aamir Shahzad > Haseeb, > > Can you breif your formula if I want to understand the logic. > > Regards, > > Aamir Shahzad > > On Tue, Apr 3, 2012 at 11:44 PM, Haseeb A wrote: > >> Hello Deba, >>

Re: $$Excel-Macros$$ Unprotect - VBA Password

2012-03-30 Thread ChilExcel
Please see http://sites.google.com/site/chilexcel/desbloqueos-y-removepass 2012/3/29 Sam Mathai Chacko > Read forum Rule, and abide by it please. Thank you. > > Regards, > Sam > > > On Thu, Mar 29, 2012 at 8:16 PM, amrahs k wrote: > >> Hi Team, >>

Re: $$Excel-Macros$$ Sum hours weeks

2012-03-15 Thread ChilExcel
Excellent !!! dguillett1 is what I need Thank you very much for your attention Chilexcel 2012/3/15 dguillett1 > You may want to use this to total at the bottom of column E > > Option Explicit > Private Sub CommandButton1_Click() > > Dim tr As Integer > Dim b As R

$$Excel-Macros$$ Sum hours weeks

2012-03-14 Thread ChilExcel
HELP !! please I need help with macro function that sum hours week . attached excel file For this example we use in January, but I need it for all months thx all group -- Visita ; http://sites.google.com/site/chilexcel/Home Visita ; http://www.youtube.com/user/timextag41 -- FORUM RULES

Re: $$Excel-Macros$$ Help on gathering duplicate summing and counting

2012-02-29 Thread ChilExcel
Don Guillett Great contribution, thanks Don Guillett Chilexcel 2012/2/29 Sam Mathai Chacko > Just a guess without testing > > For i = Cells(Rows.Count, "Z").End(xlUp).Row To 2 Step -1 > If Cells(i + 1, "Z") = Cells(i, "Z") Then > > Sam > >

Re: $$Excel-Macros$$ images export in Excel with Image name and Hyperlink

2012-02-24 Thread ChilExcel
see attached link, please http://www.youtube.com/watch?v=B1qUrTKsnGo&context=C383e65fADOEgsToPDskKiaWsIL-0TfBoVlGZ-qD8u Insertar Imagenes Excel (Chilexcel) Directo y desde Hyperlink Chilexcel 2012/2/23 Veeru TOC > > ??...need images save in sheet wise and summary shee

Re: $$Excel-Macros$$ Looking for a Macro which can capture the keystroke timing....

2012-02-22 Thread ChilExcel
check whether this help http://www.rondebruin.nl/key.htm Thanks Chilexcel 2012/2/22, Indrajit $nai : > Hi All, > > Is there any coding is available which can capture the "Keystroke" in a > Excel file, Like whenever I am pressing alt+ctrl+del or locking the system &

Re: $$Excel-Macros$$ Forgot my workbook encrypted password

2012-02-21 Thread ChilExcel
Respecting the rules of the group .. and only One Time and thinking it to good use Please attach a file to remove password see: https://sites.google.com/site/chilexcel/desbloqueos-y-removepass Chilexcel 2012/2/21 ChilExcel > Please attached file to remove passw

Re: $$Excel-Macros$$ Forgot my workbook encrypted password

2012-02-21 Thread ChilExcel
Please attached file to remove password see: https://sites.google.com/site/chilexcel/desbloqueos-y-removepass Chilexcel 2012/2/21 renuka chari > Hi Alll > i am extremely Sorry for that > > On Feb 21, 2:46 pm, "Asa Rossoff" wrote: > > Hi Renukachari, > >

Re: $$Excel-Macros$$ Paid basis help for customer followup using excel& lotus

2012-02-15 Thread ChilExcel
Please send sample template. Clearly indicates that you need Regards, Chilexcel 2012/2/15 Chandra Gupt Kumar > Hi, > > I am follower of the group but not have much knowledge of macro etc...i m > a small businessman & Now, I intend to use help of the intelligent people

Re: $$Excel-Macros$$ Capture Image using VBA

2012-02-09 Thread ChilExcel
working with images !!! please, see ; http://www.youtube.com/watch?v=B1qUrTKsnGo&context=C3697427ADOEgsToPDskKiaWsIL-0TfBoVlGZ-qD8u add ins by chilexcel, Hyperlink to do with "ListFolder" in this group 2012/2/9 Prakash Gusain > You can use any excel file. I just wa

Re: $$Excel-Macros$$ Paste into a Named Range

2011-10-17 Thread ChilExcel
A Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><>&

Re: $$Excel-Macros$$ can I unprotect a sheet

2011-10-07 Thread ChilExcel
hi Dilip straxx password ,,does not work, this discontinued Chilexcel 2011/10/7 ChilExcel > Please see attachment > > > > > > > 2011/10/7 Bé Trần Văn > >> >> >> 2011/10/7 Dilip Pandey >> >>> Hi Anil, >>> >>&

Re: $$Excel-Macros$$ Re: can I unprotect a sheet

2011-10-07 Thread ChilExcel
Please see attached for unlock sheets.. 2011/10/7 ChilExcel > that is what you need??? > > remove password of book? > or unlock leaves? > > > Please attach file > > > chilexcel > > 2011/10/7 GoldenLance > >> To un

Re: $$Excel-Macros$$ can I unprotect a sheet

2011-10-07 Thread ChilExcel
------ > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1

Re: $$Excel-Macros$$ Re: can I unprotect a sheet

2011-10-07 Thread ChilExcel
that is what you need??? remove password of book? or unlock leaves? Please attach file chilexcel 2011/10/7 GoldenLance > To unprotect sheet / workbook structure protection, this should help. > however, this will not open the workbook, if you have protected the > file.

Re: $$Excel-Macros$$ Thanks everyone.

2011-10-05 Thread ChilExcel
Congratulations Ayush Jain chilexcel 2011/10/5 > Dear sir the same problem is faced by all of us who r useing data to export > in excel we can not use 'dr' as filter command as when we go to the cell > which contains numbers it only shows no. Not number with the term &

Re: $$Excel-Macros$$ Help, Alert MsgBox Pair duplicate entry in row

2011-10-05 Thread ChilExcel
ula like this one.** > ** > > ** ** > > Asa > > ** ** > > ** ** > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] *On Behalf Of *ChilExcel > *Sent:* Tuesday, October 04, 2011 6:33 PM > *To:* excel-macros@googlegroups.com

Re: $$Excel-Macros$$ Help, Alert MsgBox Pair duplicate entry in row

2011-10-05 Thread ChilExcel
"Row" & intICounter & vbCrLf Next intICounter End If If strMsg <> "" Then strMsg = "Duplicate Record of " & Target.Value & vbCrLf & vbCrLf & strMsg MsgBox strMsg End If Err: If Err.Number <> 0 Then

Re: $$Excel-Macros$$ Help, Alert MsgBox Pair duplicate entry in row

2011-10-05 Thread ChilExcel
excellent solution, launching the message showing the repeat value thank you very much for your time and attention Rajan Chilexcel 2011/10/5 rajan verma > Try this : > > Private Sub Worksheet_Change(ByVal Target As Range) > On Error GoTo Err: > Dim lngValueAs

Re: $$Excel-Macros$$ Help, Alert MsgBox Pair duplicate entry in row

2011-10-04 Thread ChilExcel
ells(1).Row & ")*(Hoja1!$C$2:$C$57=Hoja1!C" & Target.Cells(1).Row & ")," & lngCount & "))") & vbNewLine Next lngCount MsgBox strMsg, vbOKOnly + vbInformation, "Duplicates" End If End Sub Chilexcel 2011/10/4 Jai > I nee

Re: $$Excel-Macros$$ Help, Alert MsgBox Pair duplicate entry in row

2011-10-04 Thread ChilExcel
licate Record of " & Target.Value & vbCrLf & vbCrLf & > strMsg > MsgBox strMsg > End If > > End Sub > > > On Mon, Oct 3, 2011 at 10:15 PM, ChilExcel wrote: > >> hi >> >> i Need VB lines codes for >> Alert MsgBox Pair duplic

Re: $$Excel-Macros$$ Help, Alert MsgBox Pair duplicate entry in row

2011-10-03 Thread ChilExcel
quot; > & Target.Cells(1).Row & ")*(Hoja1!$C$2:$C$57=Hoja1!C" & Target.Cells(1).Row > & ")," & lngCount & "))") & vbNewLine > Next lngCount > MsgBox strMsg, vbOKOnly + vbInformation, "Duplicates"

Re: $$Excel-Macros$$ Help, Alert MsgBox Pair duplicate entry in row

2011-10-02 Thread ChilExcel
Urgent !! i Need VB lines codes for 2011/10/1 ChilExcel > hi > > i Need VB lines codes for > Alert MsgBox Pair duplicate entry in row > > Column D function account and duplicates alerts (NO Problem!) > Attach File , thank you all > > -- > Visita ; http://sites.

$$Excel-Macros$$ Help, Alert MsgBox Pair duplicate entry in row

2011-10-01 Thread ChilExcel
hi i Need VB lines codes for Alert MsgBox Pair duplicate entry in row Column D function account and duplicates alerts (NO Problem!) Attach File , thank you all -- Visita ; http://sites.google.com/site/chilexcel/Home Visita ; http://www.youtube.com/user/timextag41

Re: $$Excel-Macros$$ values and percentages in stack chart

2011-09-27 Thread ChilExcel
Please attach sample file Chilexcel 2011/9/26 joseph camill > How do I add percentages and values in a normal stack chart. > > -- > > -- > Some important links for excel users: > 1. Follow u

Re: $$Excel-Macros$$ Help to create summary table count unique

2011-09-04 Thread ChilExcel
I have solved my problem Thank www.contextures.com everything I need in a PivotTable without using macros www.contextures.com excellent!! thanks 2011/8/26 ChilExcel > in the example I use: > 1 advanced filter > 2 Pivot table > 3 and formula for count unique > >

Re: $$Excel-Macros$$ Re: Need macro to split the files

2011-08-31 Thread ChilExcel
cks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><>&

Re: $$Excel-Macros$$ Re: Need macro to split the files

2011-08-30 Thread ChilExcel
cros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><>&

Re: $$Excel-Macros$$ Re: Need macro to split the files

2011-08-30 Thread ChilExcel
><><><><><> >> Like our page on facebook , Just follow below link >> http://www.facebook.com/discussexcel >> > > -- > > -- > Some important links for ex

Re: $$Excel-Macros$$ Help to create summary table count unique

2011-08-26 Thread ChilExcel
in the example I use: 1 advanced filter 2 Pivot table 3 and formula for count unique i need macro for all in summary table 2011/8/26 ChilExcel > Thx , I know all of the above > > my problem is to use all operations once > Sum, Count, and Count unique !!! > > all, not separat

Re: $$Excel-Macros$$ Help to create summary table count unique

2011-08-26 Thread ChilExcel
BlackBerry® from Vodafone >> -- >> *From: *NOORAIN ANSARI >> *Sender: *excel-macros@googlegroups.com >> *Date: *Fri, 26 Aug 2011 10:49:39 +0530 >> *To: * >> *ReplyTo: *excel-macros@googlegroups.com >> *Subject: *Re: $$Excel-Macros$$

Re: $$Excel-Macros$$ help table percentage

2011-08-19 Thread ChilExcel
ws.Count, "b").End(xlUp).Row > Range("j4:p" & Cells(Rows.Count, "J").End(xlDown).Row).Delete > Range("J3:P3").AutoFill Destination:=Range("J3:P" & slr) > End Sub > > *From:* ChilExcel > *Sent:* Thursday, August 18, 2011 7:36

$$Excel-Macros$$ help table percentage

2011-08-18 Thread ChilExcel
Hello everyone please, I need vb code to create percentage range or table 2 msgbox ideal 1 input range 2 output range values ​​and ranges are always different I attached an example of my need to automate -- Visita ; http://sites.google.com/site/chilexcel/Home Visita ; http

Re: $$Excel-Macros$$

2011-08-12 Thread ChilExcel
sorry, just an exercise I have no questions all good thx 2011/8/11 ChilExcel > > > -- > Visita ; http://sites.google.com/site/chilexcel/Home > Visita ; http://www.youtube.com/user/timextag41 > > -- > > --

Re: $$Excel-Macros$$ Generate random numbers based on number given in a cell

2011-05-30 Thread ChilExcel
F9 key works for all open workbooks, without exception ... The macro must be enclosed in the book to which you want to work only work if it is enabled Chilexcel 2011/5/29 hanumant shinde > can u pls give some light on this coding. i tried to debug but it jus > have sendkey F9. &

Re: $$Excel-Macros$$ Consolidate data

2011-05-10 Thread ChilExcel
Please see attached file By Chilexcel 2011/5/10 Rajesh K R > Hi Experts > Pls check the attached file and tell me how to consolidate date month wise. > > Regards > > Rajesh Kainikkara > > -- > > ---

Re: $$Excel-Macros$$ go back to the last visited page

2011-05-09 Thread ChilExcel
Please see attached file Chilexcel 2011/5/9 rajan verma > HI, > Please see if it help.. > > > On Sun, May 8, 2011 at 4:01 PM, Rajesh K R wrote: > >> Hi Experts >> Is it possible to create two buttons one for forward & other for >> backward and move t

Re: $$Excel-Macros$$ Outlook 2007 Calendar Meeting Setup to Excel 2007

2011-05-02 Thread ChilExcel
see this link , that's what you need http://office.microsoft.com/en-us/outlook-help/export-calendar-data-to-excel-HP001087241.aspx Chilexcel 2011/4/27 Susan 1 > Hi, > Does anyone know if it is possible to import or export an Outlook calendar > template into Excel 2007. >

Re: $$Excel-Macros$$ Remove Password Protection

2011-04-24 Thread ChilExcel
see this link http://sites.google.com/site/chilexcel/desbloqueos-y-removepass break the password books, Sheets VB proyect 2011/4/22 Prakash Gusain > Hi, > > Can any one provide me any code using which I can break the password > of any excel add in?

Re: $$Excel-Macros$$ Show full screen for a particular workbook only.

2011-04-20 Thread ChilExcel
ww.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegr

Re: $$Excel-Macros$$ Show full screen for a particular workbook only.

2011-04-19 Thread ChilExcel
ldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><&

Re: $$Excel-Macros$$ SEARCH FUNCTION

2011-04-19 Thread ChilExcel
discussexcel >> > > -- > > ------ > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.l

Re: $$Excel-Macros$$ Show full screen for a particular workbook only.

2011-04-19 Thread ChilExcel
lt;><><><><><><><><><> > Like our page on facebook , Just follow below link > http://www.facebook.com/discussexcel > -- Visita ; http://sites.google.com/site/chilexcel/Home Visita ; http://www.youtube.com/user/timextag41 -- --

Re: $$Excel-Macros$$ How to make excel addins

2011-04-06 Thread ChilExcel
ype:* option to change the file type to *Microsoft Excel Add-In (*.xla)*. If not what you need, please attached file to better understand ChilExcel 2011/4/6 Deepak Rawat > Hi Friends, > > I have made some macros for some purpose and i want to use that in my > all the excels. > i go

Re: $$Excel-Macros$$ Help required in merging two attendance sheets

2011-04-03 Thread ChilExcel
cros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><&g

Re: $$Excel-Macros$$ Excel help

2011-04-03 Thread ChilExcel
><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below link > http://www.facebook.com/discussexcel > -- Visita ; http://s

Re: $$Excel-Macros$$ File attachement

2011-03-10 Thread ChilExcel
Delete End If Else Set rng = rng.Offset(-1, 0) rng.Offset(1, 0).EntireRow.Delete End If Set rng = rng.Offset(1, 0) Loop End Sub chilexcel 2011/3/10 ChilExcel > > > you need to do? > > > > Chilexcel > > > > > 2011/3/

Re: $$Excel-Macros$$ File attachement

2011-03-10 Thread ChilExcel
you need to do? Chilexcel 2011/3/10 Cesar Delanoval > I am sending you the sample file that goes my latest post since I was not > able to attach it or upload it on the group website. > I appreciate all your help

Re: $$Excel-Macros$$ Please help on Excel.

2011-03-09 Thread ChilExcel
sorry, use this formula in data validation =CONTAR.SI <http://contar.si/>($C$2:$C$30;C2)=1 2011/3/9 ChilExcel > Hi > > use this formula in data validation > > =CONTAR.SI($C$2:$C$30;C1)=1 > > > > chilexcel > > > Visita ; http://sites.goog

Re: $$Excel-Macros$$ Please help on Excel.

2011-03-09 Thread ChilExcel
Hi use this formula in data validation =CONTAR.SI($C$2:$C$30;C1)=1 chilexcel Visita ; http://sites.google.com/site/chilexcel/Home Visita ; http://www.youtube.com/user/timextag41 2011/3/8 Rabindra Thapa > Dear all, > > > > I have one attach file where I am keeping the ser

Re: $$Excel-Macros$$ help with formating

2011-03-04 Thread ChilExcel
with conditional formatting you just have to change% for conditions 1,2,3 chilexcel 2011/3/4 pawel lupinski > Hi All, > I realy need your help with formating of the cells. see inside. > Thank

Re: $$Excel-Macros$$ help needed

2011-03-03 Thread ChilExcel
I have macros to consolidate or merge Excel worksheets and workbooks if anyone needs them let me know but it is better to know the tools of Excel, then use macros chilexcel 2011/3/3 ChilExcel > Please see attachment and tell me ... > > chilexcel > > > > > 201

Re: $$Excel-Macros$$ help needed

2011-03-03 Thread ChilExcel
if you need separate sheet or day must use "consolidate" on an individual basis sheet or day should not selecting all the sheets chilexcel 2011/3/3 ChilExcel > hi > > you must use "consolidate" > look at this link > > > http://www.techrepubl

Re: $$Excel-Macros$$ Emergency: Vba Code requested for PDF file has to be converted as Word Document.

2011-03-02 Thread ChilExcel
>>>>> To post to this group, send email to excel-macros@googlegroups.com >>>>> >>>>> <><><><><><><><><><><><><><><><><><><><><><>

$$Excel-Macros$$ Fwd: I repeat again, anyone can help me?

2011-02-28 Thread ChilExcel
attached file Thx -- Forwarded message -- From: ChilExcel Date: 2011/2/28 Subject: I repeat again, anyone can help me? To: excel-macros@googlegroups.com I need to extract dynamic table, named worksheet or book name (for each double click) -- Visita ; http

$$Excel-Macros$$ I repeat again, anyone can help me?

2011-02-28 Thread ChilExcel
I need to extract dynamic table, named worksheet or book name (for each double click) -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2

$$Excel-Macros$$ Need named range or named range book Pivot Table

2011-02-25 Thread ChilExcel
on another sheet I send a file -- thx Visita ; http://sites.google.com/site/chilexcel/Home Visita ; http://www.youtube.com/user/timextag41 -- -- Some important links for excel users: 1. Follow us on TWITTER for

Re: $$Excel-Macros$$ Hope so...

2010-12-15 Thread ChilExcel
yes sr see this link http://sites.google.com/site/chilexcel/desbloqueos-y-removepass 2010/12/15 SAJID MEMON > Hi All Experts, > > Can we crack any VBA password like attachment ! > If Yes then please give me tips. > > awaiting your positive respon

  1   2   >