Search:

Type: Posts; User: Martel; Keyword(s):

Search: Search took 0.00 seconds.

  1. Replies
    3
    Views
    283

    Re: EXCE Named Range Corruption

    Many thanks Fazza for your reponse. This is my fault but I omitted to mention that I using Dynamic Named Ranges, it is these that are causing all the ptoblems. I do not kow how I could use VBA to...
  2. Replies
    3
    Views
    283

    EXCE Named Range Corruption

    Named Ranges become corrupted readily. I am writing a fairly large application using VBA and named ranges extensively. I have a major problem - it appears that in the event of any error in coding,...
  3. Replies
    2
    Views
    148

    Re: Filters and combo boxes

    Hi. The original example with 3 columns was submitted simply to demonstrate the point. The actual spreadsheet contains more columns. As part of a personal system, some of these additional columns...
  4. Replies
    2
    Views
    148

    Filters and combo boxes

    Small spreadsheet with 3 columns - first name, surname and status. Status can be any of several options including “withdrawn”. Filter to hide rows with “withdrawn” status works fine. Rows disappear...
  5. Replies
    0
    Views
    147

    index function in excel vba problem

    find lost thread. instructions not clear
  6. Replies
    1
    Views
    127

    sort and filter for userform listbox

    I am sorting worksheet by 2 columns alphabetically then filtering by a 3rd which is required to be “Yes”. Works fine on worksheet but list box on user form returns all records regardless of 3rd...
  7. Thread: Index Function

    by Martel
    Replies
    5
    Views
    242

    Re: Index Function

    To M , Eric et al. Plenty of responses to try for which many thanks to all. No early night for me...... ciao all
  8. Thread: Index Function

    by Martel
    Replies
    5
    Views
    242

    Re: Index Function

    Hi and thanks. Offset reportedly causing #Ref errors when deleting rows in dynamic range names. I have been getting this problem regularly so thought I would give index a go. Speed not important...
  9. Thread: Index Function

    by Martel
    Replies
    5
    Views
    242

    Index Function

    Hi. Can anyone please quickly provide an alternative formula to create a dynamic named range which will use the index function as opposed to offset or indirect. Sorry, can't get my head round this...
  10. Thread: Custom views

    by Martel
    Replies
    4
    Views
    322

    Re: Custom views

    Hello and thank you. Not sure if I am doing this correctly, not clued up yet on how this forum thing works.

    Sorry, not understanding your range suggestion. Given that my “default view “ would be...
  11. Thread: Custom views

    by Martel
    Replies
    4
    Views
    322

    Re: Custom views

    Excel Custom Views

    Hi. This is not an answer to my thread. I am Martel, live in Devon and still thwarted by the excel custom view feature. I am new to this forum so apologies if i am breaking any...
  12. Thread: Custom views

    by Martel
    Replies
    4
    Views
    322

    Custom views

    Workbook has no tables and no protected sheets. Have created several custom views but excel does not successfully switch between them e.g. view “males only” works. Switch view to show people from...
Results 1 to 12 of 12