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

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 4

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 wrote: > Can someone please help me to guide to filter excluding particular > blanks. Cur

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", Qualit

$$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 ActiveSheet.Range("$A$9:$U$2

$$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 =NOT(E

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, 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 written VBA modules

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

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

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:= _ xlQualit

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" wrote: > Sub test() > > Dim myarray As Variant > Dim i As Long > myarray = Array("Apple", "Orange", "Peer") > > > For i = LBound(myarray) To UBound(

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 Docume

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 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)", "MANESAR(HR)", "ROHAD(

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)

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