$$Excel-Macros$$ Re: VBA Copying range of cells from one workbook to another while retaining the formulae

Hi Mike, Try this: RR.Range(A LastRow_RR + 1 :CN LastRow_RR + LastRow_NWR - 5).Formula = NWR.Range(A6:CN LastRow_NWR).Formula Thanks Regards Ashish Jain McKinsey India Knowledge Center (Microsoft Certified Application Specialist) (Microsoft

$$Excel-Macros$$ Re: search until a blank cell is found.

Ashish Jain McKinsey India Knowledge Center (Microsoft Certified Application Specialist) (Microsoft Certified Professional) http://www.excelitems.com http://www.openexcel.com On Nov 11, 2:12 pm, Lakshitha luxit...@gmail.com wrote: i have a column filled

Re: $$Excel-Macros$$ Re: Refreshable Web Query

My pleasure Kush and sorry to see your problem so lately. Thanks Regards Ashish Jain McKinsey India Knowledge Center (Microsoft Certified Application Specialist) (Microsoft Certified Professional) http://www.excelitems.com http://www.openexcel.com

Re: $$Excel-Macros$$ Re: OPEN EXCEL - Needs your support and enthusiasm...

Thanks Andy, Anand Rajesh :) I'm working on making more fast, efficient, robust with lot of new user friendly and time-saving tools. Hope it will be blast !! Thanks Regards Ashish Jain McKinsey India Knowledge Center (Microsoft Certified Application

$$Excel-Macros$$ Re: Excel Encyclopedia ppt

Thanks Raj for sharing these tips. Great. Keep it up :) Regards Ashish Jain McKinsey India Knowledge Center (Microsoft Certified Application Specialist) (Microsoft Certified Professional) http://www.excelitems.com http://www.openexcel.com

$$Excel-Macros$$ Use in vlookup isna and isblank iserror

. Regards Ashish Jain McKinsey India Knowledge Center (Microsoft Certified Application Specialist) (Microsoft Certified Professional) http://www.excelitems.com http://www.openexcel.com On Sep 22, 5:05 pm, Aindril De aind...@gmail.com wrote: Hi

$$Excel-Macros$$ Re: Using Web Services with Excel 2010

Hi David, There is good walkthrough available on MSDN http://msdn.microsoft.com/en-us/library/ms519100.aspx You can also refer this article on MSDN: http://msdn.microsoft.com/en-us/library/ms546696.aspx Thanks Regards Ashish Jain McKinsey India

$$Excel-Macros$$ Re: Fwd: Hide Protect Sheet from other User

with your own password Please modify them as per your need. Please Note: I didn't opened your excel workbook and I suggest you to send your problems rather sending workbook as it's a dangerous practice. Thanks Regards Ashish Jain McKinsey India Knowledge Center

Re: $$Excel-Macros$$ array sort issue

. (period or dot) all the functions, objects and properties appear alongwith. So, when you'll check, you won't find any LEN method under WorksheetFunction. Thanks Regards Ashish Jain McKinsey India Knowledge Center (Microsoft Certified Application Specialist

$$Excel-Macros$$ Re: is there a printer installed on this computer?

'your code GOTO NEXTSTEP RESCUE: ' Your code if error NEXTSTEP: ' When all is OK Thanks Regards Ashish Jain McKinsey India Knowledge Center (Microsoft Certified Application Specialist) (Microsoft Certified Professional) http

$$Excel-Macros$$ Re: Delete values within an array

Hi Matt, That's Great. We're our best teachers. Kudos :) Thanks Regards Ashish Jain McKinsey India Knowledge Center (Microsoft Certified Application Specialist) (Microsoft Certified Professional) http://www.excelitems.com http://www.openexcel.com

$$Excel-Macros$$ Re: Excel_tips

Thanks Viju for sharing these tips. Great. Keep it up :) Regards Ashish Jain McKinsey India Knowledge Center (Microsoft Certified Application Specialist) (Microsoft Certified Professional) http://www.excelitems.com http://www.openexcel.com

$$Excel-Macros$$ Re: Spreadsheet screen refresh is very slow AFTER macro runs

. Thanks Regards Ashish Jain McKinsey India Knowledge Center (Microsoft Certified Application Specialist) (Microsoft Certified Professional) http://www.excelitems.com http://www.openexcel.com On Nov 1, 9:37 pm, Mike Magill mike.mag...@gmail.com wrote: Hi, I

Re: $$Excel-Macros$$ Re: is there a printer installed on this computer?

(if required) END SUB Thanks Regards Ashish Jain McKinsey India Knowledge Center (Microsoft Certified Application Specialist) (Microsoft Certified Professional) http://www.excelitems.com http://www.openexcel.com

$$Excel-Macros$$ Re: Excel 2007 to 2003

. Regards Ashish Jain McKinsey India Knowledge Center (Microsoft Certified Application Specialist) (Microsoft Certified Professional) http://www.excelitems.com http://www.openexcel.com On Nov 2, 7:50 am, sachin83_1...@yahoo.com sachin83_1

$$Excel-Macros$$ Re:

. 2nd Line - Turn the Sheet direction only for one sheet(in this case first sheet of the workbook as Sheets(1) is used). The Excel application and new workbooks will remain unaffected. Please Note: Like, xlRTL - xlLTR is also available. Regards Ashish Jain

$$Excel-Macros$$ Re: Excel Date format dd/mm/yyyy hh:mm:ss

-- Regional and Language Options) 3. Under Regional Options tab, change English (United States) to English (United Kingdom). 4. Click Ok. This should resolve your problem. Regards Ashish Jain McKinsey India Knowledge Center (Microsoft Certified Application Specialist) (Microsoft Certified Professional

$$Excel-Macros$$ Re: Manipulating Userform controls' back color by one routine instead of separate change routines

) Is TextBox Then ctrl.BackColor = End If If ctrl.HasChildren Then ClearText(ctrl) End If Next End Sub Regards Ashish Jain McKinsey India Knowledge Center (Microsoft Certified Application Specialist) (Microsoft Certified Professional) http

$$Excel-Macros$$ Manipulating Userform controls' back color by one routine instead of separate change routines

Regards Ashish Jain McKinsey India Knowledge Center (Microsoft Certified Application Specialist) (Microsoft Certified Professional) http://www.excelitems.com http://www.openexcel.com ___ On Oct 27, 4:57 pm, Paul Schreiner schreiner_p...@att.net wrote: Interesting

$$Excel-Macros$$ Re: Need Suggestion!

Hello, Try using Share Workbook feature of MS Excel. This will also help you in monitoring WHO changed from which OLD_VALUE to what NEW _VALUE through hidden HISTORY worksheet. Regards Ashish Jain McKinsey India Knowledge Center (Microsoft Certified Application Specialist) (Microsoft Certified

$$Excel-Macros$$ Re: help in understanding code

worksheet. ActiveWindow.ScrollColumn = 1 'Scroll to the first row of activated worksheet. ActiveWindow.ScrollRow = 1 'Error Handling OFF On Error GoTo 0 End Sub Regards Ashish Jain McKinsey India Knowledge Center (Microsoft Certified Application Specialist) (Microsoft

Re: $$Excel-Macros$$ Fwd: Help please

Hi Hemant, This group is to help MS Excel Office applications users in their day-to-day issues to raise their self-esteem with technology usage. We encourage you to proceed with the first step and we'll help you rest :) Regards Ashish Jain McKinsey India Knowledge Center (Microsoft Certified

$$Excel-Macros$$ Re: An Alternative to 'Microsoft Visual Basic For Applications Extensibility'

Hi Chris Due to the security reasons, this is not possible neither through VBA nor VSTO. Regards Ashish Jain McKinsey India Knowledge Center (Microsoft Certified Application Specialist) (Microsoft Certified Professional) http://www.excelitems.com http://www.openexcel.com On Oct 20, 7:06 pm

$$Excel-Macros$$ Re: An Alternative to 'Microsoft Visual Basic For Applications Extensibility'

Hi Chris Due to the security reasons, this is not possible through VBA/VSTO. Regards Ashish Jain McKinsey India Knowledge Center (Microsoft Certified Application Specialist) (Microsoft Certified Professional) http://www.excelitems.com http://www.openexcel.com On Oct 20, 7:06 pm, ChrisDixon

$$Excel-Macros$$ Re: Quite a bit of help needed for inexperienced MS Excel 2003 user.

. v. In case of 2007/2010 Review -- Protect Sheet v. In case of Office XP/2003 Tools -- Protection -- Protect Sheet vi. and give password -- that's it :) Regards Ashish Jain McKinsey India Knowledge Center (Microsoft Certified Application Specialist) (Microsoft

$$Excel-Macros$$ Re: Annoying popup for with Cancel button when opening workbooks

Hi Simon, Application.DisplayAlerts = False still works ! It works in all versions of excels i.e.2003, 2007 2010. Take Care of these points: 1. Use new event macro - Private Sub Workbook_Open() 2. Enable the Macros(Right below Formula Bar) whenever you open the workbook. Regards Ashish

Re: $$Excel-Macros$$ Re: help in understanding code

Hi Omar, Since the code is displaying in-built popups/windows, there is no for loop required. However, sheets can be displayed using for loop but here in this code, to select any sheet from workbook, it's not required. Regards Ashish Jain McKinsey India Knowledge Center (Microsoft Certified

$$Excel-Macros$$ Re: Unable to open workbooks from custom functions?

Hi Mike, You cannot use Event Methods like Open, Activate, Select etc in Custom Functions. Regards Ashish Jain Microsoft Certified Application Specialist (Excel) http://www.excelitems.com http://www.openexcel.com __ On May 28, 9:11 pm, Mike Ratcliffe mich

$$Excel-Macros$$ Re: Puzzle #4 - Calculate Probabilities

step. @Bruno, Like always, you've done very well and fantastic. Your solutions are very impressive and an honour for this group. @All Group Members, Future puzzles will judge your excel acumen unlike your logic as in the previous puzzles. So, be ready and keep enjoying. Thanks Regards Ashish Jain

$$Excel-Macros$$ Re: adding keyboard shortcuts to XLA macros

- Office Utils.xla 2. Macro Name - Generate_Invoice So, you'll write in the macro window - 'Office Utils.xla'! Generate_Invoice and press enter (or click on options to assign some keystroke). -- Thanks Regards Ashish Jain

$$Excel-Macros$$ Re: Excel Macro to export graphs from Excel to Powerpoint

Hi Mohit, Please visit - http://www.excelitems.com/2009/09/export-excel-2007-charts-to-powerpoint.html or check the VBA Code in attached file. -- Thanks Regards Ashish Jain (Excel Macros - Google Group Manager) http

$$Excel-Macros$$ Classic Excel 2003 Style Menu in Excel 2007 (Free Download)

-- Thanks Regards Ashish Jain (Excel Macros - Google Group Manager) http://www.excelitems.com (Developer of OpenXL) http://www.openexcel.com Excel,VBA,VSTO Trainer Ph. No. - 0x25402CF2B

$$Excel-Macros$$ Re: Puzzle #3 - Identify Perfect and Smith Numbers

represented superb intellect. Well Done Sandeep and Bruno ! -- Thanks Regards Ashish Jain (Excel Macros - Google Group Manager) http://www.excelitems.com (Developer of OpenXL) http://www.openexcel.com Excel,VBA,VSTO Trainer Ph

$$Excel-Macros$$ Re: Difference between sumif sumifs

Hi Aamir Please check out - Hope it helps ! http://www.excelitems.com/2009/09/difference-between-sumif-and-sumifs.html -- Thanks Regards Ashish Jain (Excel Macros - Google Group Manager) http://www.excelitems.com

$$Excel-Macros$$ Re: Invalid Procedure or Call Argument

SetCopyRange = Wks.Range(strAddress) End Function -- Thanks Regards Ashish Jain (Excel Macros - Google Group Manager) http://www.excelitems.com (Developer of OpenXL) http://www.openexcel.com Excel,VBA,VSTO Trainer Ph

$$Excel-Macros$$ Re: Need help in Web Query

Hi Ron, Please login using ur palas...@gmail.com id. and attach your file in the mail and then finally, send this mail to excel- mac...@googlegroups.com and 26may.1...@gmail.com -- Thanks Regards Ashish Jain (Excel Macros

$$Excel-Macros$$ Re: VBA / Macro to Download pages listed on a column

Hi Subu This link can help you with Step 1 - http://www.excelitems.com/2009/03/access-search-engines-on-browser.html -- Thanks Regards Ashish Jain (Excel Macros - Google Group Manager) http://www.excelitems.com (Developer

$$Excel-Macros$$ Puzzle #2 - Generate the Sample Pattern (VBA)

/675fbe8fd61f2699#675fbe8fd61f2699 -- Regards Ashish Jain (Excel Macros - Google Group Manager) http://www.excelitems.com (Developer of OpenXL) http://www.openexcel.com Excel,VBA,VSTO Trainer Ph. No. - 0x25402CF2B

$$Excel-Macros$$ Re: Puzzle #1 - Generate the Sample Pattern (VBA)

Hi Harmeet, That's fantastic. and good that you protected the code. I want everyone to try, so that their logic and vba skills can be sharpened. Well Done Harry. -- Regards Ashish Jain (Excel Macros - Google Group Manager

$$Excel-Macros$$ Re: help plz

Hi Ashish, Try OpenXL - http://www.openexcel.com -- Regards Ashish Jain (Excel Macros - Google Group Manager) http://www.excelitems.com (Developer of OpenXL) http://www.openexcel.com Excel,VBA,VSTO Trainer

$$Excel-Macros$$ Re: Help require for attached file.

. -- Regards Ashish Jain (Excel Macros - Google Group Manager) http://www.excelitems.com (Developer of OpenXL) http://www.openexcel.com Excel,VBA,VSTO Trainer +91..40.48.43

$$Excel-Macros$$ Re: help

Hi Ashish, Try this formula - I just used trim function to solve your issue. =INDEX(B$2:D$4,MATCH(TRIM(B10),A$2:A$4,0),MATCH(A10,B$1:D$1,0)) -- Regards Ashish Jain (Excel Macros - Google Group Manager) http

$$Excel-Macros$$ Re: Excel multiple formula in a cell

/excel/HP051992911033.aspx -- Regards Ashish Jain (Excel Macros - Google Group Manager) http://www.excelitems.com (Developer of OpenXL) http://www.openexcel.com Excel,VBA,VSTO Trainer +91..40.48.43

$$Excel-Macros$$ Re: ASAP Utility - a useful add in for excel end user

Hi Prashant, Try OPEN XL - http://www.openexcel.com It's commercial/personal use is free. -- Regards Ashish Jain (Excel Macros - Google Group Manager) http://www.excelitems.com (Developer of OpenXL) http://www.openexcel.com

$$Excel-Macros$$ Puzzle #1 - Generate the Sample Pattern (VBA)

Hi All, This is challenge for all excel users. Solve these puzzles and sharpen your excel acumen. So, here goes the first puzzle of Excel Macros Google Group in attached file. -- Regards Ashish Jain (Excel Macros - Google

$$Excel-Macros$$ VBA Macros Collection #2

-- Regards Ashish Jain (91) -40-48-43 Excel VBA - http://www.excelitems.com Open XL - http://www.openexcel.com World Stock Markets - http://www.moneydust.com Foreign Languages - http://www.oddtongue.com Powerpoint Presentations - http://www.slidesbox.com Motivational Videos - http

$$Excel-Macros$$ Re: asset list

) - Regards Ashish Jain http://www.excelitems.com http://www.openexcel.com *Developer of Open XL* - On Jun 8, 6:34 pm, steef83 stee...@gmail.com wrote: Hi, I need to make an asset list where the serial number is attached to an asset number of the company. I need to do

$$Excel-Macros$$ Re: Macro for NAV calculation

Hi Mahesh, The Group is not for providing start-to-end solutions. Try solving the problem and we all are here to technically assist you whenever and wherever you're stuck. I charge for solving such queries, since these eat time. - Regards Ashish Jain http

$$Excel-Macros$$ Re: drop down list

Hi Harish, There can be a macro written based on your requirements using Worksheet_Change event. But there is no inbuilt feature to accomplish the same. For drop-down you can use Data -- Validation feature of MS Excel. - Regards Ashish Jain http

$$Excel-Macros$$ Re: How to force a spreadsheet to load from a server and not cache

Hi Dean, This has nothing to do with excel. Either clear your Internet explorer (or of the browser you're using) or permanently set its cache size to 0KB. - Regards Ashish Jain http://www.excelitems.com http://www.openexcel.com *Developer of Open XL

$$Excel-Macros$$ Re: Material Requirment

Hi Kamlesh, Check the files section of this group. http://groups.google.com/group/excel-macros/files - Regards Ashish Jain http://www.excelitems.com http://www.openexcel.com *Developer of Open XL* - On Jun

$$Excel-Macros$$ Re: Excel macros

to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com - -~--~~~~--~~--~--~---

$$Excel-Macros$$ Please post your TIP in the post started by the Group Owner

://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com - -~--~~~~--~~--~--~---

$$Excel-Macros$$ Re: Looking for a finance spreadsheet

. - Regards Ashish Jain http://www.excelitems.com http://www.openexcel.com *Developer of Open XL* - On Jun 6, 11:51 am, spazlon spaz...@gmail.com wrote: Hello, I am looking for a personal finance spreadsheet. I tried making one of my

$$Excel-Macros$$ Re: split data to different Excel files

ThisWorkbook.Path \ myDep.Value .xls CWbk.SaveAs C:\destination\ myDep.Value .xls CWbk.Close False Set CWbk = Nothing Next End Sub - Regards Ashish Jain http://www.excelitems.com http://www.openexcel.com *Developer of Open XL

$$Excel-Macros$$ Re: UserForm Initializing after if.. then statement

, you'll better understand the above 2 points. Try with different expressions to really learn this. - Regards Ashish Jain http://www.excelitems.com http://www.openexcel.com *Developer of Open XL* - On Jun 6, 3:11

$$Excel-Macros$$ Re: i want protect cell only in first row

settings. You're done. That's it. Regards Ashish Jain www.excelitems.com Developer of Open XL On Apr 30, 10:52 am, Punj rkp...@gmail.com wrote: I want protect cell in first line only I want if i overwrite this black cells, it does not change. and changes in below all cells can be made. help

$$Excel-Macros$$ Re: Open XL - A Powerful Excel Addin

for Open XL (2003 users). New features/bug fixes/support will be available with Open XL 1.0.0.0 (2007 and onwards) only. Enjoy !! Regards Ashish Jain www.excelitems.com Developer of Open XL --- On Apr 28, 11:02 am, Jitendra Kumar

$$Excel-Macros$$ Re: Querry regding OpenXL

with certain limitations. Regards Ashish Jain www.excelitems.com Developer of Open XL --- On Apr 28, 11:48 am, Ankur Satija ankursat...@gmail.com wrote: One problem using Open XL... Once any function

$$Excel-Macros$$ Re: Open XL - A Powerful Excel Addin

/videos.html Regards Ashish Jain www.excelitems.com Developer of Open XL -- On Apr 28, 4:14 pm, satish satishpag...@gmail.com wrote: Dear Friends, I downloaded the zip folder and double clicked on setup file

$$Excel-Macros$$ Re: Open XL - A Powerful Excel Addin

system? 4. Are you running Windows XP or above on your system? 5. Do you use Office 2007 and above? Regards Ashish Jain www.excelitems.com Developer of Open XL --- On Apr 28, 7:00 pm, Upendra Singh upendrasinghsen

$$Excel-Macros$$ Re: How to download openxl???

Hi Try this link - http://26may.1984.googlepages.com/OpenXLBeta1.0.0.0.zip Regards Ashish Jain www.excelitems.com Developer of Open XL -- On Apr 28, 3:45 pm, iactnow yuk.s...@gmail.com wrote: I have tried to download

$$Excel-Macros$$ Re: PREPARE INDEX WITH PAGE NUMBERS

Hi, Try wsheet.Hpagebreaks.Count and Wsheet.VPageBreaks.Count. and wsheet.HPageBreaks(Page Count).Location.Row Regards Ashish Jain www.excelitems.com Developer of OpenXL --- On Apr 28, 9:24 am, vivek jain vivek.j

$$Excel-Macros$$ Re: Regarding MCAS EXAM AND FEE IN INDIA.

Hi Abdul, To prepare for MCAS Exam Preparation, you may go through Microsoft published books and articles. Try sample exams, you may find them on search engines. Fee Structure is flat $50. For running offers and discounts, please visit http://www.prometric.com/microsoft Regards Ashish Jain

$$Excel-Macros$$ Re: Learn VBA

. Regards Ashish Jain www.excelitems.com Developer of OpenXL On Apr 27, 1:36 pm, Sachin Shukla sachina...@gmail.com wrote: Dear All, I want to learn VBA in excel. Please help me. Thanks Sachin Shukla

$$Excel-Macros$$ Re: Want help on Lookup and pivot tables

Hi Jayesh, Here is a good reference on How to use Lookup methods? http://www.excelitems.com/2009/03/how-to-use-vlookup-function.html Regards Ashish Jain www.excelitems.com Developer of OpenXL On Apr 25, 2:37 pm, Jayesh

$$Excel-Macros$$ Re: Sorting Data from Many excel Sheets

Hi Satish, Try Merge Worksheets command. It's located in Sheet Utils -- Merge Worksheets of Open XL addin available free on http://www.excelitems.com Regards Ashish Jain www.excelitems.com Developer of OpenXL On Apr 23, 4

$$Excel-Macros$$ Can data be feeded to a form in Internet explorer ?

Hi Laxmikant Yes, this is possible. Using VBA you can fill forms on internet, even if it's https. For more tips, tricks, downloads and problem solutions: visit -- http://www.excelitems.com Regards *Ashish **Jain* Analyst

$$Excel-Macros$$ Re: select case error

*Ashish **Jain* Analyst, CSC Microsoft Certified Application (Excel) Specialist Excel and VBA Trainer Author - www.excelitems.com +91--40-48-43

$$Excel-Macros$$ Re: Data extracting issue, perhaps a lookup a problem

Regards *Ashish **Jain* Analyst, CSC Microsoft Certified Application (Excel) Specialist Excel and VBA Trainer Author - www.excelitems.com +91--40-48-43

$$Excel-Macros$$ Re: XML

solutions: visit -- http://www.excelitems.com Regards *Ashish **Jain* Analyst, CSC Microsoft Certified Application (Excel) Specialist Excel and VBA Trainer Author - www.excelitems.com +91--40-48-43

$$Excel-Macros$$ Re: Deleting module code

...@gmail.com or Ashish Jain @ 26may.1...@gmail.com - -~--~~~~--~~--~--~---

$$Excel-Macros$$ Re: Deleting module code

@ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com - -~--~~~~--~~--~--~---

$$Excel-Macros$$ Re: run time ERROR 9

in the vba macro. For more tips, tricks, downloads and problem solutions: visit -- http://www.excelitems.com Regards *Ashish **Jain* Analyst, CSC Microsoft Certified Application (Excel) Specialist Excel and VBA Trainer Author

$$Excel-Macros$$ Re: Connecting with yahoo finance servers

Hi vitovla, Use Exit keyword to break a process. You can use it to come out of Subroutine or a Loop. Its possible combinations are: Exit Do Exit For Exit Sub Regards Ashish Jain On Apr 4, 9:12 pm, vitovla slbcr...@gmail.com wrote: Hello, I'm developing an application to download the data

$$Excel-Macros$$ Re: UserForm objects/controls collections?

Hi Vincent It seems more like sharing information - and we dnt find any other way to do this at runtime. If you've plz share with us. Regards Ashish Jain On Apr 2, 6:09 pm, Yu vincent2...@gmail.com wrote: Hi Dear all,     I have this puzzle for a long time. I often program UserForm

$$Excel-Macros$$ Re: Useful Excel Sheets

and you'll be able to see that. Make sure Headings are enabled, If you can't see headings, please Goto View -- Check Headings. Enjoy and Thanks again Mudassar:) Regards Ashish Jain On Mar 30, 2:01 am, zheng yu vincent2...@gmail.com wrote: Hi Mudassar,    while I am looking at Drill bit

$$Excel-Macros$$ Re: Modifying the contents of a cell in a range in excel

it has been called. Remember, a function always returns a value but a subroutine may or may not. A subroutine can call a function but a function don't call sub-routines. Regards Ashish Jain On Mar 30, 1:25 am, LookingForExcelHelp ahar...@gmail.com wrote: Rodney, Thanks for the help, but I'd like

$$Excel-Macros$$ Welcome Rodney Powell, Microsoft MVP

MVP Program, click here - http://mvp.support.microsoft.com/ Thanks and Regards Ashish Jain Group Manager --~--~-~--~~~---~--~~ - Some important links for excel users: 1. Excel

$$Excel-Macros$$ Re: count number of occupied cells in every row

solutions: visit -- http://www.excelitems.com Regards *Ashish **Jain* Analyst, CSC Australia Microsoft Certified Application (Excel) Specialist Technical Trainer - Excel and VBA Author - www.excelitems.com +91--40-48-43

$$Excel-Macros$$ Re: Sort Table as per the order of records in another Table

://www.excelitems.com Regards *Ashish **Jain* Analyst, CSC Australia Microsoft Certified Application (Excel) Specialist Technical Trainer - Excel and VBA Author - www.excelitems.com +91--40-48-43

$$Excel-Macros$$ Re: Next error

End If End Sub . . . . . For more tips, tricks, downloads and problem solutions: visit -- http://www.excelitems.com Regards *Ashish **Jain* Analyst, CSC Australia Microsoft Certified Application (Excel) Specialist Technical

$$Excel-Macros$$ My VBA Macros Collection 01

://www.excelitems.com/2009/03/change-picture-or-image-location.html 3. Copy Excel Worksheets to MS Wordhttp://www.excelitems.com/2009/03/copy-excel-worksheets-to-microsoft-word.html -- Regards Ashish Jain

$$Excel-Macros$$ A NEWS FOR ALL MEMBERS

Dave Bonallack 67 Ashish Jain 63 Tom_Jeffries 59 Nihar 57 Andy (Aindril) 55 Ajay Varshney 44 Ajit Navre (AmatuerVB) 42 Harmeet (Harry) 39 Paul Schreiner Note: This step has been taken on the basis of their performance and every member is thankful to them

$$Excel-Macros$$ Re: Embed a flash into Excel

Regards *Ashish **Jain* Analyst, CSC Australia Microsoft Certified Application (Excel) Specialist Technical Trainer - Excel and VBA Author - www.excelitems.com +91--40-48-43

$$Excel-Macros$$ Re: Reg. Output to be more viewable

. . . . . . For more tips, tricks, downloads and problem solutions: visit -- http://www.excelitems.com Regards *Ashish **Jain* Analyst, CSC Australia Microsoft Certified Application (Excel) Specialist Technical Trainer - Excel and VBA

$$Excel-Macros$$ Re: Update from internet

. Regards Ashish Jain Group Manager On Mar 19, 12:27 pm, pravin mehta mehtapravin@gmail.com wrote: unsubscribe On Wed, Mar 18, 2009 at 10:16 PM, Balachander S sba...@gmail.com wrote: Can some body in the group tell me how to solve this problem I Have a worksheet that updates some rates from

$$Excel-Macros$$ Re: Change image source

-- http://www.excelitems.com Regards *Ashish **Jain* Analyst, CSC Australia Microsoft Certified Application (Excel) Specialist Technical Trainer - Excel and VBA Author - www.excelitems.com +91--40-48-43

$$Excel-Macros$$ Re: Subtract values that are in different rows

-- http://www.excelitems.com Regards *Ashish **Jain* Analyst, CSC Australia Microsoft Certified Application (Excel) Specialist Technical Trainer - Excel and VBA Author - www.excelitems.com +91--40-48-43

$$Excel-Macros$$ Re: 2nd Anniversary - Surprise Gift for Top Posters on Mar16

. As of now, I can't commit exact date but my commitment of gift will be fulfilled very soon. With Sorry Ashish Jain Group Manager --- On Wed, Mar 18, 2009 at 7:05 PM, Ajay Varshney ajayvarshney21...@gmail.comwrote

$$Excel-Macros$$ Re: VBA Form Auto Sizing

For more tips, tricks, downloads and problem solutions: visit -- http://www.excelitems.com Regards *Ashish **Jain* Analyst, CSC Australia Microsoft Certified Application (Excel) Specialist Technical Trainer - Excel and VBA Author

$$Excel-Macros$$ Re: Data Validation Problem with Copy/Paste

For more tips, tricks, downloads and problem solutions: visit -- http://www.excelitems.com Regards *Ashish **Jain* Analyst, CSC Australia Microsoft Certified Application

$$Excel-Macros$$ Re: Update from internet

, downloads and problem solutions: visit -- http://www.excelitems.com Regards *Ashish **Jain* Analyst, CSC Australia Microsoft Certified Application (Excel) Specialist Technical Trainer - Excel and VBA Author - www.excelitems.com

$$Excel-Macros$$ Re: How to break the vba project password

: visit -- http://www.excelitems.com Regards *Ashish **Jain* Analyst, CSC Australia Microsoft Certified Application (Excel) Specialist Technical Trainer - Excel and VBA Author - www.excelitems.com +91--40-48-43

$$Excel-Macros$$ Re: Jump to Yahoo Mail and perform search with Active Cell Contents - attempt two

*Ashish **Jain* Analyst, CSC Australia Microsoft Certified Application (Excel) Specialist Technical Trainer - Excel and VBA Author - www.excelitems.com +91--40-48-43

$$Excel-Macros$$ Re: Jump to Yahoo Mail with Active Cell Contents, and then perform a search in the Search Mail Box

*Ashish **Jain* Analyst, CSC Australia Microsoft Certified Application (Excel) Specialist Technical Trainer - Excel and VBA Author - www.excelitems.com +91--40-48-43

$$Excel-Macros$$ Re: How to break the vba project password

Hi Harry, Its m !! Yhoo !! Let's Rock on!! For more tips, tricks, downloads and problem solutions: visit -- http://www.excelitems.com Regards *Ashish **Jain* Analyst, CSC Australia Microsoft Certified

$$Excel-Macros$$ Re: How to use Vlookup Function?

://www.excelitems.com Regards *Ashish **Jain* Analyst, CSC Australia Microsoft Certified Application (Excel) Specialist Technical Trainer - Excel and VBA Author - www.excelitems.com +91--40-48-43

$$Excel-Macros$$ Re: Download #1: World's Major Stock Exchanges Tracker

it prompts you and try to use it on a system where internet is working. Thanks and Regards Ashish Jain On Mar 10, 2:30 pm, zaki l zaki...@gmail.com wrote: i downloaded the file but it showed some error and it was not gettin refreshed. On Tue, Mar 10, 2009 at 9:46 AM, Ashish Jain 26may.1

$$Excel-Macros$$ Re: Compare two columns!!

Regards *Ashish **Jain* Analyst, CSC Microsoft Certified Application (Excel) Specialist Technical Trainer - Excel and VBA Author -www.excelitems.com +91--40-48-43

  1   2   >