Search Results

Search results 1-20 of 30.

    1. Topic
    2. Replies
    3. Last Reply
    1. I have many class objects that represent types of data/tables in a database with some serving as containers of others, and wondering if using public recordsets to streamline this is a bad idea

      • browncoat
    2. Replies
      0
      Views
      105
    1. How to find location of cells within selection range and referring to them later 1

      • browncoat
    2. Replies
      1
      Views
      84
      1
    3. royUK

    1. Possible to copy cells from one worksheet to another in the same workbook and maintain worksheet scoped named ranges for both sheets?

      • browncoat
    2. Replies
      0
      Views
      118
    1. Erroneous #NAME? error that goes away when I drag the formula back over the cells showing the error 1

      • browncoat
    2. Replies
      1
      Views
      155
      1
    3. royUK

    1. Opening a workbook to copy+paste data into the workbook in which sub is called stops working after it's been run unless I insert a break in the code 3

      • browncoat
    2. Replies
      3
      Views
      252
      3
    3. royUK

    1. With two ranges of equal size, is there a way to easily reference the cell of one that is in the same relative position as in another? 1

      • browncoat
    2. Replies
      1
      Views
      181
      1
    3. browncoat

    1. Is it possible to have the user type a formula into a cell and have it treated as text so that other cells can incorporate that into their formula? 8

      • browncoat
    2. Replies
      8
      Views
      340
      8
    3. Carim

    1. How to handle assigning null field values from database without using variant, or is variant the best way? 2

      • browncoat
    2. Replies
      2
      Views
      303
      2
    3. browncoat

    1. Possible to autofit column/row widths of cells with line breaks (e.g. vbLf) so that individual lines are fully visible and not wrapped? 1

      • browncoat
    2. Replies
      1
      Views
      231
      1
    3. browncoat

    1. How to get the relative cell number within a range? 8

      • browncoat
    2. Replies
      8
      Views
      1.1k
      8
    3. Carim

    1. Creating new objects from existing objects but not referencing them 6

      • browncoat
    2. Replies
      6
      Views
      789
      6
    3. rory

    1. Is there a reason that debug doesn't always take me to the line of code that errored? 3

      • browncoat
    2. Replies
      3
      Views
      250
      3
    3. Carim

    1. How to return and handle an empty variant when an array is expected?

      • browncoat
    2. Replies
      0
      Views
      271
    1. Passing and determining different types of object classes to populate a userform 3

      • browncoat
    2. Replies
      3
      Views
      754
      3
    3. rory

    1. Creating an array or a collection of class objects, do I have to declare each individual object? 2

      • browncoat
    2. Replies
      2
      Views
      503
      2
    3. browncoat

    1. Detect which userform.control was clicked without needing code for each specific control 1

      • browncoat
    2. Replies
      1
      Views
      177
      1
    3. royUK

    1. Running a VBA script to open and extract data from a bunch of xlsb files that have an error in the code and crash upon opening 3

      • browncoat
    2. Replies
      3
      Views
      338
      3
    3. royUK

    1. Can't unselect first list item in listbox 1

      • browncoat
    2. Replies
      1
      Views
      337
      1
    3. browncoat

    1. AVERAGEIF a range of cells based on a specific value in adjacent cell but ignore empty cells? 6

      • browncoat
    2. Replies
      6
      Views
      871
      6
    3. browncoat

    1. Can't create file using Open Append when using UNC network path, but works for mapped network path 1

      • browncoat
    2. Replies
      1
      Views
      620
      1
    3. rollis13