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

2015-01-02 Thread Suhas Chavan
Hi All Can anybody advised me what is DPB as i am not able to search this string or steps to recover VBA password Suhas On Friday, February 19, 2010 6:54:12 PM UTC+4:30, sunil sasidharan wrote: > > *Hi All,* > > *I need to edit an excel macro file but the VBA coing is protected and > nobody

$$Excel-Macros$$ Macro for Autofilter

2015-01-02 Thread Ashish Bhalara
Dear experts, Please provide Macro for autofilter for criteria of Date range & exact matching of code as per in attached sheet. Column of C contain date and filter as per range given in J1 to J2. Second filter on column D with exact match in cell J4. Regards. Ashish Bhalara 9624111822 P*Please do

Re: $$Excel-Macros$$ Function help for output of particular list from different Input data.

2015-01-02 Thread sach so
Hi, Swapnil thanks! for the work. You r like a my big brother. Once again thanks. Regards, Sachin On Friday, January 2, 2015 6:15:10 PM UTC+5:30, Swapnil Palande wrote: > > Hi, > > Attached is the macro excel. Press Ctrl+Shift+q to run macro. > > Regards, > > Swapnil > > On Fri, Jan 2, 2015 at 1

Re: $$Excel-Macros$$ Function help for output of particular list from different Input data.

2015-01-02 Thread Swapnil Palande
Hi, Attached is the macro excel. Press Ctrl+Shift+q to run macro. Regards, Swapnil On Fri, Jan 2, 2015 at 11:45 AM, sach so wrote: > Hi, > Swapnil it works. Thank you very very much. Good job done. > > Can u do this by VBA or micro, If I have data in one sheet, for Input i > have second sheet

Re: $$Excel-Macros$$ Error using variables in Cells(x,y)

2015-01-02 Thread Vaibhav Joshi
Hi This CheckRow = N.Row - 1 will result zero for first row hence error since there is no cell with 0 row & 1 column .. Try this... Sub TestCode() Dim CheckRow As Integer For Each N In Range("A1:A5") CheckRow = N.Row MsgBox Cells(CheckRow, 1) Next N End Sub or Sub TestCode()

$$Excel-Macros$$ Error using variables in Cells(x,y)

2015-01-02 Thread MLT
I feel like this should be very easy but somehow I'm stumped on why the error on "MsgBox Cells(CheckRow,1)". It works if I use "MsgBox Cells(1,1)" for example. Help please? Sub TestCode() Dim CheckRow As Integer For Each N In Range("A1:A5") CheckRow = N.Row - 1 MsgBox Cel

Re: $$Excel-Macros$$ Pull date value from cell

2015-01-02 Thread Vaibhav Joshi
Cheers!! + *I did not do this for you. God is here working through me for you.* On Fri, Jan 2, 2015 at 4:26 PM, MLT wrote: > > Thank you! > > -- > 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 @ >

Re: $$Excel-Macros$$ Pull date value from cell

2015-01-02 Thread MLT
Thank you! -- 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 Please Help, Urgent, N