Re: $$Excel-Macros$$ User Defined formula in Excel

Hi Rajan, Due to some reason I was unable to access internet so i could not check my emails. I used the below codes and it is working fine. It was just an example to understand how to create user defined formulas in excel and make it permanent for any excel files. Thank you so much for time and

RE: $$Excel-Macros$$ how to delete multiple row & columns

Thanks a lot for the solution. Can you tell me how shall I use this? I mean How shall I paste this code so that macro works.. & hope it will delete only blank cells on the right & bottom !!!-:) From: excel-macros@googlegroups.com [excel-macros@googlegroups.com] O

$$Excel-Macros$$ Job

*Experience required for the Job:* 2.5 - 5 years *Job Location:* Kolkata *Dear Candidate,* Hi, Greetings for the day! Our records show that you are an experienced IT professional with experience in VBA which matches to our requirement. This experience is relevant to one of my current openings. A

Re: $$Excel-Macros$$ how to delete multiple row & columns

A little correction Sub cleanrowsandcolumnsSAS() lr = Cells.Find("*", Cells(Rows.Count, Columns.Count) _ , , , xlByRows, xlPrevious).Row *+ 1* lc = Cells.Find("*", Cells(Rows.Count, Columns.Count) _ , , , xlByColumns, xlPrevious).Column *+ 1* Application.EnableEvents = Fal

Re: $$Excel-Macros$$ Need a Help in Macro

Sub hide_sheets() Dim a As String a = ActiveSheet.Name Sheets(ActiveSheet.Shapes(Application.Caller).TextFrame.Characters.Text).Activate Sheets(a).Visible = False End Sub On Tue, Aug 23, 2011 at 6:31 PM, Prakash Paul wrote: > Hi Prasad, > > Try this attached file. > > Regards > Prakash Pau

Re: $$Excel-Macros$$ Very slow performance by Excel file

Hey AMit, 10 tips for working more efficiently in Excel http://www.techrepublic.com/blog/10things/10-tips-for-working-more-efficiently-in-excel/203 On Tue, Aug 23, 2011 at 4:56 PM, Amit Desai (MERU) wrote: > I have more than 1000 formulaes...spreaded in 4 sheets...pls suggest > solutions.. > > B

Re: $$Excel-Macros$$ Very slow performance by Excel file

I will take a look at your file dguillett1 @gmail.com -Original Message- From: Amit Desai (MERU) Sent: Tuesday, August 23, 2011 6:26 AM To: excel-macros@googlegroups.com Subject: RE: $$Excel-Macros$$ Very slow performance by Excel file I have more than 1000 formulaes...spreaded in 4 sh

RE: $$Excel-Macros$$ Very slow performance by Excel file

Is it possible to write a macro..so that when I click on refresh, macro will 1) place the formula in each respective cells (all 1000 formulas should be in its place) 2) calculate the numbers, 3) save the file. Best Regards, Amit Desai From: Amit Desai (MERU) [mailto:amit.de...

Re: $$Excel-Macros$$ Need help in maro

Or simply use data validation with a list of sheet names and select the one to show and tie to a worksheet_Change event From: Rajan_Verma Sent: Tuesday, August 23, 2011 2:00 AM To: excel-macros@googlegroups.com Subject: RE: $$Excel-Macros$$ Need help in maro Hi Prasad, Ashish’s Code working f

Re: $$Excel-Macros$$ how to delete multiple row & columns

If I understand your request, you may like this. It also saves the file Sub cleanrowsandcolumnsSAS() lr = Cells.Find("*", Cells(Rows.Count, Columns.Count) _ , , , xlByRows, xlPrevious).Row lc = Cells.Find("*", Cells(Rows.Count, Columns.Count) _ , , , xlByColumns, xlPrevious).Column Application.Ena

RE: $$Excel-Macros$$ Very slow performance by Excel file

Done this ...but system is still slow.. Best Regards, Amit Desai From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Prakash Paul Sent: Tuesday, August 23, 2011 5:03 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Very slow performance by E

Re: $$Excel-Macros$$ Very slow performance by Excel file

Hi Amit, Try this method. Go to the task manager and set the excel.exe to high priority. Regards Prakash Paul On Tue, Aug 23, 2011 at 4:56 PM, Amit Desai (MERU) wrote: > I have more than 1000 formulaes...spreaded in 4 sheets...pls suggest > solutions.. > > Best Regards, > Amit Desai > > Assis

$$Excel-Macros$$ Need a Help in Macro

Hi Rajan, Thanks for the Macro, but i need somethig like this : I have 5 TAB's in the first TAB named with Sheet1 i have Control as Sheet2 the point here is once i work on my sheet1 then i need to go to Sheet2 so i have placed a control as sheet2 (something like hyperlink)and once i click on shee

RE: $$Excel-Macros$$ Very slow performance by Excel file

I have more than 1000 formulaes...spreaded in 4 sheets...pls suggest solutions.. Best Regards, Amit Desai Assistant Manager, Fleet MIS (Corporate) Desk No.: 022 40520129 Cell No.: 9867232534 -Original Message- From: Amit Desai (MERU) [mailto:amit.de...@merucabs.com] Sent: Saturday, Augus

RE: $$Excel-Macros$$ flash file insert and auto play in excel 2007

C:\Desktop\Filname.swf From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Satish Bandaru Sent: Tuesday, August 23, 2011 3:55 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ flash file insert and auto play in excel 2007 Hi Rjan Thanks

RE: $$Excel-Macros$$ MIS executive needed

Hi Group, Recd few Resumes from the group members & have forwarded resume to my HR Does any girls interested for this? Just want to balance ratio & for no other reason -:) Best Regards, Amit Desai -Original Message- From: Amit Desai (MERU) [mailto:amit.de...@merucabs.com] Sent: Thursda

Re: $$Excel-Macros$$ flash file insert and auto play in excel 2007

Hi Rjan Thanks for ur coperation. My C drive named as cho. if i write the url c:\ desktop\filename or cho(c):\desktop\filname ? Thankq once again -- -- Some important links for excel users: 1. Follow us on TWITTER fo

Re: $$Excel-Macros$$ Yahoo query

Hi Nitesh, Please try through Below link.. http://in.answers.yahoo.com/question/index?qid=20091213063510AA3Sw3m On Tue, Aug 23, 2011 at 3:14 PM, Kandade, Nitesh wrote: > Hi All, > > ** ** > > I want to recover my yahoo password I forgot the security question as well > as the password. Nee

$$Excel-Macros$$ Yahoo query

Hi All, I want to recover my yahoo password I forgot the security question as well as the password. Need help Thanks & Regards, Nitesh Kandade Jr. Analyst OneWest Bank, FSB Office: (213) 337-3653 Ext.: 68361 nitesh.kand...@owb.com This message contains informati

Re: $$Excel-Macros$$ Automatic Birth Day Outlook Mail Message

Thanks ashish for reply but this is through pressing button i want whenever birth date matches system date it automatically forward the mail. image is a Outlook Template Data will be inserted between that. Thanks Again Pankaj On Mon, Aug 22, 2011 at 9:22 PM, ashish koul wrote: > http://akoul.

RE: $$Excel-Macros$$ flash file insert and auto play in excel 2007

Hi Satish Please send your SWF File . From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Satish Bandaru Sent: Tuesday, August 23, 2011 1:08 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ flash file insert and auto play in excel 2007

Re: $$Excel-Macros$$ flash file insert and auto play in excel 2007

i got the help in blog. Thanq rajan -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.co

Re: $$Excel-Macros$$ flash file insert and auto play in excel 2007

hi Rajan the link is not working and asking to go blog home page -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN

RE: $$Excel-Macros$$ Need help in maro

Hi Prasad, Ashish's Code working fine..See the attached Sheet. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Suryaprasad Sent: Tuesday, August 23, 2011 10:56 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Need help in maro Hi All,