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 wrote: > Hi Mychele, > > PFA > > > > Regards > Ashish > > -- > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? 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

$$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 c

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 wrote: > Hi > > your method is correct, only error you did is u showed it in worksheet > module

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

Hi can you share website link? On Sat, Mar 21, 2015 at 10:48 PM, ldenholl 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 process of buying?

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 wrote: > When value of path is null, function by default set 0 in cell F2, so I > tried below code to avoid error on

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 wrote: > Thanks a lot. It definitely solves my p

$$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

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 TestPublicArr

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 TestPublicA

$$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 -- Wi

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 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 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 is more

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 wrote: > c

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 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, Sunil Kumar Y

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 wrote: > Dear > ​ ​Team, > > PFA file and check my query. > > ​ > -- > Thanks & Regards > *Sunil Kumar