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 Chriss Miller 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: owentmoore
  • Content: Threads
  • Order by date
  1. owentmoore

    excel 2003 macro problem in 2007 - can't select spinner or group box

    I have a macro that selects a number of shapes including text boxes, rectangles, spinners and group boxes. It works perfectly in excel 2003 but not in excel 2007. Using 2007 I get "run time error 1004, Application defined or object defined error". It looks like whenever I try to select the...
  2. owentmoore

    Combobox reducing list vba

    Hi all I have a priority list of 1 to 28 which the user can select against any given product. As there are a number of products, there needs to be different priorities assigned and actions completed as a result etc. I have created a combo box to do this for me. The combobox list is a range of...
  3. owentmoore

    excel vba End(xlDown) stopping on blank cell

    Hi all I have a module that searches column A for non blank cells and deletes the non blanks (it needs to do this one by one as it's part of a larger routine, selecting the entire column and deleting isn't an option). The code is as follows: Sub FindAndeDeleteNonBlanks() ' Find the first...
  4. owentmoore

    Slow code / run code with hidden rows

    Hi all I have the following code which searches through each row in turn looking for the first occurence of a comma. It then enters the cell location of this comma in a cell on the same row. I have approx 1700 rows to search which is taking a long time. But if I filter by only the required...
  5. owentmoore

    Error with Set statement while running vba code

    Hi all, I am getting error code "unable to get the find property of the range class" while executing the set statement in the following code. I can't see what the problem is with the code. Does anyone have any ideas? Range("IV" & lRow1).Select With ActiveSheet Do With...
  6. owentmoore

    How to relate column number (eg 1) to column Name (eg A)

    Hi all, For a specific task I am reading the column number of a value in my sheet as being in column 57 which is column name "BE". I need to use the column name in a spreadsheet to locate a formula I have, but I do not know how to turn the 57 into BE. Can anyone help? Thaks Owen
  7. owentmoore

    Dynamic named range offset problem

    Hi I have a dynamic named range as follows: = OFFSET('Summary Data'!$Z$2,0,0,COUNTA('Summary Data'!$Z$2:$Z$2),COUNTA('Summary Data'!$2:$2)) The code picks up creats the range from Z2 as required, counts along row 2 as required, but instead of stopping at my last value, keeps counting 20...
  8. owentmoore

    Pivot Table Report Style articls/links

    Hi all Does anyone know of any articles or websites I can look up to get a good understanding on how to create my own pivot table report style? i.e. Instead of selcting one of the 15 or so styles offered by Excel, I'd like to create my own and be able to apply it as required. Thanks Owen
  9. owentmoore

    Add worksheet to userform based on sheet name criteria

    Hi all, I have a userform that when activated adds a link to each worksheet in my workbook on the userform. I need to add a line in my code that ensures only those worsheets with certain text in their name is shown on the user form. E.G. a workbook with worsheet names "Sigma_Product"...
  10. owentmoore

    Excel - weeknum giving error on one workbook but not another

    Hi all I am having an anoying little problem. I am using weeknum to return the current week number. Problem is that I am getting the error "That name is not valid". I have Analysis Toolpak installed. When I create a new workbook and use the weeknum formula it works perfectly! Any ideas what...
  11. owentmoore

    Show only pivot field items based on previous pivot field filter

    Hi all I know I've seen a response to this question previously but cannot find the FAQ again. When I select a pivot item for the first pivot field, on viewing the pivot items for the next field, all the pivot items for the previously filtered data are still included. Why is this? Is there a...
  12. owentmoore

    Excel pivotitem selection using cell reference

    Hi all, I've taken the code below from thread707-694278 in which Skip describes how to select a pivot item based on a value in a cell. The code works fine when the value in the cell i'm selecting is a text value. However when I try enter a number, the code fails as the value is not being read...
  13. owentmoore

    Excel - uing advanced filter crashed excel

    Hi all Any time I use advanced filter on my spreadsheet it crashes. I am using Escel 2000. Is this a bugwith excel or something I can fix? Thanks Owen
  14. owentmoore

    Excel - Find and select rows based value

    I need to select all rows in an excel worksheet that have a certain value. The code below will select the last occurence of the value. I haven't been able to modify it to select all occurences and to select all the rows that contain this occurence. Please - help!! Sub Select_Row() Dim lRow...
  15. owentmoore

    Excel macro problem opening workbook with links

    I have an excel macro that opens another workbook as part of the code. This works fine for the majority of my workbooks but for one workbook there are links in it. This means that whenever it opens it asks if I want to update the links - I don't - but I must now be present anytime the workbook...
  16. owentmoore

    Pivot Table - Grand Total Showing all values not just filtered results

    I have a pivot table that shows only the top 10 items, sorted according to monetary value in the data field. I have another column in the data field that shows the percentage of the values of the total. The issue I am having is that I can only see the result as a percentage of the top 10 items...
  17. owentmoore

    Pivot Table Refresh Best Practice-Reducing File Size vs Opening Time

    I have a lot of pivot tables in my file. In order to reduce the file size I have made the source data of all the pivot tables the same as the first pivot table - correct so far I hear you say. I now want to open the file with only the pivot tables on the first sheet refreshing which allows it...
  18. owentmoore

    Count number of times a worksheet has been opened

    I have a file containing many pivot tables. I do not want all of these pivot table to refresh when I open them, only the activesheet. In this way I can reduce the time to open. I want to select a sheet and in the worksheet activate event, count how many times the sheet has been open. If it has...
  19. owentmoore

    Problem opening excel file with Pivot Tables

    Hi All, I had an excel file with 25000 rows of data and 26 columns. I had approx 10 pivot tables created off this data. The data and pivot tables are in the same file. The file size was 40MB. In order to reduce the file size I went through all my pivot tables individually and put the source...
  20. owentmoore

    Error with sending email through excel

    I have an excel file that is to open on a scheduled day every week, perform macro tasks, and close again. If there is an error in doing the tasks, I want the program to email me that there has been an error. The code below creates a new file with the heading "Error with Update Consumables.xls"...

Part and Inventory Search

Back
Top