Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: vaneagle
  • Order by date
  1. vaneagle

    Excel Pivot Table Calculated Field

    ...Table-->Formulas-->Calculated Field. It then pops up a dialog box. Give it a name (no Spaces), then in the formula box enter your fields for your calculation... I am guessing something like this (current dte itm ct - yesterday's dte itm count)/current dte item ct)*100 hope this helps...
  2. vaneagle

    XL 2002 Refering to a workbook

    Sorry Tony, I do know the name of the workbook. Thing is that the workbook name will chance everytime I receive it via e-mail. Reson being as that part of the filename contains a date. So I was wondering is it possible once you have the file open within excel, to reference to that file. Before...
  3. vaneagle

    XL 2002 Refering to a workbook

    howdy, How do I change to another workbook which is open in excel, yet the name will be different when I receive the file? I want to use code to reference between the two... just not sure how or even if it can be done.... Dim filename As String Dim wb As Workbook Dim wb2 As Workbook...
  4. vaneagle

    Extract text from IE into Excel

    Hi, This appears to be great if I could get the code to work!! Do I need a reference added or something? It keeps giving me a " Run-time error '1004': Application-defined or object defined error" what am I doing wrong? or is it to do with the site security? the code as is posted above Sub...
  5. vaneagle

    XL 2002 Change Event

    I got it to work with the following: Private Sub Worksheet_Change(ByVal Target As Range) Worksheets(3).Activate Set isect = Application.Intersect(Range("b4"), Range("b4")) If isect Is Nothing Then MsgBox "Ranges do not intersect" Else If...
  6. vaneagle

    XL 2002 Change Event

    Thanks Guys... I'll do a search on the intersect method and test the 'Target' at the same time with your suggestion Geoff. Thanks, vaneagle
  7. vaneagle

    XL 2002 Change Event

    HI All, Not sure how to go about this. I have a pivot table in a worksheet. IF a user selects a page selection I need an an event to happen. The cell that this sits in is B4. The code I have is: Private Sub Worksheet_Change(ByVal Target As Range)...
  8. vaneagle

    XL XP Custom Functions

    Hi Zathras. Spot on!! Have a star!! thanks, vaneagle
  9. vaneagle

    XL XP Custom Functions

    Hi All, I have a custom function in excel which I use. The issue is I am not sure how I go about updating/refreshing the calculation when the source data changes. With for example, sum(A1:A10), the sum function automatically refreshes... How do I go about doing the same thing with a function...
  10. vaneagle

    Excel XP Remove Duplicate Rows

    Hi Guys, TonyJollans - i tried that method following a post in this forum and I could not get it to work...as I was thinking of recording it then make the neccessary adjustments... xlbo - I will give the forums another search... thanks guys... vaneagle
  11. vaneagle

    Excel XP Remove Duplicate Rows

    Hi, I have several excel spreadsheets with around 15 to 20 sheets with data I have extracted at around 30,000 lines per sheet. I need to remove the duplicate rows. The duplicate data sits in column B. I looked at autofilter and its not really an option given the number of files and sheets I...
  12. vaneagle

    Excel XP Loop thru sheets

    ...As Long Dim lngSheetCount, numsheets As Long Set wb = ThisWorkbook MyPath = "U:\My Documents\Testing\data\" ChDir MyPath TheFile = Dir(MyPath & "\*.xls") Do While TheFile <> "" Workbooks.Open Filename:=TheFile, UpdateLinks:=0, ReadOnly:=True Set wb2 = ActiveWorkbook sname =...
  13. vaneagle

    Excel XP Loop thru sheets

    ...wb As Workbook Dim TheFile As String Dim MyPath As String Dim ws As Worksheet MyPath = "U:\My Documents\Testing\data\" ChDir MyPath TheFile = Dir("*.xls") Do While TheFile <> "" Set wb = Workbooks.Open(MyPath & "\" & TheFile) For Each ws In ActiveWorkbook.Worksheets nrow =...
  14. vaneagle

    Excel Shortcuts

    Hi ultrcyclist, to toggle between sheets in the same file press ctrl + pg up.... this will toggle to the right... ctrl + pg dn will toggle to the left. In relation to your second question, it depends on what data you are trying to display.. if in sheet 1 there is data in column A, in sheet 2...
  15. vaneagle

    Excel XP DataObject

    Thanks PHV... I initially had a look for Microsoft Forms 2.0 Object Library but couldn't find it!! So I went to an Excel 97 user and found it straight away. On my pc I actually had to go browsing for the fm20.dll and load it so that it was there. All is well now. Thanks very much. vaneagle
  16. vaneagle

    Excel XP DataObject

    Hi, The following code errors on me in XP. Funny thing is is that it works in Excel 97. The error it gives is: compile error: User-defined type not defined Dim JunkData As New DataObject ' Declare Variable to clear out clipboard Any ideas? Is there something I need to add in? regards...
  17. vaneagle

    Help combining ISERROR with IF statement

    As i understand it the -1e9 acts to ignore anything that is not numerical. Sorry.. I have misunderstood... the SUM('Step 2'!C13:D15) is not the problem its the countif...
  18. vaneagle

    Help combining ISERROR with IF statement

    Hi Excelerate2004, Instead of trying to trap the errors with if statements, why not replace you sum formula's with the following example: =SUMIF('Step 2'!E11:E12,">-1e9") and so on.. This will sum the following: Col A 1 5 #DIV/0! 6 text #REF! =SUMIF(A1:A6,">-1e9") Answer = 12 You can keep...
  19. vaneagle

    Excel Formula-Figuring Sell Price based on Cost

    lol...maybe... Where i work we use markup and gross profit... so I am familiar with these concepts.. Regards, vaneagle
  20. vaneagle

    Excel XP Sum a moving range

    Hi Skip, Thanks skip... I shall have a look.....

Part and Inventory Search

Back
Top