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 174

751. Worksheet Change Referencing Cell in Another Sheet (4 replies)
752. insert selected row from listbox to excel table (5 replies)
753. HLEP!! I need help modifying this code. (0 replies)
754. VBA Help on drop down list (10 replies)
755. Need vba to code to split data depends upon col I:I and col J:J (4 replies)
756. Help needed- Analysis of splitting of orders (28 replies)
757. [SOLVED:] How to pull information from different columns of data from the same row? (1 replies)
758. [SOLVED:] Help for viable registration solution and code improvement (1 replies)
759. [SOLVED:] IF Countif and Textjoin - Help required (14 replies)
760. [SOLVED:] how to force users to enable macros (4 replies)
761. [SLEEPER:] How to convert number of color to RGB? (14 replies)
762. [SOLVED:] How to range table "t" from ActiveSheet "Charts"? (3 replies)
763. Doppelte Einträge zusammenfassen (14 replies)
764. Can someone recommand an obfuscator for xlsm? (10 replies)
765. check if serial number is repeated (7 replies)
766. [SOLVED:] AutoComplete doesn't recognize Cell A1, it starts getting information from the second (14 replies)
767. Image embed (0 replies)
768. [SOLVED:] Every time you open the UseForm, it generates a new code (3 replies)
769. Return latest result for work schedule (1 replies)
770. Search for a match files using value from selected cell in Folder or Subfolders (10 replies)
771. [SOLVED:] Search for name and letter matches and split equally (28 replies)
772. [SOLVED:] VBA Userform macro help for range dates (2 replies)
773. [SOLVED:] Copy Data from one workbook to another - based on tab name (0 replies)
774. Checkboxes and filters (2 replies)
775. [SOLVED:] create Summary report from information on the DATA Tab. (2 replies)
776. Copy and paste specific ranges (5 replies)
777. [SOLVED:] VBA Excel - reduction of lines (2 replies)
778. Copy and paste styles of diagram (14 replies)
779. Insert Multiple Image and name image in Userform (0 replies)
780. Instant change between one textbox to another. (1 replies)
781. Criteria based lookup (3 replies)
782. [SOLVED:] MkDir and "Path Not Found" Run-time error 76 (2 replies)
783. [SOLVED:] need Code to select value from dropdown list using numeric values (13 replies)
784. [SOLVED:] Expanding the range (5 replies)
785. [SOLVED:] 3 questions regarding VBA Excel (1 replies)
786. Sleeper: Find a Partial Match from Location Sheet (4 replies)
787. [SOLVED:] HOW TO CONCATENATE: IF(condition;result string;result string) result string? (8 replies)
788. Make a declared variable equal to values from multiple cells (2 replies)
789. Array loop values (2 replies)
790. How to close all the hyperlinked files automatically? (21 replies)
791. [SOLVED:] Formula with OR condition does not return expected result (5 replies)
792. VBA script updating values other sheet (3 replies)
793. Help to remove duplicate strings from table (12 replies)
794. search and copy the line (0 replies)
795. Helper columns to solve problem (14 replies)
796. [SOLVED:] looping through functions (5 replies)
797. [SOLVED:] Textbox within a Frame in UDF unable to take focus. Why not? (13 replies)
798. [SOLVED:] storing processed data (9 replies)
799. [SOLVED:] insert auto serial number in user form (2 replies)
800. Copy text from text file between keyword in rows. (4 replies)
801. wrap broken lines in one line in a given text or log file (9 replies)
802. [SOLVED:] Conditional Format:Need to compare 2 cells with any other 2 cells for the same number (1 replies)
803. How to split a big text file (with more than 500000 lines) in to smaller files (8 replies)
804. File Selection- if user cancels- End Sub Then call macro1 (3 replies)
805. SUMIFS on multiple rows and columns, based on a mapping (0 replies)
806. [SOLVED:] Delete Rows if Cost Code Bucket is Zero (10 replies)
807. strAddress = .ActiveCell.Address Run-time error 438 when switching sheets (21 replies)
808. [SOLVED:] Compile Error Private WithEvents oCbarEvents As CommandBars and Private Sub Worksheet (6 replies)
809. [SOLVED:] Check if within multiple ranges check problem (8 replies)
810. Data validation and manipulating input (12 replies)
811. Macro Or Command To Change Photo In Excel - Urgent Weekend Help Needed (29 replies)
812. Setting tab order, adding ability to stop/start code and refine functionality (40 replies)
813. Pull SQL Data into Excel by Date Range (3 replies)
814. [SOLVED:] Deleting Worksheet Stops Script (6 replies)
815. copy information with vba (2 replies)
816. [SOLVED:] VBA code to pull in data from SQL table (7 replies)
817. [SOLVED:] clear dependant drop down boxes (5 replies)
818. [SOLVED:] Is it possible to store range objects in an variant array? (5 replies)
819. [SOLVED:] Re-Arrange Columns after Import (6 replies)
820. Loop Through Data Validation List and Copy Values Given By Each Item (7 replies)
821. Add the value taken from the user to my range for ActiveX ComboBox (7 replies)
822. [SOLVED:] Compile Error Syntax Error (5 replies)
823. [SOLVED:] Countif in VBA Module (4 replies)
824. Shell Command results in Runtime Error 5 - but path appears to exist (5 replies)
825. How to prevent duplicate value (1 replies)
826. [SOLVED:] Create Summary (3 replies)
827. [SOLVED:] Zero Out Column if another column has a certain qualifier (11 replies)
828. [SOLVED:] How to Change the Value of a Cell based on the values of two other cells (3 replies)
829. [SOLVED:] Multi-sheet procedure (2 replies)
830. Macro for inserting rows if value (7 replies)
831. [SOLVED:] Date Help (16 replies)
832. copy with loop double variable (3 replies)
833. Market data and charts (0 replies)
834. expenses compared to the budget (1 replies)
835. Not Getting Sum Result From All Sheets (2 replies)
836. HELP!! can't figure out details for a file-combining macro (13 replies)
837. [SLEEPER:] Opened Workbooks are still opened after executing Macro (Workbook.Close doesn't work) (28 replies)
838. [SOLVED:] Cumulative based of criteria (6 replies)
839. [SOLVED:] mismatch when sum values in multiple textboxes (8 replies)
840. [SOLVED:] Application Visible with more than 1 workbook (7 replies)
841. Excel VBA folder-search-tool (24 replies)
842. [SOLVED:] How to create a values only copy of WB while keeping formatting and filters in tact? (20 replies)
843. Excel file always opens in read-only mode when opening from sharepoint (0 replies)
844. Open and Close Workbooks | best Practices (5 replies)
845. Column getting truncated (7 replies)
846. [SOLVED:] Help: Capture file location on the first opening of a workbook/workbook open event (2 replies)
847. Script not working after moving data to SharePoint (4 replies)
848. [SOLVED:] Worksheet SelectionChange Error - Target.Address - if statement (5 replies)
849. [SOLVED:] Userform is not displaying anything when i change a "box" to visible or not visible (8 replies)
850. [SOLVED:] Lookup formula not returning the correct result (4 replies)
851. Show graph in userform but via sharepoint (1 replies)
852. Variant-type object array element is deallocated by With statement (6 replies)
853. Userform error (2 replies)
854. [SOLVED:] Depending on the marked radio button, the text in the cell changes (2 replies)
855. [SOLVED:] Variable look up fields based on Value from different cell. (6 replies)
856. Nasty spreadsheet (16 replies)
857. [SOLVED:] Macro to split data based on the value from specific column (23 replies)
858. [SOLVED:] Adding Conditional Formatting using AND (5 replies)
859. [SOLVED:] VBA Autofilter Loop (27 replies)
860. I'm trying to perform two validations on a range of cells at the same time (3 replies)
861. Join two pieces of code (2 replies)
862. [SOLVED:] IIF function in Excel 365 (3 replies)
863. [SOLVED:] How to maintain a consolidated checklist for preparing dashboard (17 replies)
864. [SOLVED:] Dependant dropdown error (6 replies)
865. Find Text Within A Row, Then Copy Information Below That Cell To Second Worksheet (6 replies)
866. Making Program work with different number formats (1 replies)
867. Please help me to update array between 2 sheets (7 replies)
868. List Box, runtime error (4 replies)
869. [SOLVED:] Writing trig equations in Excel (10 replies)
870. [SOLVED:] Lookup Values from List and Copy data unde headings VBA (7 replies)
871. using application.getopenfilename keeps opening new app (9 replies)
872. [SOLVED:] Sending emails with attachments (3 replies)
873. Excel VBA and arrays (1 replies)
874. [SOLVED:] ComboBox display incorrect text (9 replies)
875. Connection to cloud based SQL Server database using VBA (1 replies)
876. Excel on Android (0 replies)
877. [SOLVED:] Merging TXT files in a current worksheet using VBA (15 replies)
878. VBA script works when stepped through, but not when run in realtime (13 replies)
879. [SOLVED:] Copy Heading number in condition (9 replies)
880. VBA error (2 replies)
881. [SOLVED:] userform indirect alternative (14 replies)
882. Macro that updates values in a function (4 replies)
883. [SOLVED:] Please Help! Code For Multiple Checkbox Returning to One cell in Excel VBA User Form (3 replies)
884. [SOLVED:] Adding VBA Conditional Formatting (4 replies)
885. General VBA Inquiry (3 replies)
886. [SOLVED:] Application.Caller return value (13 replies)
887. EXCEL VBA VLookUp (4 replies)
888. [SOLVED:] Please Help! Code For Option Buttons in Excel VBA User Form (4 replies)
889. Extending the data range of a scatter chart by dragging. (0 replies)
890. [SOLVED:] VBA - Clean up a table with returning values (6 replies)
891. VBA - Convert data table into a long list (multiple columns) (3 replies)
892. [SOLVED:] Filter function to pull results based on drop down non VBA solution (1 replies)
893. VBA Code to copy data from two sheet ,paste into corresponding sheet (4 replies)
894. Import image from path in adjacent cell (7 replies)
895. [SOLVED:] clear last but one line to a userform (12 replies)
896. MoveLast ERROR (9 replies)
897. VBA to make 1st column of a text to columns operation "CLEAN" (2 replies)
898. Simplifying Code (7 replies)
899. [SOLVED:] clear last line (2 replies)
900. VBA - Copy and Paste Data Base into an existing Sheet (1 replies)
901. Setting a Dynamic Table Range in a VBA (4 replies)
902. [SOLVED:] VBA how to use date to write file name in PDF (13 replies)
903. [SOLVED:] BUILD A SET OF DATA BASED ON SOME FILTERS (4 replies)
904. [SOLVED:] Sum entire column by like IDs (3 replies)
905. [SOLVED:] VBA - Copy Paste data to another sheet based on criteria (3 replies)
906. Finding last cell in a column (2 replies)
907. [SOLVED:] VBA - Concatenate columns with delimiter (7 replies)
908. [SOLVED:] Adding odd numbers in VBA (2 replies)
909. Discrete Time Conversion Problem (8 replies)
910. [SOLVED:] Creating date and time stamp (5 replies)
911. Sleeper: How can I automate arranging cell values by repeating and transposing values (8 replies)
912. RE: Insert/Embed outlook mail using vba Excel (1 replies)
913. [SOLVED:] RE: Excel Formula to update Account number based on signage using mapping key (8 replies)
914. [SOLVED:] VBA help to move all images from a cell, not folder? (15 replies)
915. How can I change the default chart callout color? - text & border? (2 replies)
916. [SOLVED:] message appears in adjacent column when name appears in column A (10 replies)
917. Selecting Sheets based on a VBA array (8 replies)
918. [SOLVED:] VBA to Update Excel Workbook Properties (3 replies)
919. VBA Macro: Text Split by defined # of characters - word dropping issue (7 replies)
920. Object required error in dictionary (8 replies)
921. VBA: What can cause of truncation of significant digits double precision variable? (17 replies)
922. [SOLVED:] Need help with text to column like formulas (3 replies)
923. Help! What is wrong? My code is not looping! (16 replies)
924. Hello friends. Please help ! COUNTIF formula ? (3 replies)
925. [SOLVED:] record # if data in other columns in same row (11 replies)
926. Loop on Single cell (1 replies)
927. Deleting duplicate values from two different columns (10 replies)
928. Macro to consolidate data from different files in a folder (1 replies)
929. Counting repetitions of string of words to counting group of words in one cell (1 replies)
930. [SOLVED:] Geometric Brownian Motion Help (21 replies)
931. [SOLVED:] Loop through inserting row from one sheet to another, at least 2 loops needed? (3 replies)
932. [SOLVED:] Need code to copy data from closed workbook (2 replies)
933. [SOLVED:] dependent dropdown list (4 replies)
934. [SOLVED:] Insert a function to delete any words with less than 3 characters in a VBA code (11 replies)
935. Add two arrays A and B with dimensions n×m. (2 replies)
936. [SOLVED:] VBA find&replace with conditions (2 replies)
937. Having a daily data entry sheet that autopopulates into a pivot table. (0 replies)
938. a macro to Copy from multiple sheets to a new workbook without macro (4 replies)
939. Comparing Two Workbooks Error (3 replies)
940. [SOLVED:] Finding a specific file across several subfolders? (5 replies)
941. SLOW VBA (20+ minutes) with many loops and VLOOKUPS. Help please. (17 replies)
942. How to use part of filename without changing the filename (3 replies)
943. [SOLVED:] Transposing a vertical table into a horizontal table (5 replies)
944. sum columns form each sheets to one column in Main sheet (4 replies)
945. Need help with NETWORKDAYS.INTL() (1 replies)
946. Need help with TAT calculation (21 replies)
947. Problem with Application.OnTime (5 replies)
948. Sleeper: VBA function "sub not defined" (4 replies)
949. [SOLVED:] loop sum (3 replies)
950. [SOLVED:] Sorting sections within large table (54 replies)
951. [SOLVED:] Loop through All worksheets and change to Proper case (7 replies)
952. [SLEEPER:] VBA Combine PNG/JPG to an animated Gif (3 replies)
953. [SOLVED:] How To Save, Rename, and Send Multiple Sheets, As Separate Attachments In Outlook (4 replies)
954. [SOLVED:] 2016 Excel VBA Code for Locking a Cell after Data Entry (4 replies)
955. [SOLVED:] VBA to set Azure label (3 replies)
956. [SOLVED:] VBA Runtime Error 9 - Trying to copy same sheet from multiple workbooks (6 replies)
957. [SOLVED:] UserForm.Show method not supported? Created UserForm using code (4 replies)
958. [SOLVED:] Add table from pdf to excel macro (2 replies)
959. VLOOKUP with VBA to loop and paste multiple images in result table (2 replies)
960. [SOLVED:] Autofilter and create new workbook loop (3 replies)
961. Populating Content Controls in Word document from Excel workbook (same names) (3 replies)
962. Excel to Word - Remove Pages where bookmarks are not used (5 replies)
963. [SOLVED:] Find Empty Cell in Range From Bottom Up (3 replies)
964. Data consolidation from multiple PDFs to excel (3 replies)
965. [SOLVED:] getopenfilename path in listbox? (14 replies)
966. [SOLVED:] VBA to modify another VBA (3 replies)
967. [SOLVED:] Sum values in 1D arrays on different sheets - new sheets added annually (25 replies)
968. VBA code does not perform any action (4 replies)
969. Use VBA to PDF Multiple other files from Excel (1 replies)
970. [SOLVED:] Error in finding last row with data (24 replies)
971. copy cells from all sheets to one main sheet (11 replies)
972. [SOLVED:] Creating a Message Box in Excel VBA (9 replies)
973. [SOLVED:] Data Consolidation with VBA (24 replies)
974. Identify combined and individual user codes and divide them in seperate cells - VBA (5 replies)
975. [SOLVED:] Merge variable text (4 replies)
976. [SOLVED:] VBA Help - Match x and y axis, and pull data (6 replies)
977. Insert data at the end of page or last (2 replies)
978. [SOLVED:] Macro Debug Help (2 replies)
979. How to recall a VBA function in Power Pivot Model? (2 replies)
980. [SOLVED:] Convert a formula (5 replies)
981. [SOLVED:] Highlight row if two matches are found (4 replies)
982. Issue: When selecting a ActiveX Checkbox my screen flickers. (0 replies)
983. VBA for Excel Kanban tool (1 replies)
984. [SOLVED:] Adding seven days to a specific date, but it must always be the following Monday (3 replies)
985. [SOLVED:] Not Working: Code to Clear ActiveX Check Boxes (14 replies)
986. Connection to DB2 DAtabase (0 replies)
987. [SOLVED:] Question: Clear Data within Range VBA (14 replies)
988. [SOLVED:] Unable to Run Macro for Excel Sheet to Format (15 replies)
989. [SOLVED:] Transpose group of numbers from a column with guided logic by a second column (9 replies)
990. [SLEEPER:] multiple pivot tables to a worksheet using Excel (14 replies)
991. Infinite FOR EACH loop when second application opened (4 replies)
992. [SOLVED:] excel not multiplying correctly (10 replies)
993. Macro creating Comma separated Key (11 replies)
994. Ticked check boxes that create a new list - VBA? (4 replies)
995. [SLEEPER:] Add worksheet change event to all sheets during runtime_new (6 replies)
996. [SOLVED:] Userform: Combining 2 values into 1 record (5 replies)
997. How to Sort Excel File (2013) with 4 or 5 Keys in VBA (3 replies)
998. [SOLVED:] For each sheet in between two sheets criteria - VBA (5 replies)
999. Code for IF statement referencing two more sheets and color formatting (3 replies)
1000. [SOLVED:] Showing numbers in 1000's, but not rounded (2 replies)

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