Excel VBA / Macros

Questions specifically related to excel programming

    1. Variable file name and path with button 12

      • zsolti90
    2. Replies
      12
      Views
      3.7k
      12
    3. trunten

    1. Copy Inactive Worksheet using pre-defined data 101

      • mike_calc
    2. Replies
      101
      Views
      3.1k
      101
    3. Mumps

    1. Split workbook into multiple files based on column value 25

      • alkaline3
    2. Replies
      25
      Views
      2.6k
      25
    3. alkaline3

    1. Simple VBA function, pivot tables 30

      • stefanzman
    2. Replies
      30
      Views
      2.2k
      30
    3. stefanzman

    1. COPY AND PASTE 26

      • jhas56788
    2. Replies
      26
      Views
      2k
      26
    3. jolivanes

    1. AutoFilter Multiple Sheets, Copy, New Book, Paste to Multiple Sheets 28

      • bpdarrow
    2. Replies
      28
      Views
      2k
      28
    3. bpdarrow

    1. Countifs on only visible data after filtering 35

      • cobber1418
    2. Replies
      35
      Views
      1.9k
      35
    3. KjBox

    1. VBA code to create a new table with unique names separating it by months. 9

      • FaKest
    2. Replies
      9
      Views
      1.8k
      9
    3. royUK

    1. Adding an array formula into my macro 40

      • khanaran123
    2. Replies
      40
      Views
      1.7k
      40
    3. Carim

    1. VBA - How to make formulas dynamic when inserting new rows? 7

      • jeoffrey3
    2. Replies
      7
      Views
      1.6k
      7
    3. royUK

    1. Select Case not filling in cells 13

      • rookiesysadmin
    2. Replies
      13
      Views
      1.5k
      13
    3. rookiesysadmin

    1. Filter column based on reference criteria 24

      • alkaline3
    2. Replies
      24
      Views
      1.4k
      24
    3. royUK

    1. Partial Search on String to return Row 23

      • KDoubleU
    2. Replies
      23
      Views
      1.3k
      23
    3. royUK

    1. VBA if row 3 contains text then insert a new row 21

      • Ellenste
    2. Replies
      21
      Views
      1.3k
      21
    3. Carim

    1. using excel userform to populate table1 16

      • jimUSMC
    2. Replies
      16
      Views
      1.3k
      16
    3. S O

    1. How to save opened PDF file via AcroExch.PDDoc.save() 1

      • IlanL
    2. Replies
      1
      Views
      1.3k
      1
    3. KjBox

    1. Merge multiple excel books into a single master worksheet. Master sheet to auto update automatically if data is changed in slave books. 10

      • mrbuttons
    2. Replies
      10
      Views
      1.3k
      10
    3. mrbuttons

    1. Revising existing macro to be more dynamic- count the occurrences of usernames based on a date in multiple files and update the tracker 13

      • CapG
    2. Replies
      13
      Views
      1.2k
      13
    3. dangelor

    1. Filling up template based on certain criterias 18

      • albertd
    2. Replies
      18
      Views
      1.2k
      18
    3. Carim

    1. Importing specific Rows from a CSV file using VBA 2

      • ep_novice
    2. Replies
      2
      Views
      1.2k
      2
    3. ep_novice

Display Options