Re: $$Excel-Macros$$ Port VBA code to VB.net

2015-04-14 Thread Paul Schreiner
Your question really leaves out too much to provide an answer... By Definition,  VBA is Visual Basic for Applications.It's Visual Basic, plus specific objects/methods/procedures specific to the Application.VBA for Excel has things to access things like Workbooks, Worksheets, and Cells.But it DOES

$$Excel-Macros$$ formula required in both the sheets

2015-04-14 Thread Rajesh Agarwal
dear sir formula required in both the sheets as per mentioned in sheet 1. -- *Rajesh Kumar Agarwal* *9811063001* -- 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$$ how to get search result using add-in (.xlam) => text box result from saved .xlam file

2015-04-14 Thread adityagalaxy1985
Dear Experts, from a long time, I am trying to create code finders list (RTO,STD,PIN) get result from .xlam text box which search result data from another file (ex; D drive AllCData.xlam) but not succeed my requirement is 1 textbox(search box) in add-in when i put value and enter it will sear

Re: $$Excel-Macros$$ Re: Working with Merged cells : Sumproduct/Countifs

2015-04-14 Thread Vaibhav Joshi
Check this... Add two helper column & see formula in Green, i have tested for both of sample data given by you & its working.. Cheers!! On Tue, Apr 14, 2015 at 5:39 PM, Chandra Shekar < chandrashekarb@gmail.com> wrote: > Hello Mandeep, > > Formula does not work when Column B is General Fie

Re: $$Excel-Macros$$ Port VBA code to VB.net

2015-04-14 Thread My Excel
sir, Pls share update of this thread how to convert vba to .exe thanks in advance On Thu, Oct 9, 2014 at 3:27 PM, Anil Gawli wrote: > Dear Rupesh, > > Pls share the file. > > Warm Regards, > Gawli Anil. > > On Thu, Oct 9, 2014 at 1:50 PM, Rupesh Patil > wrote: > > Hello Expert, > > > > In my

Re: $$Excel-Macros$$ Re: Working with Merged cells : Sumproduct/Countifs

2015-04-14 Thread Chandra Shekar
Hello Mandeep, Formula does not work when Column B is General Field(Mix of Text & Number format). Please find attached sheet. Regards, Chandru On Tue, Apr 14, 2015 at 4:08 PM, Chandra Shekar < chandrashekarb@gmail.com> wrote: > Hello Mandeep, > > Thanks for the formula. is there any way we

Re: $$Excel-Macros$$ Re: Working with Merged cells : Sumproduct/Countifs

2015-04-14 Thread Chandra Shekar
Hello Mandeep, Thanks for the formula. is there any way we can work on merged cells? On Tue, Apr 14, 2015 at 4:00 PM, Mandeep Baluja wrote: > unmerge your cells and Fill it down to create a helper and use this > formula. > > Regards, > Mandeep Baluja > > > On Tuesday, April 14, 2015 at 2:21:19

$$Excel-Macros$$ Re: Working with Merged cells : Sumproduct/Countifs

2015-04-14 Thread Mandeep Baluja
unmerge your cells and Fill it down to create a helper and use this formula. Regards, Mandeep Baluja On Tuesday, April 14, 2015 at 2:21:19 PM UTC+5:30, Chandru wrote: > > Hello, > > PFA file and am trying to get counts based on merged cells. I have given > comments in Column G. Could you help

$$Excel-Macros$$ Re: Copy Paste Macro

2015-04-14 Thread Avinash
Sorry For the delayed reply. The name of that application is "True count" its third party application. Thanks. On Sunday, April 5, 2015 at 4:52:50 AM UTC-4, Mandeep Baluja wrote: > what is the name of your application from which you're retrieving your > data. > > On Saturday, March 28, 20

$$Excel-Macros$$ Working with Merged cells : Sumproduct/Countifs

2015-04-14 Thread Chandra Shekar
Hello, PFA file and am trying to get counts based on merged cells. I have given comments in Column G. Could you help me on this. Regards, Chandru -- 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 @ htt

$$Excel-Macros$$ Re: Multiple Sheets data consolidation into one sheet VBA

2015-04-14 Thread TAWHID
Thanks a lot! while waiting I just did below code, and working which is like your one. With cs .Range("A1").CurrentRegion.sort _ Key1:=.Range("B2"), Order1:=xlAscending, _ Key2:=Range("G2"), Order2:=xlDescending, _ Header:=xlYes End With Thanks agian! On Friday, 10 Apri

$$Excel-Macros$$ Re: Multiple Sheets data consolidation into one sheet VBA

2015-04-14 Thread Mandeep Baluja
Put this in your code before end keyword. ActiveWorkbook.Worksheets("Consolidate").UsedRange.Sort key1:=ActiveWorkbook.Worksheets("Consolidate").Range("b:b"), order1:=xlAscending, Header:=xlYes On Tuesday, April 14, 2015 at 11:23:35 AM UTC+5:30, TAWHID wrote: > > Hi Vaibhav, > I was > > Wond