$$Excel-Macros$$ Re: VBA code to select filtered data - irrespective of spread of range

hai RS use the modified macro i hope it is help you auto_2 Macro ' Macro recorded 6/25/2009 by Prashant ' Sheets("Sectoral").Select Selection.AutoFilter Field:=3, Criteria1:="Auto" Range("A4").Select RANGE(SELECTION, END(XLDOWN).SELECT RANGE(SELECTION, END(XLTORIGHT).SELECT Sel

$$Excel-Macros$$ Fwd: Need help regarding formula

-- Forwarded message -- From: vidyut more Date: Wed, Jun 24, 2009 at 2:47 PM Subject: Need help regarding formula To: mac...@googlegroups.com, karthikb...@rediffmail.com, vidyut Hi i need formula in worksheet i have attached. that could automaticly serach last Pc No of Particula

$$Excel-Macros$$ For knowldge to use of ADD watch

Dear all, Hope all are fine, Please any one explain me how to use ADD watch(when we right click on the opened excell sheet) how it useful for works, Advance thanks -- Thanks & Regards Shivashankar.C.Katageri. --~--~-~--~~~---~--~~ -

$$Excel-Macros$$ Re: macro book!!urgent help

Hi, Visit our groups site i.e. on google groups and look for files. There are many files uploaded in our groups section. You'll find one zip file there named Excel 2007 Macros Made Easy.zip (size 4 mb) Check the file. Its nice. I am going through it now. Bye for now, Prashant. On Fri, Jun 26, 2

$$Excel-Macros$$ Re: Please send me Ms Access 2007 book

Asad/Surendra, MS-Access Book for your reference. MS_Office_Access_2003_EBook.pdf Regards, Upendra Singh +91-9910227325, +91-9310760597 -

$$Excel-Macros$$ Re: Inserting Rows

Hi Mahesh, 'Try below code:- Sub insertt() Cells(1, 1).Select While ActiveCell.Offset(1, 0).Value <> "" ActiveCell.Offset(2, 0).Select Selection.EntireRow.Insert Selection.EntireRow.Insert Selection.End(xlDown).Select Wend End Sub 'Thanks, -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile:

$$Excel-Macros$$ Come on Excel Enthusiasts !!! Submit your tip for this week !!!!!

Hello Members, Please submit your tip for this week competition. We have not seen competition this week. I would appreciate your active appreciation in the competition. Click on the link below to submit your tip : http://groups.google.com/group/excel-macros/browse_thread/thread/7bd29ef9c24174

$$Excel-Macros$$ Re: Inserting Rows

Hi Mahender, If you have ASAP Utilities, You can go to ASAP Utilities->Columns->6.Insert Between Empty Row and Column. ASAP Utilities will ask you for Row or column to insert and no. of Row or Column to Insert. Regards, Upendra Singh +91-9910227325, +91-9310760597 --

$$Excel-Macros$$ Re: macro book!!urgent help

Hi Ankur, I've uploaded one VBA file on Rapidshare.com. Below is the link to download. http://rapidshare.com/files/248896187/Wrox_-_Excel_2003_VBA_Programmers_Refe rence.pdf Regards, Upendra Singh +91-9910227325, +91-9310760597 ---

$$Excel-Macros$$ Re: Using range names in formulas

Fabio correctly pointed out the problem. It was caused by my lack of understanding of relative addressing. Thanks, Fabio! On Jun 25, 10:00 pm, Fabio Lemos wrote: > see the atteched file... I´ve created another column and another names > > 2009/6/24 Anderson, Jim > > > > >  Thanks, Paul. Bu

$$Excel-Macros$$ Re: Mail Merge Word Excel 2003

Hi there, Thanks so much it works fine now. Have a good one. Nourredine 2009/6/25 Upendra Singh > Hi Nourredine, > > > > > > > > Do as Below : > > 1. In the word merged document, right click the merged field for > which you want to change the format. > > 2. Click “Toggle Field Code

$$Excel-Macros$$ Re: How to convert the first letter of every cell in a colum to caps (upper case) and rest to lower case

Try =proper() command Regards Saravanan A R On Wed, Jun 24, 2009 at 1:40 PM, Subu wrote: > > Dear List members and XL Gurus > > I have an XL sheet with a column that looks something like > > Name_One > nAme_two > NAME_THREE > name_four > name_fIVe > name SIX > name sevEN > > ...and so on > >

$$Excel-Macros$$ Re: Simple Macro Request

Hi Terrance, You can do this without macro. 1. Create copy of Pivot Edit->Move or Copy Sheet. 2. Remove Subtotal and do Pivot Table Copy-> Paste Special-> Values. 3. Apply Advance Filter and Filter the Data. Regards, Upendra Singh +91-9910227325, +91-9310760597

$$Excel-Macros$$ Macro for MS word formatting

Dear Group Members, I request you to help me in this regard. *I need a macro, that "paste special" an already copied text from email / any other source .. as "values" in a word file, change its font to Arial, font size=16 and colour=Blue and save as on desktop with name "my diary dd-mm-.doc"*

$$Excel-Macros$$ Re: macro book!!urgent help

hello excel gurus im still wating for ur response Have A Nice Time & Enjoy Life Regards: CMA Ankur Pandey (Someone Different) I'm not the best but i'm not like the rest~~ On Thu, Jun 25, 2009 at 10:39 AM, ankur wrote: > > hello excel gurus > thanks for helps to my earlier queries > > i can

$$Excel-Macros$$ VBA code to select filtered data - irrespective of spread of range

Hi All, M new to VBA codes, but i've been using macro using the record function. I have created a macro as below... auto_2 Macro ' Macro recorded 6/25/2009 by Prashant ' Sheets("Sectoral").Select Selection.AutoFilter Field:=3, Criteria1:="Auto" Range("A4:B17").Select

$$Excel-Macros$$ Re: Excel Tip of Week # 26

Sure, here you go. In the attached sheet, you have N/A displayed in sheets QF & SF. If you want to replace N/A with blank, use the following steps 1. Press Ctrl + F 2. Type N/A in Find What 3. Click on Replace 4. Do not type anything in Replace With 5. Click on Options 6. In the

$$Excel-Macros$$ Inserting Rows

Hi All, Need Your help, I want 2 insert 2 empty rows between 2 rows containing data. Please suggest how to do it. Ex. : - Before Khata No-127 Plot No-657,658 Mouza -kokpara Ps-dhalbhumgarh East Singbhum Kursa Katta Plot No-549, Khata No-257, Mouza-badia, P.s.musabani, Dist-east Singhbhum.