$$Excel-Macros$$ Problem in Pivot

Hi Experts, Request you to help to resolve this below query. I have put pivot for one data and it contains employee code and name. I tried option multiple consolidation ranges while put a pivot. Name also consider as value. Need to show employee code as well as name in pivot, also is it possi

Re: $$Excel-Macros$$ Problem assigning a function to a variable

Change 16 to 15 On 05-Jun-2016 3:50 AM, "Laura Wheaton-Werle" < la...@doublewcommunications.com> wrote: > I've created a simple VBA code that copies a line of code to a specified > range. > > Sub PowerOfOne_Report() > > ActiveWorkbook.Worksheets("PowerOfOne").Rows("3:3").Copy > Act

$$Excel-Macros$$ Problem assigning a function to a variable

I've created a simple VBA code that copies a line of code to a specified range. Sub PowerOfOne_Report() ActiveWorkbook.Worksheets("PowerOfOne").Rows("3:3").Copy ActiveWorkbook.Worksheets("PowerOfOne").Rows("3:16").Select ActiveSheet.Paste End Sub HOWEVER, I need to

Re: $$Excel-Macros$$ Problem in Pivot Table

Perfect... Thanks! *With regards,**Pravin Gunjal* *Mobile: 77100 * *97250* On Mon, Apr 25, 2016 at 1:17 PM, Abhishek Jain wrote: > Try this: > >1. Right-click a cell in the pivot table >2. Click on PivotTable options >3. Click on the Data tab >4. In the Retain Items section,

Re: $$Excel-Macros$$ Problem in Pivot Table

Try this: 1. Right-click a cell in the pivot table 2. Click on PivotTable options 3. Click on the Data tab 4. In the Retain Items section, select None from the drop down list. 5. Click OK, then refresh the pivot table. On Mon, Apr 25, 2016 at 12:54 PM, Pravin Gunjal wrote: > Not

Re: $$Excel-Macros$$ Problem in Pivot Table

Not relevant.. *With regards,**Pravin Gunjal* *Mobile: 77100 * *97250* On Mon, Apr 25, 2016 at 12:41 PM, Satendra kumar wrote: > Hi, > > you can check name spelling or space. > > thanks > satendra > > On Mon, Apr 25, 2016 at 12:32 PM, Pravin Gunjal wrote: > >> Hi Friends, >> >> I got an er

Re: $$Excel-Macros$$ Problem in Pivot Table

Hi, you can check name spelling or space. thanks satendra On Mon, Apr 25, 2016 at 12:32 PM, Pravin Gunjal wrote: > Hi Friends, > > I got an error while arranging the data in pivot table. > > The list has only 34 names common in Data Sheet while when I click on Row > Lable Filter in Pivot Sheet

Re: $$Excel-Macros$$ problem in code fpr data copied from text to number format

--- > > > > > > > > *“Do all the good you can,By all the means you can,In all the ways you > can,In all the places you can,At all the times you can,To all the people > you can,As long as ever you can.” - John Wesley* > - > >

Re: $$Excel-Macros$$ problem in code fpr data copied from text to number format

you can, To all the people you can, As long as ever you can.” - John Wesley ------------- From: Ashish Bhalara >To: excel-macros@googlegroups.com >Sent: Tuesday, February 3, 2015 1:02 AM >Subject: $$Excel-Macros$$ problem in code fpr data copied from text to

$$Excel-Macros$$ problem in code fpr data copied from text to number format

Dear experts, Please see attached file in which account no. field is text format but copied in number format. Problem is that when I type 0123, data copied at 123 as per my coding, I also try by define variable as string but problem same as standing. Please edit my code to solve this issue. Rega

Re: $$Excel-Macros$$ Problem With Timer-inVBA

gt;>>> are you using? >>>>>> >>>>>> *Paul* >>>>>> - >>>>>> >>>>>> >>>>>> >>>>>> >>>>>> >>>>>> >>>>>> >>>>>&

Re: $$Excel-Macros$$ Problem With Timer-inVBA

>>> *“Do all the good you can,By all the means you can,In all the ways you >>>>> can,In all the places you can,At all the times you can,To all the people >>>>> you can,As long as ever you can.” - John Wesley* >>>>> -

Re: $$Excel-Macros$$ Problem With Timer-inVBA

>>>> >>>> >>>> >>>> >>>> >>>> *“Do all the good you can,By all the means you can,In all the ways you >>>> can,In all the places you can,At all the times you can,To all the people >>>> you can,As long as ever you can.” - John Wesley* >>>>

Re: $$Excel-Macros$$ Problem With Timer-inVBA

t; you can,As long as ever you can.” - John Wesley* >>> - >>> >>>*From:* Soumyendu Paul >>> *To:* excel-macros@googlegroups.com >>> *Sent:* Sunday, February 1, 2015 3:51 PM >>> *Subject:* $$Excel-Macros

Re: $$Excel-Macros$$ Problem With Timer-inVBA

In all the ways you >> can,In all the places you can,At all the times you can,To all the people >> you can,As long as ever you can.” - John Wesley* >> --------- >> >>*From:* Soumyendu Paul >> *To:* excel-macros@googlegroups.co

Re: $$Excel-Macros$$ Problem With Timer-inVBA

- > >*From:* Soumyendu Paul > *To:* excel-macros@googlegroups.com > *Sent:* Sunday, February 1, 2015 3:51 PM > *Subject:* $$Excel-Macros$$ Problem With Timer-inVBA > > I have developed a timer using selection change event.

Re: $$Excel-Macros$$ Problem With Timer-inVBA

s you can, At all the times you can, To all the people you can, As long as ever you can.” - John Wesley - > > From: Soumyendu Paul >To: excel-macros@googlegroups.com >Sent: Sunday, February 1, 2015 3:51 PM >Sub

$$Excel-Macros$$ Problem With Timer-inVBA

I have developed a timer using selection change event. But problem is how to stop timer using command button while timer is runng. please help! File attached -- 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$$ Problem Autofilter Date Range

Change this line to FDate = Range("J1")x1 Ldate = Range("J2")x1 Cheers! ! On Jan 18, 2015 3:31 PM, "Ashish Bhalara" wrote: > Dear experts, > > I want automatic filtering of Date range in cell C11 but the below code is > not work for Date Field, the output is hide to all data. Please sugg

$$Excel-Macros$$ Problem Autofilter Date Range

Dear experts, I want automatic filtering of Date range in cell C11 but the below code is not work for Date Field, the output is hide to all data. Please suggest what are mistake in coding. Sub Custom2() Dim r As String Dim FDate As Date, Ldate As Date r = Range("j3").Value Ran

Re: $$Excel-Macros$$ Problem in calculating yield to maturity

Check this. http://www.tvmcalcs.com/calculators/apps/excel_bond_yields Dear Friends, I am new to excel and my query is very small. I have to calculate yield to maturity for a bond. I am calculating it using XIRR and yield function in excel. Values are different. XIRR =12.13% whereas Yield =

$$Excel-Macros$$ Problem in calculating yield to maturity

Dear Friends, I am new to excel and my query is very small. I have to calculate yield to maturity for a bond. I am calculating it using XIRR and yield function in excel. Values are different. XIRR =12.13% whereas Yield =12.40% Please advice me what I have done wrong in calculating yield. I have

Re: $$Excel-Macros$$ Problem for copy and paste range in one sheet to other sheet

Cheers!! On Fri, Jul 18, 2014 at 9:09 PM, renuka chari wrote: > Thanks alot sir > > > On Friday, 18 July 2014 14:00:05 UTC+5:30, Vabz wrote: > >> Hi >> >> PFA >> >> Cheers!! >> >> >> On Fri, Jul 18, 2014 at 9:27 AM, renuka chari wrote: >> >>> Dear sir, >>> i was prepared a macro for a

Re: $$Excel-Macros$$ Problem for copy and paste range in one sheet to other sheet

Thanks alot sir On Friday, 18 July 2014 14:00:05 UTC+5:30, Vabz wrote: > > Hi > > PFA > > Cheers!! > > > On Fri, Jul 18, 2014 at 9:27 AM, renuka chari > wrote: > >> Dear sir, >> i was prepared a macro for autofilter the range based on column a1 in >> unique values and >> paste this rang

Re: $$Excel-Macros$$ Problem for copy and paste range in one sheet to other sheet

Hi PFA Cheers!! On Fri, Jul 18, 2014 at 9:27 AM, renuka chari wrote: > Dear sir, > i was prepared a macro for autofilter the range based on column a1 in > unique values and > paste this range into sheet2 side by side > in this i have succed in the autofilter the range data but failed to copy

Re: $$Excel-Macros$$ Problem for copy and paste range in one sheet to other sheet

Dear sir, i was prepared a macro for autofilter the range based on column a1 in unique values and paste this range into sheet2 side by side in this i have succed in the autofilter the range data but failed to copy this data into sheet2 side by side i think may be some logic was missing in secoun

Re: $$Excel-Macros$$ Problem for copy and paste range in one sheet to other sheet

What is error going on..Completely explain On Fri, Jul 18, 2014 at 2:00 AM, Renukachari Kasee wrote: > Dear Experts please help me in this regard. > > my macro was not working properly > > please help me...its urgent > > > > > > > > *(¨`•.•´¨) Always`•.¸(¨`•.•´¨) Keep(¨`•.•´¨)¸.•´ Smiling!!

$$Excel-Macros$$ Problem for copy and paste range in one sheet to other sheet

Dear Experts please help me in this regard. my macro was not working properly please help me...its urgent *(¨`•.•´¨) Always`•.¸(¨`•.•´¨) Keep(¨`•.•´¨)¸.•´ Smiling!!`•.¸.•´Thanks & Regards´¨) ¸ •´ ¸.•*´¨) ¸.•*¨) (¸.•´ (¸.•* ♥♥♥...♪♪♪RenukaChari. Kasee...♥♥♥...♪♪♪* *P Let us do

Re: $$Excel-Macros$$ Problem with Advanced Filter

Dear Hilary, U have to release the earlier filter i.e clear filter criteria and then apply the fresh one. Warm Regards, Gawli Anil. On Thu, Feb 27, 2014 at 9:06 AM, mrExcel4u wrote: > Plz share your workbook > > Thanks & regards, > > www.MrExcel4U.com > > > On Thu, Feb 27, 2014 at 2:06 AM, Hil

Re: $$Excel-Macros$$ Problem with Advanced Filter

Plz share your workbook Thanks & regards, www.MrExcel4U.com On Thu, Feb 27, 2014 at 2:06 AM, Hilary Lomotey wrote: > i have written a macro to extract couple of data from another sheet with > advanced filter > > 'extracting equity statement > Sheet24.Range("Eq

$$Excel-Macros$$ Problem with Advanced Filter

i have written a macro to extract couple of data from another sheet with advanced filter 'extracting equity statement Sheet24.Range("EqtyPDB").AdvancedFilter Action:=xlFilterCopy, CriteriaRange:=Sheet19.Range( _ "CW1:CX2"), CopyToRange:=Sheet19.Range("CN1:CU1"), Unique:=False immediately after t

$$Excel-Macros$$ problem with for loop

I am strugglig with the problem. Here is the image 1 after selecting one of element in listbox and then if I click delete material (commandbutton). It has to delete the select material in sheet 2

Re: $$Excel-Macros$$ problem

Dear Sudhir, Welcome. Thanks & Regards, Ashish On Monday, 23 December 2013, SUDHIR VERMA wrote: > thankx Ashish > > > On 15 December 2013 19:10, Ashish Kumar > 'kumar.ashish...@gmail.com');> > > wrote: > >> Dear Sudhir, >> >> Go to file option then click on options tab then click on language

Re: $$Excel-Macros$$ problem

thankx Ashish On 15 December 2013 19:10, Ashish Kumar wrote: > Dear Sudhir, > > Go to file option then click on options tab then click on language button > then select your language english and save it. > > Thanks, > Ashish > > > On Saturday, 14 December 2013, SUDHIR VERMA wrote: > >> Dear All,

Re: $$Excel-Macros$$ problem

Dear Sudhir, Go to file option then click on options tab then click on language button then select your language english and save it. Thanks, Ashish On Saturday, 14 December 2013, SUDHIR VERMA wrote: > Dear All, > > i am suffer problem in excel, when i type any key then generate Urdu word. > pl

$$Excel-Macros$$ problem

Dear All, i am suffer problem in excel, when i type any key then generate Urdu word. please resolve this. -- 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

Re: $$Excel-Macros$$ Problem - Tag in Cell

Hi I didnt get you by that, pl share sample file. Thanks On Sat, Aug 3, 2013 at 12:06 PM, Anil Saxena wrote: > > Dear Expert, > > How can remove the Tag in a Cell, becouse I want delimited. > -- > > *Anil Saxena* > > > -- > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be?

$$Excel-Macros$$ Problem - Tag in Cell

Dear Expert, How can remove the Tag in a Cell, becouse I want delimited. -- *Anil Saxena* -- 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

Re: $$Excel-Macros$$ Problem with searching through rows and their associated columns

can u share the sample file with us Regards Ashish On Thu, Jul 4, 2013 at 7:07 AM, Brian Yam wrote: > Dear All, > > I am new to VBA programming > I happen to need great and urgent help on a project that I am currently > working on > I would like to search through the worksheet, and find "N" or

$$Excel-Macros$$ Problem with searching through rows and their associated columns

Dear All, I am new to VBA programming I happen to need great and urgent help on a project that I am currently working on I would like to search through the worksheet, and find "N" or "TR" on row 6 Then, For every cell in the column of "N" or "TR" if all the cells are blank, then delete/ hide the

$$Excel-Macros$$ Problem with addresslocal property in setting chart series

Dear all I have the following code to set the name and x and y properties of a chart series. These need to refer to a certain worksheet (T1, T2, etc identified by the parameter Tsel) and to a certain range on these sheet. .SeriesCollection(nl).Name = "='T" & TSel & "'!" & Ce

Re: $$Excel-Macros$$ Problem in Line Graph

Hi, Thanks for you reply I tried that option too but I will not get graph when I do that and even I dont want to use this option as I am plotting multi graphs in different sheets. Regards, Chandra Shekar B On Thu, May 30, 2013 at 9:05 PM, xlstime wrote: > Hi Chander, > > Change Switch Row/Co

Re: $$Excel-Macros$$ Problem in Line Graph

Hi Chander, Change Switch Row/Column Right click in chart then go to select data then Switch Row/Column Hope it's fulfill your requirement . Enjoy Team XLS On Thu, May 30, 2013 at 8:02 PM, Chandra Shekar < chandrashekarb@gmail.com> wrote: > Hi, > > I have issue

$$Excel-Macros$$ Problem in Line Graph

Hi, I have issue with line graph *X axis title* and same is attached. In sheet1 I have only one record and X axis shows A2 & A3 but in Sheet2 I have many records and it shows value as per column 1. Kindly let me know what I am doing is correct or anything need to be changed Thanks in advance. R

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

Is it just this file which is slow or are all excel files slow? Is this file slow if you run it on another computer? What is the file extension? Xls, xlsb, xlsm,xlsb. What version of windows? Including whether it is 32 or 64 bit? What version of office? Also 32 or 64 How much memory does the com

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

But my bad time..even I copied the data which contains formula and formats into new sheet. Same problem I face I copied the cell which contains only the data... Prabhu R On May 23, 2013 9:41 PM, "Bé Trần Văn" wrote: > Maybe because your spreadsheet data using multiple functions, or select >

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

Maybe because your spreadsheet data using multiple functions, or select and delete the blank column on the right, select and delete the blank line underneath the sheet containing the data, if not all slow sluggish, the ultimate solution is a new file, open 1, copy each sheet and select Paste Specia

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 > files. > > > O

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

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

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 any changes to the file.Check also for version based compatibility issues because earlier version had lower data input and processing capabili

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

No david..that sheet contains no macros, even very less formula. Only the thing is some cells have formatted... Prabhu R On May 23, 2013 5:20 PM, "David Grugeon" wrote: > Also do you have macros which are run when changes are made to the sheets. > It may be possible to reorganise them so they r

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

Also do you have macros which are run when changes are made to the sheets. It may be possible to reorganise them so they run faster or are not triggered so readily. Regards David Grugeon On 23 May 2013 21:47, David Grugeon wrote: > Try setting the calculation to Manual. Then see if Cut and

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

Try setting the calculation to Manual. Then see if Cut and Paste still takes a lot of time. It could be that there are a lot of formulas having to be recalculated when there is a change to the worksheet. If this is identified as the cause you may be able to get a gain by redesigning hr worksheet

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

thanks vijay, lemme try this too. but my doubt is if already "Use all the processors on this computer" option is selected. then..? Regards, Prabhu R On 23 May 2013 16:48, P.VIJAYKUMAR wrote: > Respected Prabhu, > > Please go to excel options button and from there go to the advanced tab > an

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

Respected Prabhu, Please go to excel options button and from there go to the advanced tab and under that go to the formulas section.The third point will contain how many processors are used for excel calculations.check the radio button to use all the processors for calculations.This may boost up

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

Hi Abhishek : thanks for the idea. i will try this one. David : i am unable attach the file, because it is violation in our office. On 23 May 2013 13:39, David Grugeon wrote: > Can't guess without seeing the file. Can you attach it? > > Regards > David Grugeon > > > > On 23 May 2013 16:49,

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

Can't guess without seeing the file. Can you attach it? Regards David Grugeon On 23 May 2013 16:49, Prabhu Pinky wrote: > Hi experts, > I have one excel file. Size is below 1mb. Even though it is very slow > working in that file. If I do copy paste any single cell, it takes too much > time.

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

Not sure if this is your case but: Press F5 > Special > Objects and if Excel finds anything, press Delete. Might help. On Thu, May 23, 2013 at 12:19 PM, Prabhu Pinky wrote: > Hi experts, > I have one excel file. Size is below 1mb. Even though it is very slow > working in that file. If I do copy

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

Hi experts, I have one excel file. Size is below 1mb. Even though it is very slow working in that file. If I do copy paste any single cell, it takes too much time. What could be the reasons...? Prabhu R -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,

Re: $$Excel-Macros$$ Problem in conditional formatting *

Hi, I hope you are looking for the column "M". Please change the formula reference as "M:M" instead of "A". Regards, Saravanan R. On Wednesday, 13 February 2013 21:40:01 UTC+5:30, hilary lomotey wrote: > > > Hello > > > Pls see attached > > HTH > > > On Wed, Feb 13, 2013 at 12:44 PM, Ken

Re: $$Excel-Macros$$ Problem in conditional formatting *

Hello Pls see attached HTH On Wed, Feb 13, 2013 at 12:44 PM, Kenil Gala wrote: > [image: Boxbe] This message is eligible > for Automatic Cleanup! (keni...@yahoo.com) Add cleanup > rule

$$Excel-Macros$$ Problem in conditional formatting

 sorry forgot to attached the file in previous mail. Hi group, I am facing a small problem in conditional formatting. i am not able to set the same rules for the entire coloum. Pls find the file attached.   Thanks in adv. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna

$$Excel-Macros$$ Problem in conditional formatting

Hi group, I am facing a small problem in conditional formatting. i am not able to set the same rules for the entire coloum. Pls find the file attached.   Thanks in adv. -- 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$$ Problem with Macro - need review by expert

I have a simple excel sheet (attached file) The file is sorted by date and it shows information about deposits made in a day. Sometimes a deposit might have more than 1 transaction, sometimes it is just one transaction. The data is as follows: Date, Unit ID, Amount & Check number (there othe

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, >> >> I have created a name range "List_Matters"

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

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$$ Problem with excel

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

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

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

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

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$$ Problem with excel

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$$ 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. ListBox - lstLookup > > if user cha

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

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

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$$ problem with indirect function

thanks a lot Noorain this is what I was looking for Pawel From: NOORAIN ANSARI To: excel-macros@googlegroups.com Sent: Monday, May 28, 2012 9:19 AM Subject: Re: $$Excel-Macros$$ problem with indirect function On Mon, May 28, 2012 at 1:48 PM, NOORAIN

Re: $$Excel-Macros$$ problem with indirect function

On Mon, May 28, 2012 at 1:48 PM, NOORAIN ANSARI wrote: > Dear Pawel, > > Please try this one. > > =INDIRECT(ADDRESS(MATCH($B6,*INDIRECT(G$4&"!$B:$B")*,0),12,1,0,G$4),FALSE) > > -- > Thanks & regards, > Noorain Ansari > www.noorainansari.com > www.excelmacroworld.blogspot.com > > > On M

Re: $$Excel-Macros$$ problem with indirect function

Dear Pawel, Please try this one. =INDIRECT(ADDRESS(MATCH($B6,*INDIRECT(G$4&"!$B:$B")*,0),12,1,0,G$4),FALSE) -- Thanks & regards, Noorain Ansari www.noorainansari.com www.excelmacroworld.blogspot.com On Mon, May 28, 2012 at 3:42 AM, pawel lupinski wrote: > Dear All, > I have prob

Re: $$Excel-Macros$$ problem with indirect function

u can use vlookup ... Regards, Anil Gawli On Mon, May 28, 2012 at 3:42 AM, pawel lupinski wrote: > Dear All, > I have problem with indirect function in this case is working fine (see > attachment), but if you can show me some extra features I'll be appreciated. > Regards, > Pawel > > -- > FORUM

Re: $$Excel-Macros$$ problem in copy paste

:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] *On Behalf Of *yasir_shahjee > *Sent:* Thursday, May 03, 2012 1:03 AM > *To:* excel-macros@googlegroups.com > *Subject:* Re: $$Excel-Macros$$ problem in copy paste > > ** ** > > yes i have inst

RE: $$Excel-Macros$$ problem in copy paste

1:03 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ problem in copy paste yes i have installed On Tue, May 1, 2012 at 7:10 AM, Asa Rossoff wrote: Hi Yasir, Do you have Skype installed? See http://answers.microsoft.com/en-us/office/forum/office_2010-excel/text-loses -forma

Re: $$Excel-Macros$$ problem in copy paste

a-4d2b-874f-792d34d16c61?auth=1for > more details and fix. > > > ** ** > > Asa > > ** ** > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] *On Behalf Of *yasir_shahjee > *Sent:* Monday, April 30, 2012 5:00 AM >

RE: $$Excel-Macros$$ problem in copy paste

-macros@googlegroups.com] On Behalf Of yasir_shahjee Sent: Monday, April 30, 2012 5:00 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ problem in copy paste Dear Members, Hope you all are fine, i have attached image file, i have problem when i paste any items. i have re install

Re: $$Excel-Macros$$ Problem to filter in pivot table

Hi Ashish, In the pivot you can add one more entry of "Stock" in row as well > De-select "0" and then remove "Stock" from row again. I think this is what you are looking for. Regards Shekhar Sharma On Tue, Apr 24, 2012 at 10:04 AM, Ashish Bhalara wrote: > Dear expert, > > I need the filter in

Re: $$Excel-Macros$$ Problem with Format Change Upon Data Validation Change Event

et(1, 0).Resize(266).NumberFormat = "0.00%" End Select End If End Sub Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com From: Tiffany Sent: Thursday, March 29, 2012 9:52 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Problem with Format C

Re: $$Excel-Macros$$ Problem with Format Change Upon Data Validation Change Event

Why not simply use conditional format? Sam Mathai Chacko On Thu, Mar 29, 2012 at 8:22 PM, Tiffany wrote: > Hi - > > I'm a little new to VBA but have managed to put together a macro that half > achieves its intended purpose. > > Depending on what is chosen in a data validation cell (any cell in

$$Excel-Macros$$ Problem with Format Change Upon Data Validation Change Event

Hi - I'm a little new to VBA but have managed to put together a macro that half achieves its intended purpose. Depending on what is chosen in a data validation cell (any cell in range S8 to AL8), the macro is supposed to change the format of 296 cells below the data validation cell: - If

Re: $$Excel-Macros$$ problem with setfocus

Thank you Noorain Bhai On Fri, Feb 17, 2012 at 2:59 PM, NOORAIN ANSARI wrote: > Dear Shankar, > > Please try it.. > > Private Sub TextBox2_Enter() > If TextBox1.Text = "" Then > MsgBox "Mandatory Field", vbQuestion + vbOKOnly, "Alert" > TextBox1.SetFocus > Else > TextBox2.SetFocus > End If > End

$$Excel-Macros$$ problem with setfocus

Dear Experts I am attaching an userform with 2 textboxes. While on exit from the first textbox I have given a msgbox alert for not keeping the box empty. But the setfocus event is not working for it. Kindly guide me. regards shankar sb -- FORUM RULES (986+ members already BANNED for violation

Re: $$Excel-Macros$$ Problem with Sumifs formula

Hi Kalyan, Try the below formula. =SUMPRODUCT((TRIM(A2:A37)=TRIM(F11))*(TRIM(B2:B37)=TRIM(G7))*(LEFT(TRIM(C2:C37),3)=LEFT(TRIM(G8),3))*(--MID(TRIM(C2:C37),FIND(" ",TRIM(C2:C37))+1,255)>=--MID(TRIM(G8),FIND(" ",TRIM(G8))+1,255))*(--MID(TRIM(C2:C37),FIND(" ",TRIM(C2:C37))+1,255)<=--MID(TRIM(G9),FIN

Re: $$Excel-Macros$$ Problem with Sumifs formula

Both are working perfectly. Thank u Viper Thanks a lot Noorain On Fri, Sep 16, 2011 at 5:48 PM, NOORAIN ANSARI wrote: > Dear Kalyan, > > Please see attached sheet.. > > =SUMIFS($E$2:$E$37,$A$2:$A$37,G11,$B$2:$B$37,H7,$C$2:$C$37,">="&INT(RIGHT(H8,LEN(H8)-FIND(" > ",H8,1))),$C$2:$C$37,"<="&INT(

Re: $$Excel-Macros$$ Problem with Sumifs formula

Dear Kalyan, Please see attached sheet.. =SUMIFS($E$2:$E$37,$A$2:$A$37,G11,$B$2:$B$37,H7,$C$2:$C$37,">="&INT(RIGHT(H8,LEN(H8)-FIND(" ",H8,1))),$C$2:$C$37,"<="&INT(RIGHT(H9,LEN(H9)-FIND(" ",H9,1 -- Thanks & regards, Noorain Ansari *http://excelmacroworld.blogspot.com/*

Re: $$Excel-Macros$$ Problem with Sumifs formula

Dear Kalyan why don't you use * =SUMPRODUCT(($A$2:$A$37=F11)*($B$2:$B$37=$G$7)*(--SUBSTITUTE(C2:C37,"MOC","")>=--SUBSTITUTE(G8,"MOC",""))*(--SUBSTITUTE(C2:C37,"MOC","")<=--SUBSTITUTE(G9,"MOC",""))*$D$2:$D$37) * pfa -- *Great day,* *viper * On Fri, Sep 16, 2011 at 4:11 PM, Kal xcel wrote:

$$Excel-Macros$$ Problem with Sumifs formula

Dear Experts, I am facing a problem when using sumifs formula, not getting desired result. Plase help me to rectify the problem or better solution. Thanks in advance -- *Kalyan Chattopadhyay* *Executive Sales Coordinator* *R. S. H. Pvt. Ltd.* -- ---

Re: $$Excel-Macros$$ problem with cell width in a workbook

m:* Shankar Bheema > *Sent:* Wednesday, September 07, 2011 11:33 PM > *To:* excel-macros@googlegroups.com > *Subject:* Re: $$Excel-Macros$$ problem with cell width in a workbook > > good morning Noorain > > I tried with your example sheet. But it is fitting the cell width jus

Re: $$Excel-Macros$$ Problem extracting data from multiple columns

Why cant i attach to this On Sep 5, 3:04 pm, "dguillett1" wrote: > Post a file > > > > -Original Message- > From: Andy McGooner > Sent: Monday, September 05, 2011 7:56 AM > To: MS EXCEL AND VBA MACROS > > Cc: amcni...@jaguarlandrover.com > Subject: $$Excel-Macros$$ Problemextractingd

Re: $$Excel-Macros$$ problem with cell width in a workbook

NO can do. Cell width for the entire column must be the same. You can merge cells but NO one suggests that so maybe format to WRAP and raise the height of the row From: Shankar Bheema Sent: Wednesday, September 07, 2011 11:33 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros

Re: $$Excel-Macros$$ problem with duplication of data

I tried with this code. But it is not stopping the entry of the duplicate row with the same file number. file numbers may be given consequently 1,2,3 ., if we enter file number 1 for twice, it would fire msgbox that it already exists. pls provide solution On Wed, Sep 7, 2011 at 8:03 PM, m

Re: $$Excel-Macros$$ problem with cell width in a workbook

good morning Noorain I tried with your example sheet. But it is fitting the cell width just like the Format-->Autofit option in the excel. But what I need is, the particular cells containing the red font has to be fit to their text width and the following column width may left as they are. sup

Re: $$Excel-Macros$$ problem with duplication of data

thank you so much saber On Wed, Sep 7, 2011 at 8:03 PM, mohd saber wrote: > Hi Shankar, > > Please find the below updated data for the command file > > Private Sub CommandButton1_Click() > ActiveWorkbook.Sheets("Employee Details").Activate > Range("A1").Select > Do > >If IsEmpty(ActiveCell)

Re: $$Excel-Macros$$ problem with duplication of data

Hi Shankar, Please find the below updated data for the command file Private Sub CommandButton1_Click() ActiveWorkbook.Sheets("Employee Details").Activate Range("A1").Select Do If IsEmpty(ActiveCell) = False Then If activecell.value = txtfileno.value Then ActiveCell.Offset(0, 1) = txtname.Te

  1   2   3   >