$$Excel-Macros$$ Macro Single code require for if condtion

Dear All, Good Afternoon, I have made below code ... I have one doubt in below code. for example Hisar. I have mentioned that if cell contain below HSR-CRD(HR) HSR-HRD(HR) HSR-JMS(HR) HSR-VDJS(HR) HSR-JINDAL HOUSE Then output must be Hisar but I have done it with different if condition ..

Re: $$Excel-Macros$$ Macro Single code require for if condtion

You could replace your If/ElseIf/Endif statement with a Select Case Statement:   Select Case Selection.Offset(0, 2).Value     Case GURGAON(DELHI-NCR), MANESAR(HR), ROHAD(HR)     Selection.Offset(0, 12).Value = Gurgoan-Rohad-Pathredi     Case HSR-CRD(HR), HSR-GET HOSTEL, HSR-HRD(HR), HSR-JINDAL

Re: $$Excel-Macros$$ Macro Single code require for if condtion

Thanks a lot Sir.. Perfect! Regards, Prafull Jadhav 9920553518 On 4 March 2014 17:21, Paul Schreiner schreiner_p...@att.net wrote: You could replace your If/ElseIf/Endif statement with a Select Case Statement: Select Case Selection.Offset(0, 2).Value Case GURGAON(DELHI-NCR),

Re: $$Excel-Macros$$ VBA to change number

Sub test() Dim myarray As Variant Dim i As Long myarray = Array(Apple, Orange, Peer) For i = LBound(myarray) To UBound(myarray) ActiveSheet.Range(c5).Value = myarray(i) ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, Filename:=C:\Documents and Settings\Ashish Koul\My Documents\

Re: $$Excel-Macros$$ VBA to change number

Thanks Ashish Can myarray be referring to a rangename call Fruits? Cos if to list out its a very long list. On 5 Mar 2014 00:45, ashish koul koul.ash...@gmail.com wrote: Sub test() Dim myarray As Variant Dim i As Long myarray = Array(Apple, Orange, Peer) For i = LBound(myarray) To

Re: $$Excel-Macros$$ VBA to change number

try ths Sub test() Dim CL As Range Dim i As Long For Each CL In Range(fRUITS) ActiveSheet.Range(c5).Value = CL.Value ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, Filename:=C:\Documents and Settings\Ashish Koul\My Documents\ CL.Value .pdf, Quality:= _

$$Excel-Macros$$ VBA to change number

Can someone kindly help me with a macro please. I have in a list 5 items: Apple Orange Pear Figs Mango And I have in another sheet in cell C5, I want the macro to put Apple into it, send file to PDF, then put Orange into C5, send file to PDF,then put Pear into C5, send to PDF, and loop till

$$Excel-Macros$$ Link Custom Toolbar with a file

I am using Excel 2003 on Windows 7 Pro 64 bit When I open a file I need to call up an associated Custom Toolbar. I have written VBA modules to do this and they work OK. However when I reduce the application to the TaskBar (pressing_), then retrieve it by clicking it's Icon on the TaskBar, it

Re: $$Excel-Macros$$ Link Custom Toolbar with a file

You could MAYBE try RECORD MACRO to manually invoke the toolbar, then look at the auto-generated code for clues. On 4 March 2014 18:19, dwbowye...@gmail.com wrote: I am using Excel 2003 on Windows 7 Pro 64 bit When I open a file I need to call up an associated Custom Toolbar. I have

$$Excel-Macros$$ Find the count of city without blank

Hello frnd, please help to m solved this question. city patna delhi punjab mumbai patna delhi punjab mumbai patna delhi punjab mumbai value 34 45 56 77 34 45 33 66 44 O/p City name choose any city name Total count without Blank -- Are you =EXP(E:RT) or

$$Excel-Macros$$ Record Macro to Filter out blanks

Can someone please help me to guide to filter excluding particular blanks. Currently my recorded macro end up listing out all those I wanna include instead. Eg. in my fliter list, I have 0, 1 and 2 and I only wanna filter out blanks. The macros shows

RE: $$Excel-Macros$$ VBA to change number

Dear Ashish It works well and produced the 3 PDF files into the folder created. But there are 2 problems. 1. It will still says macro error and debug will bring me to the highlighted ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, Filename:=C:\Soa\ CL.Value .pdf, Quality:= _

Re: $$Excel-Macros$$ Record Macro to Filter out blanks

Hi Elaine, Replace with Criteria1:= Note: For Blanks use the above. If you want to exclude some thing just use ** before the things. Regards, Ganesh N On Wed, Mar 5, 2014 at 5:11 AM, elaine chong christ...@gmail.com wrote: Can someone please help me to guide to filter excluding particular

Re: $$Excel-Macros$$ Find the count of city without blank

=SUMPRODUCT(($E$6:$P$6=delhi)*($E$7:$P$7)) On Wed, Mar 5, 2014 at 3:35 AM, Rajeev Ranjan 06raj...@gmail.com wrote: Hello frnd, please help to m solved this question. city patna delhi punjab mumbai patna delhi punjab mumbai patna delhi punjab mumbai value 34 45 56 77 34 45 33 66 44

$$Excel-Macros$$ Re: how to crack Excel VBA password

There are a lot of manual ways n which you can reset VBA passwords but it seems like you don’t have access to this option because in your case nobody remembers passwords. That’s really awful but you don’t have to panic as I have a recommendation for this free trial version which I hope can