Threads by CapG

    1. Title
    2. Replies
    3. Last Reply
    1. Color code bar chart data bars based on a y- axis criteria dynamically 1

      • CapG
    2. Replies
      1
      Views
      604
      1
    3. GlennUK

    1. Add worksheet change event to add a pre specified number looking up the corresponding row value 2

      • CapG
    2. Replies
      2
      Views
      793
      2
    3. CapG

    1. Create a chart in excel to summaries the table of contents

      • CapG
    2. Replies
      0
      Views
      34
    1. Formula to apply conditional formatting to highlight specific cells based the cell to the left

      • CapG
    2. Replies
      0
      Views
      369
    1. Date column not changing its format when imported from a text file 2

      • CapG
    2. Replies
      2
      Views
      606
      2
    3. GlennUK

    1. Runtime error - method open of object connection failed

      • CapG
    2. Replies
      0
      Views
      327
    1. At the end of macro execution, I am getting "the picture is too large and will be truncated" 4

      • CapG
    2. Replies
      4
      Views
      483
      4
    3. gijsmo

    1. How to get rid of unfiltered cells when applying looping functions 4

      • CapG
    2. Replies
      4
      Views
      428
      4
    3. CapG

    1. How to preserve formatting in excel after saving the file as .csv through vba 6

      • CapG
    2. Replies
      6
      Views
      948
      6
    3. royUK

    1. Index/match formula referring to another workbook is not working 3

      • CapG
    2. Replies
      3
      Views
      408
      3
    3. CapG

    1. Sumif function not working.Returning zero 9

      • CapG
    2. Replies
      9
      Views
      886
      9
    3. Fluff13

    1. Dynamic filter using range of values entered in either of the Fields. 1

      • CapG
    2. Replies
      1
      Views
      2k
      1
    3. royUK

    1. Multiple values per parameter using power query 8

      • CapG
    2. Replies
      8
      Views
      1.1k
      8
    3. CapG

    1. The view in three data tabs to automatically refresh i.e, connected to database when the value in another tab changes. 4

      • CapG
    2. Replies
      4
      Views
      1.1k
      4
    3. CapG

    1. Hyper links to a file with dynamic file name through variable is not working 1

      • CapG
    2. Replies
      1
      Views
      487
      1
    3. KjBox

    1. Run time error 6: Overflow 24

      • CapG
    2. Replies
      24
      Views
      2.8k
      24
    3. royUK

    1. Running through vbscript giving this error message-cannot run macro may not be available in this workbook or all macros disabled 3

      • CapG
    2. Replies
      3
      Views
      1.8k
      3
    3. royUK

    1. Download zip files from a url through vba 12

      • CapG
    2. Replies
      12
      Views
      3.1k
      12
    3. CapG

    1. Schedule to trigger macro to run automatically on a specific time/date 7

      • CapG
    2. Replies
      7
      Views
      2.9k
      7
    3. royUK

    1. Retrieving top 10 largest values depending on its corresponding column. 11

      • CapG
    2. Replies
      11
      Views
      1.2k
      11
    3. Carim