Re: $$Excel-Macros$$ Query for If condition or VBA

Hello, Please solve this query!!! -- Thanks Regards *Sunil Kumar Yadav* * Sr. Executive - *MIS (Billing Deptt.) Skype ID: sunil.yadav7186 On Tue, Mar 24, 2015 at 5:27 PM, Sunil Kumar Yadav sk.yadav7...@gmail.com wrote: Dear ​ ​Team, PFA file and check my query. ​ -- Thanks Regards

Re: $$Excel-Macros$$ Query for If condition or VBA

can you explain one example.. On Wed, Mar 25, 2015 at 1:45 PM, Sunil Kumar Yadav sk.yadav7...@gmail.com wrote: Hello, Please solve this query!!! -- Thanks Regards *Sunil Kumar Yadav* * Sr. Executive - *MIS (Billing Deptt.) Skype ID: sunil.yadav7186 On Tue, Mar 24, 2015 at 5:27 PM,

Re: $$Excel-Macros$$ Query for If condition or VBA

check formula in col E, If there are more than 2 case of overlap then 1st will be shown as ok second will be as error. In case it is more than 2 case of overlap then 1st will be shown as ok rest all will be shown as error.. Cheers!! On Wed, Mar 25, 2015 at 2:01 PM, Vaibhav Joshi v...@vabs.in

Re: $$Excel-Macros$$ Query for If condition or VBA

Awesome Sir :-) and thanks -- Thanks Regards *Sunil Kumar Yadav* Skype ID: sunil.yadav7186 On Wed, Mar 25, 2015 at 2:13 PM, Vaibhav Joshi v...@vabs.in wrote: check formula in col E, If there are more than 2 case of overlap then 1st will be shown as ok second will be as error. In case it

Re: $$Excel-Macros$$ Abridged summary of excel-macros@googlegroups.com - 4 updates in 3 topics

Hi I have a simple question I'm trying to declare a public array myarray which can be used by either of PublicArrayExample() TestPublicArrayExample(). But while executing the macro I'm facing compiler error. Can you please what is wrong with my declaration. Please see the attached files On Tue,

Re: $$Excel-Macros$$ Query in code of email send with attachment from excel

Replace .addattachment rngAttach1.Value with If Dir(rngAttach1.Value) Then .addattachment rngAttach1.Value End If Cheers!! On Tue, Mar 24, 2015 at 9:05 AM, Ashish Bhalara ashishbhalar...@gmail.com wrote: When value of path is null, function by default set 0 in cell F2, so I tried below

Re: $$Excel-Macros$$ Database for concert ticket sales

Hi can you share website link? On Sat, Mar 21, 2015 at 10:48 PM, ldenholl l.denh...@gmail.com wrote: Hi all, I'm an intermediate Excel/Access user and have an inquiry for you all. You know how when you buy tickets for a big event online and you can select which seats you want in the

Re: $$Excel-Macros$$ Re: How to declare public array

Check this for an alternate way... If you wan all code to remained in Sheet module then you can take only Public variable in separate Module. Cheers!! On Wed, Mar 25, 2015 at 4:48 PM, Vaibhav Joshi v...@vabs.in wrote: Hi your method is correct, only error you did is u showed it in worksheet

$$Excel-Macros$$ Combining a Mid Function and Right Function into one statement

I need to combine to functions into one. I need to trim off the F_ from the left side of the column and I need to look if there is a _F on the right side of the column. Example of data I need to trim F_ACQ_SUP_F Would need to look like this cleaned up ACQ_SUP I have the function working to

Re: $$Excel-Macros$$ Abridged summary of excel-macros@googlegroups.com - 4 updates in 3 topics

try this... Option Explicit Dim myarray(1) As Variant Sub PublicArrayExample() 'Dim myarray(2) As String 'Fill the array MyArray with values. myarray(0) = Hello myarray(1) = Goodbye 'Run the TestPublicArrayExample macro to display MyArray. Call TestPublicArrayExample End Sub Sub

Re: $$Excel-Macros$$ How to declare public array

Try this: Option Explicit Dim myarray(1) As Variant Sub PublicArrayExample() 'Dim myarray(2) As String 'Fill the array MyArray with values. myarray(0) = Hello myarray(1) = Goodbye 'Run the TestPublicArrayExample macro to display MyArray. Call TestPublicArrayExample End Sub Sub

$$Excel-Macros$$ How to declare public array

Hi I have a simple question I'm trying to declare a public array myarray which can be used by either of PublicArrayExample() TestPublicArrayExample(). But while executing the macro I'm facing compiler error. Can you please what is wrong with my declaration. Please see the attached files --

$$Excel-Macros$$ Re: How to declare public array

Thanks a lot. It definitely solves my problem. Can you please tell me how to declare array using public keyword. On Wednesday, March 25, 2015 at 4:10:48 PM UTC+5:30, Rohit Jadhav wrote: Hi I have a simple question I'm trying to declare a public array myarray which can be used by either of

Re: $$Excel-Macros$$ Re: How to declare public array

Hi your method is correct, only error you did is u showed it in worksheet module (which is pvt module by default), you need to create separate module and add code in to it.. See attachment. Cheers!! On Wed, Mar 25, 2015 at 4:19 PM, Rohit Jadhav rohitj...@gmail.com wrote: Thanks a lot. It

Re: $$Excel-Macros$$ Combining a Mid Function and Right Function into one statement

Hi Mychele, PFA Regards Ashish -- 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, accurate thread titles. Poor thread titles, like

Re: $$Excel-Macros$$ Combining a Mid Function and Right Function into one statement

Hi, Use Text to Column Method separated by _ after that use concatenate formula to combined them. Thanks Veera On Thu, Mar 26, 2015 at 8:15 AM, Ashish Kumar kumar.ashish...@gmail.com wrote: Hi Mychele, PFA Regards Ashish -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you