$$Excel-Macros$$ Re: Can I get the day of the week (e.g. Friday) from the date already encoded in a string?

2012-06-26 Thread Lalit_Mohan
Hi, Try this. Evaluate("=Text(Day(Sheets("Sheet1").Cells(count, BarDate).value), """")") Regards, Lalit Mohan On Wednesday, 27 June 2012 10:13:06 UTC+5:30, tangledweb wrote: > I believe this is the equivalent of your second new solution? > Evaluate("=Text(Day(Sheets(RawData).Cells(cou

Re: $$Excel-Macros$$ Re: Can I get the day of the week (e.g. Friday) from the date already encoded in a string?

2012-06-26 Thread NOORAIN ANSARI
I think, Lalit's Solution is nice.. You can also use.. =CHOOSE(WEEKDAY(A1),"Sunday","Monday","Tuesday","Wednesday","Thursday","Friday","Saturday") or =LOOKUP(WEEKDAY(A1),{1,2,3,4,5,6,7},{"Sun","Mon","Tue","Wed","Thu","Fri","Sat"}) or in VBA =Format(A1,"") -- Thanks & regards, Noorain An

$$Excel-Macros$$ Re: Can I get the day of the week (e.g. Friday) from the date already encoded in a string?

2012-06-26 Thread tangledweb
I believe this is the equivalent of your second new solution? Evaluate("=Text(Day(Sheets(RawData).Cells(count, BarDate).Text), """")") I tried it with and without the .text part. Both cases returned error 2015 though I have a 4 digit year and the form is month/day/year which is supp

$$Excel-Macros$$ Re: Can I get the day of the week (e.g. Friday) from the date already encoded in a string?

2012-06-26 Thread Lalit_Mohan
Hi, You can use it as below also Evaluate("=TEXT(DAY(" & arr(i) & "),"""")") where arr is array and i is the index of the array or Evaluate("=TEXT(DAY("6/26/2012"),"""")") Regards, Lalit Mohan On Wednesday, 27 June 2012 10:00:29 UTC+5:30, Lalit_Mohan wrote: > Hi, >

$$Excel-Macros$$ Re: Can I get the day of the week (e.g. Friday) from the date already encoded in a string?

2012-06-26 Thread Lalit_Mohan
Hi, You can try this Evaluate("=TEXT(DAY(A1),"""")") Hope it helps you Regards, Lalit Mohan On Wednesday, 27 June 2012 09:45:46 UTC+5:30, tangledweb wrote: > This seems to be designed to work directly in excel instead of a VB > program. I tried to use it without the = but it said th

$$Excel-Macros$$ Re: Can I get the day of the week (e.g. Friday) from the date already encoded in a string?

2012-06-26 Thread tangledweb
This seems to be designed to work directly in excel instead of a VB program. I tried to use it without the = but it said the function TEXT was not defined. I need a method that works in a VB program with the value 6/26/2012 stored in the array previously listed. On Tuesday, June 26, 2012 9:01:

$$Excel-Macros$$ Re: Run Macro at OPEN of an Excel file

2012-06-26 Thread Lalit_Mohan
Hi Prince, I think both the solution given by you are same. Regards, Lalit Mohan On Wednesday, 27 June 2012 08:43:37 UTC+5:30, Prince Dubey wrote: > > Hi Mitr, > > Private Sub Workbook_Open() > > 'Write your code here in workbook > > End Sub > > regards > Prince dubey > > > > > On Mon

$$Excel-Macros$$ Re: Can I get the day of the week (e.g. Friday) from the date already encoded in a string?

2012-06-26 Thread Lalit_Mohan
Hi, You can try this =TEXT(DAY(A1),"") Hope it helps you Regards, Lalit Mohan On Wednesday, 27 June 2012 09:17:02 UTC+5:30, tangledweb wrote: > If I already have Sheets(RawData).Cells(count, BarDate).Text having a > value like 6/26/2012 is there a way to get the day of the week as a nu

$$Excel-Macros$$ Can I get the day of the week (e.g. Friday) from the date already encoded in a string?

2012-06-26 Thread tangledweb
If I already have Sheets(RawData).Cells(count, BarDate).Text having a value like 6/26/2012 is there a way to get the day of the week as a number or string for that date that does not require splitting it into its parts and feeding them to some function? If the latter the .net examples I found f

$$Excel-Macros$$ Re: Run Macro at OPEN of an Excel file

2012-06-26 Thread Prince Dubey
Hi Mitr, Private Sub Workbook_Open() 'Write your code here in workbook End Sub regards Prince dubey On Monday, 25 June 2012 13:26:16 UTC+5:30, Mitr wrote: > Hi Experts > > Pls help me with a way, so that a Macro runs whenever I open a particular > excel file. (Macro is in that excel f

$$Excel-Macros$$ Re: Delete Blank Cells.xlsx

2012-06-26 Thread Prince Dubey
Hi Vishwa, Try This Public Sub DeleteWeekends() Dim rng As Range Dim rngData As Range With ThisWorkbook.Worksheets("Sheet1") Set rngData = .Range("A1:A" & .Range("A" & .Rows.Count).End(xlUp).Row) For Each rng In rngData If Applicat

$$Excel-Macros$$ Re: Delete Blank Cells.xlsx

2012-06-26 Thread Prince Dubey
Hi Vishwa, Please try this i hope this will do your work Public Sub DeleteWeekends() Dim rng As Range Dim rngData As Range With ThisWorkbook.Worksheets("Sheet1") Set rngData = .Range("A1:A" & .Range("A" & .Rows.Count).End(xlUp).Row) For Each rng

$$Excel-Macros$$ Re: Delete Blank Cells.xlsx

2012-06-26 Thread Lalit_Mohan
Hi Vishwa, I forgot to mention in my last post, use this code in existing file in which weekend date deletion code already exist. just apply the blank row deletion procedure and use it as i show you. Regards, Lalit Mohan On Wednesday, 27 June 2012 00:46:00 UTC+5:30, Viswanathan Yoganathan

$$Excel-Macros$$ Re: extract list of values based on criteria using formula

2012-06-26 Thread Lalit_Mohan
Dear Hilary Try this in column O4 =IF(LARGE(($L$3:$L$21>=IF($K$23 = "",$L$23,$K$23))*(IF($K$23="",TRUE,$L$3:$L$21 <=$L$23))*($L$3:$L$21),ROW($A1)) = 0, "", LARGE(($L$3:$L$21>=IF($K$23 = "",$L$23,$K$23))*(IF($K$23="",TRUE,$L$3:$L$21 <=$L$23))*($L$3:$L$21),ROW($A1))) it's an array formula

$$Excel-Macros$$ Re: extract list of values based on criteria using formula

2012-06-26 Thread Rajan_Verma
Hi HIlary, In L25 = =INDEX(D1:D22,LARGE(--(D3:D22>=K23)*--(D3:D22<=L23)*ROW(D3:D22),ROW(INDIRECT("1:"&SUM(--(D3:D22>=K23)*--(D3:D22<=L23),1) with CSE in K25 =INDEX($C$3:$C$22,SMALL(IF($D$3:$D$22=L25,ROW($C$3:$C$22),""),COUNTIF($L$25:L25,L25))-2) with CSE HTH On Wednesday, 27 Ju

$$Excel-Macros$$ Re: Delete Blank Cells.xlsx

2012-06-26 Thread Lalit_Mohan
Hi Vishwa, Sub DeleteBlank() On Error Resume Next ActiveSheet.UsedRange.SpecialCells(xlCellTypeBlanks).EntireRow.Delete On Error GoTo 0: On Error GoTo -1: Err.Clear End Sub Above is the function need to call in the button click event in sheet1 as shown below. Private Sub CommandBut

RE: $$Excel-Macros$$ Re: Delete Blank Cells.xlsx

2012-06-26 Thread Viswanathan Yoganathan
Hi, I need the date should be like how I arranged in the column B. Thanks, Vishwa From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Vish Sent: Wednesday, June 27, 2012 1:19 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Re: Delete Blank

Re: $$Excel-Macros$$ Re: Delete Blank Cells.xlsx

2012-06-26 Thread Vish
Hi Vishwa, Hope this helps. Please let me know. Thanks, Vish -- -- FORUM RULES (986+ members already BANNED for violation) 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 atte

RE: $$Excel-Macros$$ Re: Delete Blank Cells.xlsx

2012-06-26 Thread Viswanathan Yoganathan
Saturday and Sunday From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Vish Sent: Wednesday, June 27, 2012 1:00 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Re: Delete Blank Cells.xlsx Hi Vishwa, By Weekends you mean Saturday and Sunday or

$$Excel-Macros$$ Re: Delete Blank Cells.xlsx

2012-06-26 Thread Vish
Hi Vishwa, By Weekends you mean Saturday and Sunday or Only Sunday? Thanks, Vish -- -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will

$$Excel-Macros$$ Delete Blank Cells.xlsx

2012-06-26 Thread Viswanathan Yoganathan
Hi all, In the attached excel, I want to delete the week ends whereas at the same time the position of the month should not move. It means the Feb month should start from A34, March month should start from A64. Please advise using VBA macro. Thanks, Vishwa "CONFIDENTIALITY NOTICE: This messag

$$Excel-Macros$$ Re: Run Macro at OPEN of an Excel file

2012-06-26 Thread Vish
Hi, You can put the below function any where in any of your module. It will work same as Workbook_Open() Event. Sub Auto_Open() End Sub For more detail read this: http://www.learnexcelmacro.com/2011/12/auto-open-macro-auto-run-macro/ On Monday, June 25, 2012 1:26:16 PM UTC+5:30, Mitr wrot

$$Excel-Macros$$ extract list of values based on criteria using formula

2012-06-26 Thread hilary lomotey
Hello Again i tried extracting a unique list based on criteria such that if i choose a criteria such as list between 5000 to 1, i want to see that list alone and if i choose a list between 10001 to 4 i want to see that list alone, i am struggling with the condition that create the array, k

$$Excel-Macros$$ Re: For Each loop

2012-06-26 Thread Richard
Thank you both. I'll test it On Tuesday, June 26, 2012 8:23:36 AM UTC-7, Richard wrote: > This one always confuses me, but it is usually simple, so I would > appreciate any help. > > I want to loop through all the rows with data in my worksheet and if the > value in a certain cell is equal

RE: $$Excel-Macros$$ For Each loop

2012-06-26 Thread Rajan_Verma
Revised with Error Handling : Sub Mtest() Dim rngRange As Range Dim rngBlanks As Range Dim WksSheet As Worksheet Dim ValtoReplace Set WksSheet = ActiveSheet WksSheet.Unprotect Set rngRange = Range("rngRange").CurrentRegion On Error R

Re: $$Excel-Macros$$ RETRIEVE UNIQUE LIST IF THERE IS A TIE

2012-06-26 Thread hilary lomotey
Thanks Noorain its working Perfectly. thanks Raj On Tue, Jun 26, 2012 at 5:23 PM, NOORAIN ANSARI wrote: > Hi Hilary, > > See attached sheet, Hope it will help to you > Change in formula As per your need > > On Tue, Jun 26, 2012 at 10:39 PM, hilary lomotey > wrote: > > Hello Guys > > > > Attach

Re: $$Excel-Macros$$ RETRIEVE UNIQUE LIST IF THERE IS A TIE

2012-06-26 Thread NOORAIN ANSARI
Hi Hilary, See attached sheet, Hope it will help to you Change in formula As per your need On Tue, Jun 26, 2012 at 10:39 PM, hilary lomotey wrote: > Hello Guys > > Attached is a list of data, i want to be able to retrieve each unique list > based on the ranking, with what i have tried if there i

RE: $$Excel-Macros$$ RETRIEVE UNIQUE LIST IF THERE IS A TIE

2012-06-26 Thread Rajan_Verma
Hi Hilary, Can you please explain more. What do you mean by unique list. I did not found anything duplicate in your sheet J Regards Rajan verma +91 7838100659 [IM-Gtalk] From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of hilary lomotey Sent: 26 Jun

$$Excel-Macros$$ RETRIEVE UNIQUE LIST IF THERE IS A TIE

2012-06-26 Thread hilary lomotey
Hello Guys Attached is a list of data, i want to be able to retrieve each unique list based on the ranking, with what i have tried if there is a tie, it always picks there first data, kindly provide a formula to retrieve each unique list based on the ranking. thanks -- -- FORUM RULES (986+ memb

Re: $$Excel-Macros$$ For Each loop

2012-06-26 Thread Paul Schreiner
The problem with that approach is that you're assuming that the cells in the "UsedRange" that do not have an "X" in them have some other value. If, for example, all of column "A" is blank,  and the user places an "X" in column "A" for each row in which he wants to unlock specific cells in that ro

Re: $$Excel-Macros$$ For Each loop

2012-06-26 Thread Richard
Thanks for your reply, but I guess I wasn't clear -- condition a ===if the value of cell x3=5 then I want cells y3 through ax3 to be unprotected, otherwise I want them to be protected. condition b ===if the value of cell x3<>5 then the reverse happens and I would to do it for each row with data

Re: $$Excel-Macros$$ VBA editor auto-deletes spaces at the ends of lines

2012-06-26 Thread NOORAIN ANSARI
Nice PDF Rajan, Thanks for Sharing On Tue, Jun 26, 2012 at 8:52 PM, Rajan_Verma wrote: > > I found these links useful to learn vsto > > http://media.wiley.com/product_data/excerpt/73/04700464/0470046473.pdf > http://pdfs-free.com/vsto-pdf.html > > > > Regards > Rajan verma > +91 7838100659 [IM-Gt

RE: $$Excel-Macros$$ For Each loop

2012-06-26 Thread Rajan_Verma
No need to Loop UsedRange.Replace "X","" Set rng=UsedRange.SpecialCells(xlcelltypeblanks) Rng.value="X" Rng.entireColumn.Locked=True/False (whatever your want) Regards Rajan verma +91 7838100659 [IM-Gtalk] From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com

$$Excel-Macros$$ For Each loop

2012-06-26 Thread Richard
This one always confuses me, but it is usually simple, so I would appreciate any help. I want to loop through all the rows with data in my worksheet and if the value in a certain cell is equal to x then I want to unprotect selected columns in that row, otherwise I want to reset the protection

RE: $$Excel-Macros$$ VBA editor auto-deletes spaces at the ends of lines

2012-06-26 Thread Rajan_Verma
I found these links useful to learn vsto http://media.wiley.com/product_data/excerpt/73/04700464/0470046473.pdf http://pdfs-free.com/vsto-pdf.html Regards Rajan verma +91 7838100659 [IM-Gtalk] -Original Message- From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.co

Re: $$Excel-Macros$$ VBA editor auto-deletes spaces at the ends of lines

2012-06-26 Thread ╰» ℓαℓιт мσαнη
Thanks Rajan for your great help. Regards, Lalit Mohan On Tue, Jun 26, 2012 at 8:47 PM, Rajan_Verma wrote: > > Download this book . > > http://freedownload.is/pdf/the-vsto-programming-model-3812060.html > > > Regards > Rajan verma > +91 7838100659 [IM-Gtalk] > > > -Original Message- > F

RE: $$Excel-Macros$$ VBA editor auto-deletes spaces at the ends of lines

2012-06-26 Thread Rajan_Verma
Download this book . http://freedownload.is/pdf/the-vsto-programming-model-3812060.html Regards Rajan verma +91 7838100659 [IM-Gtalk] -Original Message- From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of ?» lal?? ?sa?? Sent: 26 June 2012 8

Re: $$Excel-Macros$$ VBA editor auto-deletes spaces at the ends of lines

2012-06-26 Thread ╰» ℓαℓιт мσαнη
Hi Rajan, I also want to learn how to build and use VSTO so if u found something related to this please let me know. Regards, Lalit Mohan On Tue, Jun 26, 2012 at 8:29 PM, ╰» ℓαℓιт мσαнη wrote: > Hi Rajan, > > Actually i faced this issue while doing vba programming. These are > just steps to r

Re: $$Excel-Macros$$ VBA editor auto-deletes spaces at the ends of lines

2012-06-26 Thread ╰» ℓαℓιт мσαнη
Hi Rajan, Actually i faced this issue while doing vba programming. These are just steps to resolve the same. Regards, Lalit Mohan On Tue, Jun 26, 2012 at 8:24 PM, Rajan_Verma wrote: > Lalit Can you give the example .? I have vsto on my system, > > > > > > Regards > > Rajan verma > > +91 783810

Re: $$Excel-Macros$$ Problem with excel

2012-06-26 Thread Divaker Pandey
but it will lock modification in list through vba. Divker On Tue, Jun 26, 2012 at 8:23 PM, NOORAIN ANSARI wrote: > Hi Divaker, > > I have created a name range "List_Matters", > > We called it through below coding.. > > Sheet1.lstLookup.ListFillRange = "List_Matters" > > and in Property Boxt i ha

RE: $$Excel-Macros$$ VBA editor auto-deletes spaces at the ends of lines

2012-06-26 Thread Rajan_Verma
Lalit Can you give the example .? I have vsto on my system, Regards Rajan verma +91 7838100659 [IM-Gtalk] From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Lalit_Mohan Sent: 26 June 2012 8:20 To: excel-macros@googlegroups.com Subject: $$Excel-Macr

RE: $$Excel-Macros$$ VBA editor auto-deletes spaces at the ends of lines

2012-06-26 Thread Rajan_Verma
Are you working Excel project in VSTO or in Excle VBE? Regards Rajan verma +91 7838100659 [IM-Gtalk] From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Lalit_Mohan Sent: 26 June 2012 8:20 To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ V

Re: $$Excel-Macros$$ Problem with excel

2012-06-26 Thread NOORAIN ANSARI
Hi Divaker, I have created a name range "List_Matters", We called it through below coding.. Sheet1.lstLookup.ListFillRange = "List_Matters" and in Property Boxt i have marked columnHeads as true. -- Thanks & regards, Noorain Ansari www.noorainansari.com www.excelmacroworld.blogspot.com On T

$$Excel-Macros$$ VBA editor auto-deletes spaces at the ends of lines

2012-06-26 Thread Lalit_Mohan
Today i faced an issue with excel 2010. if u have installed Visual Studio 2010 beta2 then VBA editor auto-deletes spaces at the ends of lines so below are the steps which helps me to resolve this. 1. Click the Microsoft Office Button, and then click Excel Options 2. Click the Add-Ins cate

Re: $$Excel-Macros$$ Problem with excel

2012-06-26 Thread Divaker Pandey
Noorain, It will be helpful if you give me VBA code to add header column. I think listbox used header on the base of assigned range on ListFillRange properties. But it is not make sense to solve my query, because i have 72000 rows, and take selected rows form them. i could not want write it aga

Re: $$Excel-Macros$$ Problem with excel

2012-06-26 Thread Divaker Pandey
Hi Lalit, I want to list out all company which string match in any column(available data) Divaker On Tue, Jun 26, 2012 at 8:03 PM, Divaker Pandey wrote: > Thanks Noorain, i want to list out all company details which match on > entered value in textbox. > > By the way how you added header in

Re: $$Excel-Macros$$ Problem with excel

2012-06-26 Thread Divaker Pandey
Thanks Noorain, i want to list out all company details which match on entered value in textbox. By the way how you added header in listbox. Please tell me steps. Thanks. Divaker On Tue, Jun 26, 2012 at 7:28 PM, ╰» ℓαℓιт мσαнη wrote: > Hi Divaker, > > You query is not cleary mentioned can u pl

Re: $$Excel-Macros$$ MY NEW EXCEL DASHBOARD PROJECTS

2012-06-26 Thread ╰» ℓαℓιт мσαнη
Nice work Hilary.. Regards, Lalit Mohan On Tue, Jun 26, 2012 at 7:17 PM, Rajan_Verma wrote: > Hi deba.. > > Actually the "BLPLinkReset" is a macro which was called at the time of > Recording this macro. > > > > Hi Hilary.. > > > > You can put the  code of "BLPLinkReset" in your dashboard. So tha

Re: $$Excel-Macros$$ Problem with excel

2012-06-26 Thread ╰» ℓαℓιт мσαнη
Hi Divaker, You query is not cleary mentioned can u please share a file with the full description so that we can help u as soon as possible Regards, Lalit Mohan On Tue, Jun 26, 2012 at 6:35 PM, Divaker Pandey wrote: > Hi Experts, > > Still waiting for your response. > > Divaker > > > On Tue, J

RE: $$Excel-Macros$$ Re: delete blank columns

2012-06-26 Thread Rajan_Verma
Hi Lalit If any Column have data in some cells then it will also be deleted, Regards Rajan verma +91 7838100659 [IM-Gtalk] -Original Message- From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of ?» lal?? ?sa?? Sent: 26 June 2012 7:20 To: excel-macros@

Re: $$Excel-Macros$$ Re: delete blank columns

2012-06-26 Thread ╰» ℓαℓιт мσαнη
You can try this also on error resume next activesheet.specialcells(xlcelltypeblank).usedrange.entirecolumn.delete on error goto 0: on error goto -1: err.clear Regards, Lalit Mohan On Tue, Jun 26, 2012 at 7:09 PM, Rajan_Verma wrote: > Try this > > Sub delete_blankcolumn() > Dim col a range >

RE: $$Excel-Macros$$ Re: Rajan Verma : Most Helpful Member - July'11

2012-06-26 Thread Rajan_Verma
Hi manish . thanks but This is about last year J Regards Rajan verma +91 7838100659 [IM-Gtalk] From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Manish Sent: 26 June 2012 6:33 To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Re: Rajan Ve

RE: $$Excel-Macros$$ Re: delete blank columns

2012-06-26 Thread Rajan_Verma
Try this Sub delete_blankcolumn() Dim col a range With ActiveSheet For Each col In .UsedRange.Columns If WorksheetFunction.CountA(col) = 0 Then col.Delete End If Next End With End Sub Regards Rajan verma +91 7838100659 [IM-G

RE: $$Excel-Macros$$ need help on maximum value and thier name

2012-06-26 Thread Rajan_Verma
=INDEX($B$1:$B$18,LARGE(--($P$1:$P$18=K24)*ROW($P$1:$P$18),COUNTIF($K$24:K24,K24)),1) With CSE Regards Rajan verma +91 7838100659 [IM-Gtalk] -Original Message- From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of NOORAIN ANSARI Sent: 26 June 2012 11:

Re: $$Excel-Macros$$ Re: Rajan Verma : Most Helpful Member - July'11

2012-06-26 Thread Divaker Pandey
well done rajan, keep it up lit and spread. Divaker On Tue, Jun 26, 2012 at 6:32 PM, Manish wrote: > Congr8ss Rajan... > > On Wednesday, August 3, 2011 10:52:02 PM UTC+5:30, Ayush Jain wrote: >> >> Hello Everyone, Rajan Verma has been selected as 'Most Helpful Member' for the month

Re: $$Excel-Macros$$ Problem with excel

2012-06-26 Thread Divaker Pandey
Hi Experts, Still waiting for your response. Divaker On Tue, Jun 26, 2012 at 5:10 PM, Divaker Pandey wrote: > Hi Noorain & Experts, > > Thanks for respond. please find attached file. > on tab sheet1 there is two activeX control > > 1. Textbox -txtLookup > 2. ListBox - lstLookup > > if user cha

$$Excel-Macros$$ Re: Rajan Verma : Most Helpful Member - July'11

2012-06-26 Thread Manish
Congr8ss Rajan... On Wednesday, August 3, 2011 10:52:02 PM UTC+5:30, Ayush Jain wrote: > > Hello Everyone, >>> >>> Rajan Verma has been selected as 'Most Helpful Member' for the month of >>> July'11 >>> He has posted 170 posts in July 2011 and helped many people through his >>> expertise. He h

Re: $$Excel-Macros$$ Re: Region wise count

2012-06-26 Thread Lokesh Loki
Hi Rajan, Thanks a lot brother. I have changed the last parameter and i get the correct result. Thank you very much. Have a great day brother. Regards Lokesh.M On Tue, Jun 26, 2012 at 2:17 PM, Rajan_Verma wrote: > > You can just change the last parameter , its works like countif > > =GetCount(

Re: $$Excel-Macros$$ Types of data analysis used in the company

2012-06-26 Thread NOORAIN ANSARI
Dear Mangesh, Please check below link, Hope it will useful for your query. **Link*** What Types Of Data Are Used For Statistical Analysis? How To Write A Data Analysis? What Is Data Analysis? What Are The Different Types Of Data? What Is Financial Data Analys

$$Excel-Macros$$ Types of data analysis used in the company

2012-06-26 Thread Mangesh Vimay
Hi Friends, Please tell me the types of data analysis which are used in the company to perform data operations. Please provide the information. Thanks !!! -- With regards, MaNgEsH -- -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thre

Re: $$Excel-Macros$$ Problem with excel

2012-06-26 Thread NOORAIN ANSARI
Dear Divaker, Please share your Activelistbox with group. -- Thanks & regards, Noorain Ansari www.noorainansari.com www.excelmacroworld.blogspot.com On Tue, Jun 26, 2012 at 4:07 PM, Divaker Pandey wrote: > Hi Ayush, > > I want to add header column text in Activelistbox through vba. > > Can you

$$Excel-Macros$$ Problem with excel

2012-06-26 Thread Divaker Pandey
Hi Ayush, I want to add header column text in Activelistbox through vba. Can you help me how i can add. Thanks. Divaker -- -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Pr

Re: $$Excel-Macros$$ MY NEW EXCEL DASHBOARD PROJECTS

2012-06-26 Thread hilary lomotey
Hi Amit Click on the column header you want to hide, in my case column H, which will highlight the whole column and hold ctrl + shift + forward arrow key , right click and select hide, same is true for the row headers. thanks On Tue, Jun 26, 2012 at 9:54 AM, Amit Gandhi wrote: > Nice Creativity

Re: $$Excel-Macros$$ Re: Regarding control tab in the scroll bar

2012-06-26 Thread Sanjib Chatterjee
Many many thank you Regards, Sanjib On Tue, Jun 26, 2012 at 2:37 PM, Rajan_Verma wrote: > Hi > In Developer Tab > Goto Insert -> More Controll ( Bottom Right) then Find Microsoft ScrollBar > > Rajan. > > > On Tuesday, 26 June 2012 14:09:19 UTC+5:30, friend wrote: > >> >> Dear Sir/ Madam, >> >>

Re: $$Excel-Macros$$ MY NEW EXCEL DASHBOARD PROJECTS

2012-06-26 Thread Amit Gandhi
Nice Creativity Hilary As I am new to these things, can I know how you Freezed Columns A to G and Rows 1 to 18 (and others Column & Row headers are not showing)? How you freezed scrolling thereafter? Regards Amit On Mon, Jun 25, 2012 at 7:41 PM, hilary lomotey wrote: > Hello Guys > > i just

Re: $$Excel-Macros$$ Regarding control tab in the scroll bar

2012-06-26 Thread NOORAIN ANSARI
Dear Sanjib, Anil is right, You have taken Scroll Bar from Active X control instead of Form Control. So control Option is not showing. Please select scroll bar from Form Control, It will work fine as per your need. -- Thanks & regards, Noorain Ansari www.noorainansari.com www.excelmacro

$$Excel-Macros$$ Fwd: Regarding control tab in the scroll bar

2012-06-26 Thread NOORAIN ANSARI
Dear Sanjib, Please goto Developer tab-click on Design and right click on scroll Bar Format Control Option will available. -- Thanks & regards, Noorain Ansari www.noorainansari.com www.excelmacroworld.blogspot.com On Tue, Jun 26, 2012 at 2:09 PM, Sanjib Chatterjee wrote: > > Dear Sir/ Madam

$$Excel-Macros$$ Re: Regarding control tab in the scroll bar

2012-06-26 Thread Rajan_Verma
Hi In Developer Tab Goto Insert -> More Controll ( Bottom Right) then Find Microsoft ScrollBar Rajan. On Tuesday, 26 June 2012 14:09:19 UTC+5:30, friend wrote: > > Dear Sir/ Madam, > > Please see the attachment, I can not find the control tab in the format > control > of the scroll bar. > >

Re: $$Excel-Macros$$ I want to repeat the text or number,

2012-06-26 Thread Rajan_Verma
Hi Neeraj the formula is reverse the order of the values , is it what you meant to repeat the text or number Rajan. On Tuesday, 26 June 2012 14:28:54 UTC+5:30, neeraj chauhan wrote: > Thanks Rohan, > > > > > > > > [image: Sign] > > > > *From:* excel-macros@googlegroups.com [mai

Re: $$Excel-Macros$$ Step and repeat in Excel -- need help

2012-06-26 Thread Rajan_Verma
HTH AddShape 1 ,1 ,1,100,0 Rajan. On Tuesday, 26 June 2012 12:16:33 UTC+5:30, raj wrote: > sorry password for attached file is "rajeshd" > > On 26 June 2012 12:15, Rajesh Durgaiah wrote: > >> Hi, >> >> I've created one excel file for step and repeat, but I',m finding >> difficulties i

Re: $$Excel-Macros$$ I want to repeat the text or number,

2012-06-26 Thread Rohan Young
Dear Neeraj, See the attachment, if help Regds ROHAN On Tue, Jun 26, 2012 at 2:11 PM, Neeraj Chauhan wrote: > Siwaya > > Sikhera 1 > > Maithna Inder Singh > > Salarpur > > Niit > > Pela Sofipur > > Ganga Nagar > > Pallavpuram > > Pallav Puram > > Ganga Naga

$$Excel-Macros$$ Re: Region wise count

2012-06-26 Thread Rajan_Verma
You can just change the last parameter , its works like countif =GetCount(B:B,N3,"*") Rajan On Tuesday, 26 June 2012 08:51:21 UTC+5:30, lokesh wrote: > Hi Rajan, > > I have sent resolved previous region wise count query, but i made some > changes in the data and added some more regions an

Re: $$Excel-Macros$$ Is there a way of running macros in Macintosh?

2012-06-26 Thread NOORAIN ANSARI
Dear Krishnan, Please check below link, hope it will help to you. http://excelsemipro.com/2010/11/excel-2011-for-mac-installation-preferences-and-vba/ -- Thanks & regards, Noorain Ansari www.noorainansari.com www.excelmacroworld.blogspot.com On Tue, Jun 26, 2012 at 10:49 AM, wrote: > Dear ex

Re: $$Excel-Macros$$ MY NEW EXCEL DASHBOARD PROJECTS

2012-06-26 Thread NOORAIN ANSARI
Nice Creativity Hilary, Thanks to share with Group. On Mon, Jun 25, 2012 at 7:41 PM, hilary lomotey wrote: > Hello Guys > > i just completed my two excel projects and want to share. The first one is > like an accounting system where you can enter clients information as well as > transactions and

Re: $$Excel-Macros$$ Re: MY NEW EXCEL DASHBOARD PROJECTS

2012-06-26 Thread respuzy
Hi Core Kindly read ♍Ɣ email you would realize I was very specific in providing the password to the file. Sent from my BlackBerry® smartphone from Airtel Ghana -Original Message- From: CoRe Sender: excel-macros@googlegroups.com Date: Tue, 26 Jun 2012 00:42:36 To: Reply-To: excel-macr

$$Excel-Macros$$ Re: MY NEW EXCEL DASHBOARD PROJECTS

2012-06-26 Thread CoRe
Thank you Hilary for sharing those templates with us , but would be very useful ,not just looking how it looks but to be customizable as well. What is the point sharing with us protected files , not that i cannot find a password breaker but like i sayd would be more useful if protection is of