$$Excel-Macros$$ Re: VBA - Access multiple Excel instances

Hi Paul, I've seen your post in the microsoft news groups, so you may have seen this link, but take a look at it anyway. Multiple instances of XL have always been a problem as far as VBA is concerned. http://www.microsoft.com/office/community/en-us/default.mspx?&query=multiple+instances+of+Exce

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

$$Excel-Macros$$ Re: Pivot Tables - Export tabs issue

Forget it, solved! Just need to uncheck the option "Save data with table layout" in the PivotTable options... Thanks anyway! Chechu On Sep 11, 3:23 pm, Chechu wrote: > Hi, I am looking for some help on this! I have an Excel file with a > Pivot Table, using as source of information anothe

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

Well Done Sandeep and Bruno !! Both of you done it very well. If I've to rank between Bruno and Sandeep, you will be ranked higher than Sandeep for your fantastic presentation. I appreciate efforts of both of you, and agree that this was much harder than previous ones. But both of you represented

$$Excel-Macros$$ Re: Help on formula

Hi Dilip, Please find enclosed herewith the Query file which is revised on your solution to vijay Kumar On 9/1/09, Dilip Pandey wrote: > > Hi Vidyut, > > Attached workbook has the solution for your query. Thanks. > > -- > DILIP KUMAR PANDEY > MBA-HR,B COM(Hons.),BCA > Mobile: +91 9810929744

$$Excel-Macros$$ Excel VBA macro to filter and delete duplicate row (Part 2)

Hi Everyone, Thanks for the help on my last question. I would like to expand on that macro slightly. I have tried a couple of things and they are not working. Here's what I would like to do. Sample data is shown below. 1). I would like to keep the duplicate TBD that are shown in Column A.

$$Excel-Macros$$ Excel Macro to display correct month

Hi Everyone, I am a begineer with VBA. I need some help. Sample data is shown below. Column A is a list of employee names. The TBD person represents a new hire that will be hired sometime in the future. Columns AR and beyond are months years. For example, row 1 column AR is Sept -09. Row 1

$$Excel-Macros$$ Pivot Tables - Export tabs issue

Hi, I am looking for some help on this! I have an Excel file with a Pivot Table, using as source of information another tab stored in the same file. Now, I use the Show Pages. Works perfect. I have the macro to export each new tab to a separate Excel file. Works perfect, but each new tab still sto

$$Excel-Macros$$ Help with custom formatting or a macro to do the same.

Hello all I am new to this group and was wondering if you could help me with custom formatting of cells. I have a long set of 1000+ t1 locations and they all are in this format vt1-1-a-1-1-1-5 vt1-1-b-3-5-6-1 vt1-3-b-4-5-1-2 etc. Id like the custom formatting to fill the hyphens and the vt1 por

$$Excel-Macros$$ Help with column function

Hi Everyone, I am a newbie. Please be patient with me. OK. Here is what I want to do. I have a bunch of small macros that use the following code. The only difference when the code runs in the different small submacros is that in the statement: Range("C" & CStr(LCurSRow)).Formula = "=sum(NA

$$Excel-Macros$$ Calculate Latest Value

Dear All in attach sheet i want to find latest value of column B (i.e Prod Type) from Sheet2, i use below mention formula to find latest value for column A =LOOKUP(2,1/('Main Data '!A18:A25=Sheet1!A19),'Main Data '!D18:D25) --~--~-~--~~~---~--~~ --

$$Excel-Macros$$ Downloading multiple records from a website

I am member of an group of professionals They have created a website allowing members to have access to certain area of website. I also have such user id & password where in I can log in and view restricted data One of the contents in restricted area is list of members with their contact deta

$$Excel-Macros$$ Difference between sumif & sumifs

Dear all, Can anybody describe with example the difference between sumif & sumifs? Regards, Aamir Shahzad --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and

$$Excel-Macros$$ find & replace Suffix / cell

hi, Pls find the attached sheet I want to put suffix/ prefix in the require cell Regards Manoj This e-mail contains PRIVILEGED AND CONFIDENTIAL INFORMATION intended solely for the use of the addressee(s). If you are not the intended recipient, please notify th

$$Excel-Macros$$ Re: How to remove an add in

Thanks a ton Regards Subu On Sep 9, 7:56 am, Ashish Jain <26may.1...@gmail.com> wrote: > Hi Subu, > > 1. Close all excel applications. > 2. Go to this folder - "C:\Documents and Settings\ > \Application Data\Microsoft\AddIns" > 3. Delete the file(add-in) from here. > 4. Re-open Excel and check.

$$Excel-Macros$$ Re: VBA - Access multiple Excel instances

Hi Dave, In a way that was my problem, dispite the fact that I had calculation set to manual the sheet with the large large table was still recalculating at each iteration! I've managed to get around it by explicitly turning off calculation on that sheet during the goal seek using wks.enablecalc

$$Excel-Macros$$ Re: Userform for 10 secs

Below code may help u *Sub um()* *If Application.Wait(Now + TimeValue("0:00:10")) Then* *MsgBox "Time expired" ' or write "Unload Me" here* *End If* *End Sub* Thanks & Regards, Harmeet Singh Sent via BlackBerry Wireless On Fri, Sep 11, 2009 at 10:23 AM, suresh k wrote: > Hi, >

$$Excel-Macros$$ Re: Insert and name sheets based on data on a column

Hi Subu, Attached workbook contains the scenario mentioned by you + the required automation. Thanks. -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 110062 On 9/7/09, Subu wrote: > > > Hi > > I have names on a colu

$$Excel-Macros$$ Re: Help on formula

Hi Dhananjay, I think you have missed this one. In this I have already provided a revised solution to Vijay. Thanks. == === -- Forwarded message -- Fr

$$Excel-Macros$$ Re: edit all sheets in a workbook at the same time?

Hi Mullan, Try the following code: Sub DKP() Dim ws As Worksheet For Each ws In Sheets If ws.Visible Then ws.Select (False) Next Range("a12").Select Selection.FormulaR1C1 = "dilip kumar pandey" End Sub ' replace the text which you want to type with "dilip kumar pandey" in the above code. --

$$Excel-Macros$$ Re: VBA - Access multiple Excel instances

Hi, Can't you just set calculations to manual while you do the Goal Seek? Dave. > Date: Fri, 11 Sep 2009 03:33:04 -0700 > Subject: $$Excel-Macros$$ VBA - Access multiple Excel instances > From: paul...@gmail.com > To: excel-macros@googlegroups.com > > > Hi, > > I have a very large large spread

$$Excel-Macros$$ VBA - Access multiple Excel instances

Hi, I have a very large large spreadsheet with 2 rows and about 50 columns most with long complex formulas so calculation on this sheet takes time. The main purpose of my code is to perform a Goal Seek but depending on results the code might loop up to 100 times. Each Goal Seek takes about 9

$$Excel-Macros$$ Re: Excel VBA macro to filter and delete duplicate rows

Hi. In the macro above, cell A6 would be listed as: .Cells(6,1) Cell A1 would be shown as: .Cells(1,1) To keep the macro as it is but have it not sort rows before row 6 you should change the code sections as follows: 'Set up an index column of ascending numbers after the last column .C

$$Excel-Macros$$ help plz

hi i wanted a formula in sheet 2 which will tell me under which column no 1 or 7 or etc is falling for eample 1 answer should be ir Thanks ASHISH --~--~-~--~~~---~--~~ -- Some imp