$$Excel-Macros$$ Issue with English (United States) number format to Germany(Germany) Number format

download data data it converts automatically from US to German format like below -71.69578162 convert into -7169578162 Please suggest me workaround it. Divaker Pandey -- 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

$$Excel-Macros$$ find exact value contains special characters like *, ?, #, " excel cells using match function

say if cell a1 contains a text and a2 contains aaa* and i used match function =match("aaa*",A1:A2",0) it should return 2 Thanks -- 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.facebo

$$Excel-Macros$$ help in Excel Add-ins

1. I need to made a macro-enabled workbook (like add-in). 2. Which should have a visible formatted input tab and one Read Me tab, and other hidden tab 3. In Input tab will have be definite number of rows and columns with detailed captions 4. User will use this tab to input their required data. 5.

$$Excel-Macros$$ Is it possible to visible an Add ins own worksheets when it installed with a new workbook.

Hi Experts, I created an add-in in excel 2010, having multiple worksheets with custom menu. I need when this add ins installed with another workbook, add-ins tab must be visible, is it possible? Regards, Divaker -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIM

$$Excel-Macros$$ Is it possible to visible an Add ins own tab when it installed with a new workbook.

Hi Expert, Is it possible to visible an Add ins own tab when it installed with a new workbook. Regards, Divaker -- 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

$$Excel-Macros$$ Excel -Tally Integration through XML

hi expert, can any one provide me a code sample to integrate excel with tally via XML? Expert please suggest me steps to follow for integration. Regards, Divaker -- 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 t

$$Excel-Macros$$ Excel 2007 & Excel 2010

hi expert , below code take different execution time on Excel 2007 and Excel 2010 Excel2007 =20 Sec Excel2010 =1 sec can any one suggest what may be reason Thanks Regards, Sub ImportXMLtoList(shtTemp As Worksheet, strTargetFile As String) Dim wb As Workbook shtTemp.UsedRange.Clear Debug.Prin

Re: $$Excel-Macros$$ how to create add-in

http://www.cpearson.com/excel/createaddin.aspx use above link Divaker Pandey On Thu, Jun 26, 2014 at 2:23 PM, Satendra kumar wrote: > Hi All, > > i have same query... > > > thanks > satendra > > > On Thu, Jun 26, 2014 at 1:51 PM, wrote: > >> Sir, >&g

$$Excel-Macros$$ Export data from excel to tally.

hi experts, Is there any way to export data from excel to Tally 9.0 Divaker -- 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, accura

Re: $$Excel-Macros$$ Need Help

you can use pivot table option On Fri, Jun 13, 2014 at 1:23 AM, Imran Khan wrote: > Dear All, > > I need your help to summarize the sheet. I have attach the file as an > example. I am looking formula to summarize matching with T1A, T1R & T2 from > Data sheet. > > Please help me. > > I applogise

Re: $$Excel-Macros$$ help required urgently

1. change date format in d/mm/ 2. change text to column 3.now use date function to combined date again Divaker On Thu, Mar 27, 2014 at 4:04 PM, Neeraj Chauhan wrote: > Dear experts, > > > > We have givne below date format how to convert right format of date like > 13-Jan-2014 > > > > TT Mo

Re: $$Excel-Macros$$ Need Book for Web scrpting by vba excel

please explain what is your purpose. Divaker On Wed, Mar 26, 2014 at 10:45 AM, pramodb35 wrote: > Hi Excel Expert, > > I am Pramod. Any have idea that any kind of book available in market for > Web scrpting by excel vba > I am newly developer of excel vba. and also suggest me that can i use >

Re: $$Excel-Macros$$ Difference in minutes between 2 dates

best way to calculate date difference. using text function. See in attached sheet. Divaker On Thu, Mar 27, 2014 at 2:25 PM, Priyanka Sachdeva < priyanka.sachdeva...@gmail.com> wrote: > Thanks All ! .. It worked > > > On Mon, Mar 24, 2014 at 9:22 AM, Ashish Kumar > wrote: > >> Hi Priyanka, >>

Re: $$Excel-Macros$$ extracting zip codes from addresses

can you provide please sample file. Divaker On Wed, Mar 26, 2014 at 5:51 PM, joseph liech wrote: > hi everyone > > i have looked around most postings here but none was similar to my > situation. > > i need help please, or kindly pls suggest me where i can get help. > > everyday i received about

$$Excel-Macros$$ Challenge for experts

Excel (2007) intermittently adds the full pathname of the add-in to the function name when it's used in a cell formula. Then if the spreadsheet is opened on another computer, even if the other computer has the add-in installed, the function is not recognized. Any idea how to solve this? -- Are y

$$Excel-Macros$$ Excel Add in

Excel (2007) intermittently adds the full pathname of the add-in to the function name when it's used in a cell formula. Then if the spreadsheet is opened on another computer, even if the other computer has the add-in installed, the function is not recognized. Any idea how to solve this? Divaker

Re: $$Excel-Macros$$ Need Formula

i think you want =VLOOKUP(B7,$A$1:$E$4,MATCH(C7,$A$1:$E$1,0)) On Tue, Mar 25, 2014 at 5:42 PM, Deepak Rawat wrote: > Hi, > > is there any solution in someproduct formula to get intersect text value > in 2D range: > > Below is the data; > >Bran Model - 1 Model - 2 Model - 3 Model - 4 Audi

Re: $$Excel-Macros$$ how to retrieve already applied conditional formatting on a cell

.MrExcel4U.com <http://mrexcel4u.blogspot.com/> > > > On Thu, Mar 20, 2014 at 6:12 PM, Vabs wrote: > >> Hi >> >> What exactly you are looking for in VBA. >> >> Thx >> >> >> On Thu, Mar 20, 2014 at 2:04 PM, Divaker Pandey

Re: $$Excel-Macros$$ Need Macro or a simple easy sorting technique

ow: > > Audi, BMW > BMW, Toyota > BMW, Honda, Toyota > > > > could duplicate value be deleted by macro, kindly help > > Regards, > Deepak Rawat > > > > On Thu, Mar 20, 2014 at 2:40 PM, Divaker Pandey wrote: > >> use this macro >> >>

Re: $$Excel-Macros$$ Split Workbook into many sheets

use below code Sub createSheet() Dim cpyRng As String, EmpCode As String, EmpDtl As String Dim i As Integer Dim totRow As Integer, RecStartRow As Integer, RecEndRow As Integer Dim cpyFlag As Boolean totRow = 190 For i = 8 To totRow If InStr(ThisWorkbook.Sheets("Sheet1").Cells(i, 1).Value, "** Cod

Re: $$Excel-Macros$$ Need Macro or a simple easy sorting technique

use this macro Sub sortCellsValue() Dim tempStr As String, resultSet As String Dim tempStrArr() As String Dim i As Integer For Each cl In ThisWorkbook.Sheets("Sheet1").Range("A2:A271") tempStrArr = Split(cl.Value, ",") For i = 0 To UBound(tempStrArr) For j = i + 1 To UBound(tempStrA

Re: $$Excel-Macros$$ Need Help

you can get max date by the pivot table. Regards, Divaker On Mon, Mar 17, 2014 at 5:47 PM, Imran khan wrote: > Hi Friends, > > I am stuck in working file where i need your help. I have attached file > for formula. > > Thanks & Regards, > > *Imran Khan* > > *Lead Planner - OR/CSU* > > Ras Al-K

$$Excel-Macros$$ how to retrieve already applied conditional formatting on a cell

Hi Expert, can any one please share code to retrieve already applied conditional formatting on a cell or range of excel workbook through vba. Thank & Regards, Divaker -- 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 pag

Re: $$Excel-Macros$$ how to get conditional formatting code already applied on a cell through vba

.MrExcel4U.com <http://mrexcel4u.blogspot.com/> > > > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] *On Behalf Of *Divaker Pandey > *Sent:* Tuesday, March 18, 2014 2:06 PM > *To:* excel-macros@googlegroups.com > *Subject:* $$Excel-Macros$$

$$Excel-Macros$$ how to get conditional formatting code already applied on a cell through vba

Hi Expert, can any one please share code to get applied conditional formatting on a cell or range of excel workbook through vba. Thank & Regards, Divaker -- 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 for

$$Excel-Macros$$ Mouse Hover custom tool tip on chart data label.

Hi Experts, is there any way to make a Mouse Hover custom tool tip on chart in excel. please provide your views, whether it possible or not. if possible how we can do it, Thanks Divaker -- 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 off

$$Excel-Macros$$ urgent Requirement

This is Divaker from Nine Dimensions Infotech Pvt ltd.. I would like to inform you that my company has vacancy for a Software Engineer having skill on Excel, VBA and Basic SQL. Please forward me your resume as soon as possible if you are interested. by providing Rating in below brackets Basic E

$$Excel-Macros$$ Urgent Requirement

This is Divaker from Nine Dimensions Infotech Pvt ltd.. I would like to inform you that my company has vacancy for a Software Engineer having skill on Excel, VBA and Basic SQL. Please forward me your resume as soon as possible if you are interested. by providing Rating in below brackets Basic E

Re: $$Excel-Macros$$ Excel Addin Formula gets converted to the addin path

Team XLS > > > > On Wed, Aug 28, 2013 at 9:53 PM, Divaker Pandey wrote: > >> thanks for reply, >> >> if user machine had installed and used same add in. then why this >> problem remains.? >> >> I can't send code with excel file. is there anoth

Re: $$Excel-Macros$$ Excel Addin Formula gets converted to the addin path

in your system.. thats why another user get > convert formula to addin path > > suggestion/solution :- you can paste your addin code in your workbook so > thats no need for addin > > . > > Enjoy > Team XLS > > > > On Wed, Aug 28, 201

$$Excel-Macros$$ Excel Addin Formula gets converted to the addin path

I have created some functions and created an excel addin(This addin is extracting data from other applications). This create a problem as , if one user send the file to other users ,the formula that I have written gets converted and include the path where I had saved the addin. they have to redef

Re: $$Excel-Macros$$ how i can heading text in a list box

ste it into the RowSource. > > 2013/8/14 Divaker Pandey > >> >> >> hi expert, >> >> please help me to add heading text in a list box. >> >> Thanks & Regards, >> >> Divaker >> >> -- >> Are you =EXP(E:RT) or =NOT(EXP

$$Excel-Macros$$ how i can heading text in a list box

hi expert, please help me to add heading text in a list box. Thanks & Regards, Divaker -- 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 con

$$Excel-Macros$$ step to make and install excel 2007 add in on user machine

Hi Expert, can any one explain me how to make an add in in excel 2007, contain a user define function. what things to keep in mind to make scalable and robust add in. Please also point out the steps through which a normal excel user can install on his machine easily. thanks Divaker -- Are you

$$Excel-Macros$$ how to solve international decimal and comma separator issue,

Hi Expert, how to solve international decimal and comma separator issue, it data download from web in US Format Thanks & Regards, Divaker -- 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://ww

Re: $$Excel-Macros$$ get data range used by chart in excel using vba

1).Chart. _ > ChartArea.Interior.Pattern = xlLightDown > > Thanks > > > > On Tue, Jun 25, 2013 at 6:00 PM, Divaker Pandey wrote: > >> hi expert how i can get data range used by chart in excel using vba. >> >> >> Divaker >>

$$Excel-Macros$$ get data range used by chart in excel using vba

hi expert how i can get data range used by chart in excel using vba. Divaker -- 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, accu

Re: $$Excel-Macros$$ want to do MCA through distance education

if you have caliber, willing to get knowledge then go with IGNOU. otherwise you can join any one that approved by acte. On Tue, Jun 11, 2013 at 8:34 PM, arvind ks wrote: > Hi Everybody, > > I want to do MCA through DISTANCE learning. > > Can you suggest me some good universities where i can enr

Re: $$Excel-Macros$$ Re: VBA basic information

Hi Vab, a lot of thanks to share the topics to cover for a vba developer. this group is famous, bcz it have member like you. please continue keep excelling. It will be better if you share some information for error handling technique in VBA. Divaker On Sun, Jun 9, 2013 at 12:19 PM, Vabz w

Re: $$Excel-Macros$$ Require code Double Click To Copy Data To Another Worksheet

means you want to create new one worksheet or copy data on existing sheet. how ever according your question please use following code in thisworkbook module Private Sub Workbook_SheetBeforeDoubleClick(ByVal Sh As Object, ByVal Target As Range, Cancel As Boolean) ActiveWorkbook.Sheets(Sh.Name).C

Re: $$Excel-Macros$$ Problem in file..?

are using formula in sheet?, i hope there are refrences of some other files that may be closed. it may reason you file taking more time to calculate. On Thu, May 23, 2013 at 8:05 PM, Divaker Pandey wrote: > are using formula in sheet?, i hope there are refrences of some other >

Re: $$Excel-Macros$$ Problem in file..?

are using formula in sheet?, i hope there are refrences of some other files. On Thu, May 23, 2013 at 5:49 PM, P.VIJAYKUMAR wrote: > Respected Prabhu, > > You are saying that the sheet is companies sheet.Is is password protected > or are any user rights restricted to used and to modify or make a

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

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

$$Excel-Macros$$ Before_Close event to reset Calc to xlCalculationAutomatic recalcuate workbook again, can it stopped

I'm running into one problem with this. My workbook is pretty massive, so I've turned Application.Calculation to Manual when opening, and only calculate specified areas when necessary while file is open. (I also have CalculateBeforeSave set to False.) This works great, except users get annoyed whe

$$Excel-Macros$$ Treeview in 2010 64Bit

Hi Expert I have made an application that have tree view. it works on 2010 32Bit excel. but get problem in 2010 64Bit. is there any solution to rectify this issue? Regards. Divaker -- 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 officia

Re: $$Excel-Macros$$ hyperlink issue

solved . On Thu, Feb 28, 2013 at 3:41 PM, amar takale wrote: > Dear All, > > I have facing some hyperlink issue in sheet,I attached sheet in detailed > information,Pls tell me It is possible? > > Regards > Amar > > -- > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s >

Re: $$Excel-Macros$$ VBA or Formula Solution ( tough work)

Oh Great, Deepak, it is the really very worth-full post by you. my hats off for explain this concept among excel user. I hope it will increase again more interest of user to see and review again each post of user group. Again Tussi great ho tohfa kabool karo On Mon, Feb 18, 2013 at 4:05 PM, De

$$Excel-Macros$$ user could select either ">" or "<" and the formula would change

Hi expert, is it possible without macro. I'm trying to make a dynamic formula so the user could select either ">" or "<" and the formula would change. See Attachment. Divaker -- 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 Fac

Re: $$Excel-Macros$$ Passing array of shapes to udf using vba

PFA On Tue, Jan 8, 2013 at 1:40 PM, Amol J wrote: > Hi Experts, > > I need help > > I have multiple shapes in sheet so i want color only one shapes in that > perticular sheet. So I created a function which Change the color of > provided set of shapes. > > I want know how to pass array of shapes

Re: $$Excel-Macros$$ char code for SM (Service Mark)

Thanks for rply i need use SM in vba form caption, is there any way to add. Divaker On Tue, Dec 18, 2012 at 6:24 PM, David Grugeon wrote: > Sorry - that is the hex unicode for the character. I don't think CHAR() > does unicode. > > Regards > David Grugeon > > > > On 18 December 2012 22:48, Da

$$Excel-Macros$$ char code for SM (Service Mark)

hi expert, can any one tell the char code for SM (Service Mark) Divaker -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Pr

Re: $$Excel-Macros$$ Formula to Calculate Networkdays

use this one =NETWORKDAYS(DATEVALUE("12/24/2012"), DATEVALUE("12/28/2012"),A:A ) Let Range A:A contains list of holidays On Thu, Dec 13, 2012 at 8:47 PM, Manjunath Narayanappa < manjunath.narayana...@aon.co.uk> wrote: > > > Hi experts, > > > > I want to calculate no of workdays and excludes hol

Re: $$Excel-Macros$$ Slow down time in Processing Information *

use both code and keep your current code between them On Thu, Dec 13, 2012 at 9:44 PM, Hilary Lomotey wrote: > thanks chief , but which of the codes shd i use, you provided two > > On Thu, Dec 13, 2012 at 3:58 PM, Divaker Pandey wrote: > >> [image: Boxbe] <https://www.box

Re: $$Excel-Macros$$ Slow down time in Processing Information

hi you can write some code on command button click with application .screenupdating=false .calculation= xlcaluationmanual end with -Prsent code-- with application .screenupdating=true .calculation= xlcaluationautomatic end with On Thu, Dec 13, 2012 at 9:16 PM, Hilary Lomo

$$Excel-Macros$$ excel Application with a userdefined ribbon built in using xml Error

Hello Exprets, I am struggling with the following strange problem in MS Excel 2007 (rarely occurs). I have an excel Application with a userdefined ribbon built in using xml. Suddenly, during loading application i get an error message. => The message box that appears has no words, number or any

Re: $$Excel-Macros$$ reset dropdown text using macro in Menu Bar

Okey finally i have able to solved it. i have another uncertain issue now in Excel 2007, some time a blank error dialog box display. with title 'Mirosoft Visual Basic' during robbon load. Exprets, what problem may be? Divaker On Mon, Nov 12, 2012 at 3:54 PM, Divaker Pandey wr

$$Excel-Macros$$ reset dropdown text using macro in Menu Bar

Hi All, I have made a custom menu in my application name 'evaDimensions' using xml, it have several other options ribbon tab, (See snapshot) I have used a dropdown PRVit Score: I need to reset dropdown text using macro, plz guide me to how i can access this control using macro. Thanks in adavance.

Re: $$Excel-Macros$$ Rajan Verma - Most Helpful Member October'12

Congrats Rajan. On Mon, Nov 12, 2012 at 2:20 PM, Rajan_Verma wrote: > Thanks All, > > > On Monday, 12 November 2012 10:24:55 UTC+5:30, ca_k...@yahoo.co.in wrote: > >> Congratulations Rajan >> >> >> On Wed, Nov 7, 2012 at 6:17 PM, Karan Singh wrote: >> >>> Congrats dude!! >>> >>> >>>

$$Excel-Macros$$ sheet name as variable

Is there any way to make reference like it DataTabTemp!$1:$1 i want to keep sheet name variable MATCH("EVAMOMARGIMP10",DataTabTemp!$1:$1,0) actully i have data in two sheet "DataTabTemp" and "DataTabUS" and now i need to change formula on whole application so i don't used anoter formula, but

Re: $$Excel-Macros$$ Preserving number leading 0 querytable excel

rom-ssms/ > > Regards, > Kuldeep Singh > > > On Tue, Oct 30, 2012 at 10:04 PM, Kuldeep Singh > wrote: > >> >> Hi Sir, >> >> Try this one. >> >> >> Regards, >> Kuldeep Singh >> >> On Tue, Oct 30, 2012 at 9:48 PM, Div

$$Excel-Macros$$ Preserving number leading 0 querytable excel

Hi Expert, Kindly provide any solution for following problem Preserving number leading 0 querytable excel . divaker -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread tit

Re: $$Excel-Macros$$ Re: Macro for Find

Use it, hope it will fulfill your requirement Sub CopyDesireCriteria() Dim strCriteria As String, n As Integer, CellV On Error Resume Next Application.CutCopyMode = True For Each CellV In ThisWorkbook.Sheets("Criteria").Range("A2:A4") If CellV.Value = "" Then Exit For If Le

Re: $$Excel-Macros$$ Trouble in 2007

What about macro setting on your Excel 2007 application Divaker On Sun, Oct 21, 2012 at 5:30 PM, SAJID MEMON wrote: > Dear experts, > > I have done a small project in excel 2003 with some command buttons. when > i open my project in excel 2007 then command buttons are not press or

Re: $$Excel-Macros$$ Reg Mail using excel Macro

you need to used vbscript and its object Divaker Pandey On Fri, Sep 21, 2012 at 2:37 PM, Vignesh S R wrote: > Hi, > Can any body guide me,how to attach the variables that are used in the > Form and need to consolidate and send to the another user in Mail (without > using outlook)

$$Excel-Macros$$ Office 2010, activating sheet fails in Workbook_Open after going out of protected view

Hi Experts, there is a problem with my code, when i open my application first time and got error during sheet activate in workbook_open method. can you help me to solve out. Divaker -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ member

$$Excel-Macros$$ last date in the series does not appear on the chart

Hi Experts, I have a time series line chart with dates on the x-axis. The dates run in ascending order , left to right. The last date in the series does not appear on the chart. After numerous attempts with different scenarios using the various functions under the "Scale" tab in the "Formatting A

$$Excel-Macros$$ want to show always last date in date range in chart X-Axis

Hi Expert, can any one help me to show last available date in chart -xaxis range. Divaker -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles,

$$Excel-Macros$$ combo box in Ribbon bar

Hi Experts I have added one dropdown in custom menu using xml. can i add their item value using macros, on workbook_activate method? Divaker -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use c

$$Excel-Macros$$ File opens read only on same excel instance

Hi Expert, I am facing one issue with excel. I open a excel workbook xyz.xlsm, it opens without any problem. But when I closed only xyz.xlsm, and try to reopen it, i am getting message that file is in read only mode. I tried all option. but still no clue What problem may be. can you experts give

Re: $$Excel-Macros$$ long opening file on the external server

s but my knowladge is still not there, sad but true. > Maybe some other solution, please. > > Regards, > > Pawel > >*From:* Divaker Pandey > *To:* excel-macros@googlegroups.com > *Sent:* Friday, July 13, 2012 9:40 AM > *Subject:* Re: $$Excel-Macros$$ long opening

Re: $$Excel-Macros$$ long opening file on the external server

try to calculate required calculation with the help of macros. Divaker On Fri, Jul 13, 2012 at 12:14 PM, pawel lupinski wrote: > Hi All, > > I need your help on this issue. I have quite big file (21MB) that is doing > a lot of calculation between tabs, in order to run this file more efficient >

$$Excel-Macros$$ currency and currency Symbol

Hi Expert, Can any one provide me currency name with symbol. 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 Problem, Code Problem, and Need Advice will not get quick a

Re: $$Excel-Macros$$ keep selected custom menu tab

> > > On Thu, Jul 5, 2012 at 5:59 PM, Divaker Pandey wrote: > >> Hi Group, >> >> I made a custom menu and ribbon icon using xml in my workbook. I want to >> keep selected the created custom menu everytime whenever workbook activated. >> >> >> D

Re: $$Excel-Macros$$ sum base on 8 digits code

I think Noorain's solution is the excellent among all replies. gr8 Noorain. Divaker On Thu, Jul 5, 2012 at 6:22 PM, Rajan_Verma wrote: > ** ** > > ** ** > > =SUM(--(LEFT($E$4:$E$23,8)=B4)*$F$4:$F$23) with CSE > > ** ** > > * * > > *Regards* > > *Rajan verma* > > *+91 7838100659 [IM-Gtalk]*

$$Excel-Macros$$ keep selected custom menu tab

Hi Group, I made a custom menu and ribbon icon using xml in my workbook. I want to keep selected the created custom menu everytime whenever workbook activated. Divaker -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like P

Re: $$Excel-Macros$$ COLOR CHANGE MACRO

use this one Sub ChangeRowColor() Dim sheet As Worksheet Dim row_min As Integer Dim row_max As Integer Dim rowC As Long ' Select the used range. Set sheet = ActiveSheet 'sheet.UsedRange.Select ' Display the range's rows and columns. row_min = sheet.UsedRange.Row row_max

Re: $$Excel-Macros$$ MVP Award....Congratulations Ashish Koul and Dilip Pandey !!

*Congrats..Ashish & Dilip, for your gr8 Achievement.* But it will be awesome.if you explore with group member, your journey to plan, execution and finally getting award. Hope another group member can get this award. Divaker On Wed, Jul 4, 2012 at 2:02 PM, NRao Mynampati wrote: > Congaratulatio

Re: $$Excel-Macros$$ urgent required vba code:: 2 list boxes in userform scroll same time.

suppose you scrorll listbox1 then write on listbox1_change event listbox2.listindex = listbox1.listindex Divaker On Wed, Jul 4, 2012 at 7:03 PM, Rajan_Verma wrote: > Can u share useform? > > ** ** > > * * > > *Regards* > > *Rajan verma* > > *+91 7838100659 [IM-Gtalk]* > > ** ** > > *From:

Re: $$Excel-Macros$$ Is there any way to find out how much memory is being used by a excel sheet in particular excel file

:) As your question as my answer. Ek Bucket thi usme pani, patthar , aur lakdi ka tukda tha, uska weight 10 kg tha. ab Shanta ne poocha Pani,pathar aur lakdi ka weight kitna hai, to banta bola pehale pathar nikal do fir weight karo, ab jitna weight kam hoga wo pathar ka weight hoga. aur same lakdi

Re: $$Excel-Macros$$ Re: Macro to copy a macro from one workbook to another

I think it can not possible due to security region. but what is your purpose? Divaker On Mon, Jun 25, 2012 at 10:31 PM, Richard wrote: > Thank you very much > On Sunday, June 24, 2012 4:46:35 PM UTC-7, Richard wrote: >> >> I would like to create a macro to copy a macro from one workbooks m

Re: $$Excel-Macros$$ Need a VBA code to display name in "Last Name, First Name" format

Hi Sharath, PFA, Hope it will help you. Divaker Private Sub Worksheet_Change(ByVal Target As Range) On Error GoTo Exit_Sub Dim nameIS() As String, newName As String If Target.Column = 6 And Target.Row > 6 Then If IsEmpty(Target.Value) Then Exit Sub If InStr(Target.Value,

Re: $$Excel-Macros$$ VLOOKUP for last Available Date

=VLOOKUP(I3,$E$2:$F$10,2,TRUE) On Mon, Jul 2, 2012 at 12:31 PM, Shaik Waheed wrote: > =vlookup(I7,$E$7:$F$14,2,1) > > > On Mon, Jul 2, 2012 at 11:32 AM, NOORAIN ANSARI > wrote: > >> Dear Manoj, >> >> Please more explain..what is your exact requirement. >> >> -- >> Thanks & regards, >> Noorain

Re: $$Excel-Macros$$ Fwd: MIS executive opening with Aricent Technologies (Contact to Hire)

Hi Noorain, I think job related to excel vba mail should not be banned. 1. it will help to user to know what is in current demand in excel related job. 2. it will encourage to learn and solve more excels quiz. 3. in last each enhanced skill is used to get better job options. Regards. Divaker O

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

Hi Experts still waiting for solution Divaker On Tue, Jun 26, 2012 at 8:25 PM, Divaker Pandey wrote: > but it will lock modification in list through vba. > > Divker > > > On Tue, Jun 26, 2012 at 8:23 PM, NOORAIN ANSARI > wrote: > >> Hi Divaker, >> >>

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

_Matters" > > and in Property Boxt i have marked columnHeads as true. > > > -- > Thanks & regards, > Noorain Ansari > www.noorainansari.com > www.excelmacroworld.blogspot.com > > On Tue, Jun 26, 2012 at 8:03 PM, Divaker Pandey > wrote: > > Tha

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

again on another place to make dynamic name range. that can be used in ListFillRange Properties. it will make application slow. Have you any another clue?? Divaker On Tue, Jun 26, 2012 at 8:09 PM, Divaker Pandey wrote: > Hi Lalit, > > I want to list out all company which string mat

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

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 add

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

ned 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. > >

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

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

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. ListBo

$$Excel-Macros$$ Problem with excel

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$$ All Ideas matter : Need your support here.

*Regards* > > *Rajan verma* > > *+91 7838100659 [IM-Gtalk]* > > ** ** > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] *On Behalf Of *Divaker Pandey > *Sent:* 22 June 2012 3:43 > *To:* excel-macros@googlegroups.com > *Subject:*

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

1. In PageSetup we have rows repeat at top, there should repeat at bottom as well. Divaker 9582060233 On Thu, Jun 21, 2012 at 8:58 PM, Maries wrote: > *My Suggestion* > > > http://www.google.com/moderator/#15/e=455db&t=455db.40&f=455db.66a716&q=455db.66a716 > > > > > On Tue, Jun 19, 2012 a

Re: $$Excel-Macros$$ Sheet Requirements

good reply don On Tue, Jun 12, 2012 at 6:34 PM, dguillett1 wrote: > Forgive me but as I recall you have been a part of this group for > awhile. If so, you should have learned enough to do this yourself. > > Don Guillett > Microsoft MVP Excel > SalesAid Software > dguille...@gmail.com > > *Fro

Re: $$Excel-Macros$$ want to add our own custom button and Tab in Excel 2007 name in place of add-in

t; Please see Ashish Koul created My Menu Add-In. > I think your need to create this type of custom Menu. > > Please check and revert. > > > -- > Thanks & regards, > Noorain Ansari > www.noorainansari.com > www.excelmacroworld.blogspot.com > > > O

Re: $$Excel-Macros$$ Error handling matter

ue, Jun 12, 2012 at 3:05 PM, Divaker Pandey wrote: > >> Hi Experts, >> >> can you please provide me some matter on error handling in vba >> application. >> >> Divaker >> >> >> -- >> FORUM RULES (986+ members already BANNED for violation

Re: $$Excel-Macros$$ want to add our own custom button and Tab in Excel 2007 name in place of add-in

later > > ** ** > > * * > > *Regards* > > *Rajan verma* > > *+91 7838100659 [IM-Gtalk]* > > ** ** > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] *On Behalf Of *Divaker Pandey > *Sent:* 12 June 2012 3:03 > *To

Re: $$Excel-Macros$$ call addin fuction before activeworkbook close ...... Urgent

ver i close any workbook , it should be run from addins > > addinfile name: idbiuploader.xlam > macro name : uploadingmodel > > please help.. > > Dhartikumar > > > On Tue, Jun 12, 2012 at 4:00 PM, Divaker Pandey wrote: > >> >> Hi Dharti, >> >&

Re: $$Excel-Macros$$ call addin fuction before activeworkbook close ...... Urgent

Hi Dharti, If i could understand your problem, then please use following code Private Sub Workbook_BeforeClose(Cancel As Boolean) Application.Run "'" + ThisWorkbook.name + "'!MacroToRun", argument1, argument2, argumentN End Sub On Tue, Jun 12, 2012 at

Re: $$Excel-Macros$$ call addin fuction before activeworkbook close ...... Urgent

can you provide more details On Tue, Jun 12, 2012 at 3:31 PM, wrote: > ** > Any update. > Sent from BlackBerry® on Airtel > -- > *From: * dhartiku...@gmail.com > *Date: *Tue, 12 Jun 2012 07:15:16 + > *To: * > *ReplyTo: * dhartiku...@gmail.com > *Subject: *Re:

  1   2   >