VBA Express Forum > VBA Code & Other Help > Excel Help

Pages : 1 2 3 [4] 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173

751. Selecting Sheets based on a VBA array (8 replies)
752. [SOLVED:] VBA to Update Excel Workbook Properties (3 replies)
753. VBA Macro: Text Split by defined # of characters - word dropping issue (7 replies)
754. Object required error in dictionary (8 replies)
755. VBA: What can cause of truncation of significant digits double precision variable? (17 replies)
756. [SOLVED:] Need help with text to column like formulas (3 replies)
757. Help! What is wrong? My code is not looping! (16 replies)
758. Hello friends. Please help ! COUNTIF formula ? (3 replies)
759. [SOLVED:] record # if data in other columns in same row (11 replies)
760. Loop on Single cell (1 replies)
761. Deleting duplicate values from two different columns (10 replies)
762. Macro to consolidate data from different files in a folder (1 replies)
763. Counting repetitions of string of words to counting group of words in one cell (1 replies)
764. [SOLVED:] Geometric Brownian Motion Help (21 replies)
765. [SOLVED:] Loop through inserting row from one sheet to another, at least 2 loops needed? (3 replies)
766. [SOLVED:] Need code to copy data from closed workbook (2 replies)
767. [SOLVED:] dependent dropdown list (4 replies)
768. [SOLVED:] Insert a function to delete any words with less than 3 characters in a VBA code (11 replies)
769. Add two arrays A and B with dimensions n×m. (2 replies)
770. [SOLVED:] VBA find&replace with conditions (2 replies)
771. Having a daily data entry sheet that autopopulates into a pivot table. (0 replies)
772. a macro to Copy from multiple sheets to a new workbook without macro (4 replies)
773. Comparing Two Workbooks Error (3 replies)
774. [SOLVED:] Finding a specific file across several subfolders? (5 replies)
775. SLOW VBA (20+ minutes) with many loops and VLOOKUPS. Help please. (17 replies)
776. How to use part of filename without changing the filename (3 replies)
777. [SOLVED:] Transposing a vertical table into a horizontal table (5 replies)
778. sum columns form each sheets to one column in Main sheet (4 replies)
779. Need help with NETWORKDAYS.INTL() (1 replies)
780. Need help with TAT calculation (21 replies)
781. Problem with Application.OnTime (5 replies)
782. Sleeper: VBA function "sub not defined" (4 replies)
783. [SOLVED:] loop sum (3 replies)
784. [SOLVED:] Sorting sections within large table (54 replies)
785. [SOLVED:] Loop through All worksheets and change to Proper case (7 replies)
786. VBA Combine PNG/JPG to an animated Gif (3 replies)
787. [SOLVED:] How To Save, Rename, and Send Multiple Sheets, As Separate Attachments In Outlook (4 replies)
788. [SOLVED:] 2016 Excel VBA Code for Locking a Cell after Data Entry (4 replies)
789. [SOLVED:] VBA to set Azure label (3 replies)
790. [SOLVED:] VBA Runtime Error 9 - Trying to copy same sheet from multiple workbooks (6 replies)
791. [SOLVED:] UserForm.Show method not supported? Created UserForm using code (4 replies)
792. [SOLVED:] Add table from pdf to excel macro (2 replies)
793. VLOOKUP with VBA to loop and paste multiple images in result table (2 replies)
794. [SOLVED:] Autofilter and create new workbook loop (3 replies)
795. Populating Content Controls in Word document from Excel workbook (same names) (3 replies)
796. Excel to Word - Remove Pages where bookmarks are not used (5 replies)
797. [SOLVED:] Find Empty Cell in Range From Bottom Up (3 replies)
798. Data consolidation from multiple PDFs to excel (3 replies)
799. [SOLVED:] getopenfilename path in listbox? (14 replies)
800. [SOLVED:] VBA to modify another VBA (3 replies)
801. [SOLVED:] Sum values in 1D arrays on different sheets - new sheets added annually (25 replies)
802. VBA code does not perform any action (4 replies)
803. Use VBA to PDF Multiple other files from Excel (1 replies)
804. [SOLVED:] Error in finding last row with data (24 replies)
805. copy cells from all sheets to one main sheet (11 replies)
806. [SOLVED:] Creating a Message Box in Excel VBA (9 replies)
807. [SOLVED:] Data Consolidation with VBA (24 replies)
808. Identify combined and individual user codes and divide them in seperate cells - VBA (5 replies)
809. [SOLVED:] Merge variable text (4 replies)
810. [SOLVED:] VBA Help - Match x and y axis, and pull data (6 replies)
811. Insert data at the end of page or last (2 replies)
812. [SOLVED:] Macro Debug Help (2 replies)
813. How to recall a VBA function in Power Pivot Model? (2 replies)
814. [SOLVED:] Convert a formula (5 replies)
815. [SOLVED:] Highlight row if two matches are found (4 replies)
816. Issue: When selecting a ActiveX Checkbox my screen flickers. (0 replies)
817. VBA for Excel Kanban tool (1 replies)
818. [SOLVED:] Adding seven days to a specific date, but it must always be the following Monday (3 replies)
819. [SOLVED:] Not Working: Code to Clear ActiveX Check Boxes (14 replies)
820. Connection to DB2 DAtabase (0 replies)
821. [SOLVED:] Question: Clear Data within Range VBA (14 replies)
822. [SOLVED:] Unable to Run Macro for Excel Sheet to Format (15 replies)
823. [SOLVED:] Transpose group of numbers from a column with guided logic by a second column (9 replies)
824. multiple pivot tables to a worksheet using Excel (14 replies)
825. Infinite FOR EACH loop when second application opened (4 replies)
826. [SOLVED:] excel not multiplying correctly (10 replies)
827. Macro creating Comma separated Key (11 replies)
828. Ticked check boxes that create a new list - VBA? (4 replies)
829. Add worksheet change event to all sheets during runtime_new (6 replies)
830. [SOLVED:] Userform: Combining 2 values into 1 record (5 replies)
831. How to Sort Excel File (2013) with 4 or 5 Keys in VBA (3 replies)
832. [SOLVED:] For each sheet in between two sheets criteria - VBA (5 replies)
833. Code for IF statement referencing two more sheets and color formatting (3 replies)
834. [SOLVED:] Showing numbers in 1000's, but not rounded (2 replies)
835. [SOLVED:] Copy Insert Row At Start End Or Middle with different Columns same row range (2 replies)
836. Faster way to delete rows based on criteria? (9 replies)
837. Combine Multiple Csv Files Into one Worksheets with file name as header (9 replies)
838. [SOLVED:] apply distinct formulas to autocomplete different columns in a specific table (2 replies)
839. VBA code to switch system language to English (0 replies)
840. Count successful create blank row (1 replies)
841. [SOLVED:] Merge two tables into one - VBA help? (11 replies)
842. [SOLVED:] Autofill NOT COPYING formula (5 replies)
843. Conditional Formatting (Macro) (1 replies)
844. Coding help for a complete VBA Beginner (1 replies)
845. VBA Code for Next Business Day (4 replies)
846. [SOLVED:] Multiplier (VBA) (10 replies)
847. Copy true number in another column (2 replies)
848. How to return to the original active cell? (2 replies)
849. VBA Code to Track Changes in Excel Sheet (1 replies)
850. Copy rows according to value of cells selected according to the value of other cells (7 replies)
851. [SOLVED:] EXCEL export creating double quotes (11 replies)
852. Copy certain columns of data from 2 worksheets that are auto-filtered to 1 summary wo (1 replies)
853. [SOLVED:] Compile Error Object Required (Excel VBA) (5 replies)
854. [SOLVED:] Excel 365 - Forms Control (5 replies)
855. Loping through each worksheet with an exception (12 replies)
856. [SOLVED:] VBA function with 3 arguments in 3 cells to the left of entered cell (6 replies)
857. [SOLVED:] Delete duplicate value for same date and other look up value. (6 replies)
858. Force switch the language to ENG (0 replies)
859. Running Total SUM Based on Criteria (2 replies)
860. Workbook & Worksheet referencing (5 replies)
861. [SOLVED:] ListBox mirror TextBox and Copy to Excel Table (3 replies)
862. [SOLVED:] vba combobox list on Userform has blanks (9 replies)
863. insert only the first 4 images from folder (3 replies)
864. Copy column, copy list from another document and use that to replace multiple values (0 replies)
865. VBA: concatenate multiple cell data (3 replies)
866. [SOLVED:] Method value of object range failed. (4 replies)
867. Take several screenshots one after another of a table (6 replies)
868. [SOLVED:] Truncate number to two decimal places without rounding (6 replies)
869. [SOLVED:] VBA Find string and add hyperlink (7 replies)
870. Cannot use that command on overlapping selections- delete row code (1 replies)
871. [SOLVED:] Highlight Pay Dates on Userform Calendar (14 replies)
872. [SOLVED:] VBA: If number found in column B:C in excel sheet reduce numbers by -1 (3 replies)
873. create treeview with 2 columns (1 replies)
874. Add/Remove pivot fields via macro- Help req to change existing code (3 replies)
875. Linear Interpolation (3 replies)
876. [SOLVED:] Excel VBA if condition then copy other cells to another worksheet (8 replies)
877. [SOLVED:] Using a function with part of an array (14 replies)
878. [SOLVED:] No Intellisense for "Sheets" Object in Excel VBA? (6 replies)
879. [SOLVED:] VLOOKUP Error : Need a VBA to copy matching row cell data in sheet1 from sheet2 (2 replies)
880. vba add worksheet checkboxes (4 replies)
881. Using VBA to copy data to new sheet and find data from other sheets (5 replies)
882. [SOLVED:] VBA: Find the position of occurrence of text in sentence (9 replies)
883. My script opens a large workbook - too slow - any fixes? (7 replies)
884. [SOLVED:] How To Change VBA Copy Rows "X" Number of Times (4 replies)
885. [SOLVED:] Intercept an splwow64.exe error (3 replies)
886. [SOLVED:] How to save a macro excel? (2 replies)
887. Tricky situation in excel ( (15 replies)
888. [SOLVED:] tooltip macro (6 replies)
889. How to use VBA for multiple rows? Now I have code for 1 row. (3 replies)
890. [SOLVED:] Fiscal Date year changes automatically (9 replies)
891. Looking to paste without changing the format of the cells pasted into (9 replies)
892. Hello, I have tree macros and I want to link two of them: 1. The first one( Report m (2 replies)
893. [SOLVED:] VBA comparison with ActiveCell.Offset (14 replies)
894. [SOLVED:] Overflow Error Trying to Calculate Percentages (9 replies)
895. [SOLVED:] Vlookup across Workbook (6 replies)
896. Declare function no longer works (13 replies)
897. VBA code to delete and replace this month's data (9 replies)
898. [SOLVED:] Filter month based on file name contains months (5 replies)
899. vba partial names variables (14 replies)
900. [VBA - UserForm] Change "Status" cells in all duplicated rows at the same time (2 replies)
901. How to replace specific formulas by values and then generate several xlsx/pdf filenam (5 replies)
902. [SOLVED:] Sending and receiving ASCII commands in excel (14 replies)
903. [SOLVED:] Merging Error (8 replies)
904. How to Structure Conditional Statement for an Array (2 replies)
905. Value out row based on a cell value (5 replies)
906. [SOLVED:] Converter Function (3 replies)
907. Important security change by Microsoft (2 replies)
908. Getopenfilename - File dialog hidden (6 replies)
909. ActiveSheet.Pictures.Paste runtime error (8 replies)
910. [SOLVED:] VBA Loop through column, copy specific cells, and stop when i meets a red cell? HELP (14 replies)
911. group by column (4 replies)
912. One Macro for Copy/Paste, Formula, Colouring and Hyperlinking for at home (4 replies)
913. I want to copy a value from a previous sheet, every day. (3 replies)
914. [SOLVED:] VBA macro for print out (12 replies)
915. Trying to find a way to find matching values, their row number and update whole rows (1 replies)
916. Text file import texttocolumns vs querytable.add (5 replies)
917. [SOLVED:] VBA Sort Data Descending Order in two tables (4 replies)
918. Macro to compare sheetname from one workbook with another and take actions depending (3 replies)
919. "Can't find project or library" error (5 replies)
920. Daily Dose Of Excel (2 replies)
921. VBA to Search More than One Worksheet in a Workbook (2 replies)
922. Module to Calculate from Two Tables (2 replies)
923. VBA Assistance needed - lookup, match and copy command (17 replies)
924. Refer to Excel collections in VBA with a "variable" name? (11 replies)
925. Excel Help - (0 replies)
926. [SOLVED:] Make BackUps of files Using Excel List (6 replies)
927. How to post predefined cell value to active cell (11 replies)
928. [SOLVED:] SQL query using where with multiple criterias (3 replies)
929. [SOLVED:] Userform command button does not respond when calling userform from custom ribbon (1 replies)
930. [SOLVED:] Help with Find and replace code (4 replies)
931. CommandButton Back Colour is not set on WorkBook Open (5 replies)
932. [SOLVED:] Else statement in loop (3 replies)
933. [SOLVED:] Filling array bas on vba formula (8 replies)
934. [SOLVED:] How to convert Index(match.. (Left(Right...)..)..) into VBA (excel) (4 replies)
935. How to use uppercase in an additional column? (4 replies)
936. [SOLVED:] Change destination folder (2 replies)
937. Copy the last category and insert custom text (2 replies)
938. [SOLVED:] Extract files in a folder containing contents in column A and move them to own folder (7 replies)
939. [SOLVED:] Dragging Formula down through merged cells (4 replies)
940. scraping element in web page.... (0 replies)
941. Compare Multiple Columns between two workbooks and update the values in the second wo (2 replies)
942. [SOLVED:] Run time Error 1004 when assigning cell value (2 replies)
943. [SOLVED:] Unexpected Numerical Value in Table When Adding Blank Line (5 replies)
944. [SOLVED:] Include the exact name from one cell in to a formula in another cell (9 replies)
945. Pivot filter by each item and copy to new sheet (3 replies)
946. [SOLVED:] AVERAGEIFS formula - adjust to exclude values of 0 (14 replies)
947. Save-As name based on cell value (2 replies)
948. VBA: fetch data from cells and concatenate matching data heading in another sheet (6 replies)
949. Roll column forward and hard paste previous (1 replies)
950. [SOLVED:] Copy unique values from new data and append to existing list in another worksheet (7 replies)
951. link pictures from Sharepoint to Excel macro (0 replies)
952. VBA: Remove line in cell if substring present (1 replies)
953. Combine these codes to one (5 replies)
954. Finding minimum value Using VBA (3 replies)
955. incrementing a set string by1 (1 replies)
956. VBA creating relative references to table columns (5 replies)
957. [SOLVED:] Unmerge Cells & Copy Cells Down to Next Line of Data (25 replies)
958. Help fixing and cleaning up code (2 replies)
959. Using VBA to rename or delete subfolders (8 replies)
960. [SOLVED:] Remove part of a string (4 replies)
961. [SOLVED:] Type Mismatch Error when Setting WorkSheets (4 replies)
962. [SOLVED:] Error with progress bar chart (2 replies)
963. What does line 7 mean (2 replies)
964. [SOLVED:] Highest consecutive values in column (13 replies)
965. [SOLVED:] How to move column of data down (shift it by 1 row) (2 replies)
966. VBA Excel deleting duplicates (2 replies)
967. VBA- No form on Mac (0 replies)
968. Static cell (3 replies)
969. Sleeper: Application FileSearch help (1 replies)
970. giving a direction to VBA to open a specific file (1 replies)
971. [SOLVED:] Why For each rw is empty? (6 replies)
972. How to sort single column (selected)? (2 replies)
973. [SOLVED:] How correctly check for error? (2 replies)
974. [SOLVED:] Single workbook - Cannot run the macro... the macro may not be available in this work (2 replies)
975. [SOLVED:] VBA to enter formula using variables: Error 438 (2 replies)
976. Format Incremental Value as Two Digit String (8 replies)
977. [SOLVED:] Delete multiple rows based on cell color (3 replies)
978. Need help updating sort automatically, but only if a cell has a number (8 replies)
979. Export multiple sheets to PDF per product by looping through slicer (5 replies)
980. VBA for Depreciation Calculation (1 replies)
981. Create Table with quartils (18 replies)
982. VBA and Budgeting (2 replies)
983. [SOLVED:] Create Name in Name Box (7 replies)
984. [SOLVED:] Layout list by VBA (3 replies)
985. [SOLVED:] Excel VBA search other email account than default (2 replies)
986. Select multiple named ranges and clear contents (2 replies)
987. add multiple rows with content in another tab (0 replies)
988. finding partial string into another workbook, then do several cell copy when found (2 replies)
989. VBA macro to search contents of a folder of Excel Workbooks (17 replies)
990. Trouble switching to the M1 Mac or Excel in Office16.54 (9 replies)
991. Collect data from a multi-sheets workbook (1 replies)
992. [SOLVED:] Copy formula down in next blank row andn hard paste previous results (6 replies)
993. Match values between tabs and insert value from other column (2 replies)
994. [SOLVED:] Create Copies of Workbook with Sheet2 Formulas Referencing Sheet1 Not Workbook Copied (3 replies)
995. [SOLVED:] Select & hide multiple rows based on cell value (2 replies)
996. [SOLVED:] Problem Evaluate Variables (12 replies)
997. Excel Search Code Help (1 replies)
998. How to create a coordinate system for a svg picture in excel? (0 replies)
999. [SOLVED:] Compare column values (2 replies)
1000. Calendar Control in Excel VBA (2 replies)

Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.