View Full Version : Excel Help
- ListBox on Userform doesn't refresh
- Filtering out a specific range and pasting it a row below
- new logic need to add to the code
- [SOLVED:] Code To Save Worksheets As Individual .txt But Only The First 9 Columns Of Each sheet
- [SLEEPER:] VBA Books/Courses For A Novice
- Help Needed: Picking Shortage Corresponding Date
- Copy Used Row
- Macro to create new sheets when master is updated
- Some last problems with barcode prog. ' SetFocus, Barcode Length ,Autosave'
- [SOLVED:] Time Rounding VBA (Custom Function?)
- Nested Loop to create multiple series in a single chart. Where did I go wrong??
- Pls correct my code (sending mails)
- [SOLVED:] Filtering unique data & Remove duplicate rows & save unique record range in new book
- How to check if a cell contains something or not
- [SOLVED:] Template SaveAs on First Open
- Corrupt data in workbook?
- Path/File Access Error - Replacing text in xml with text from excel
- VBA code to subtract the time diferences in the userform.
- Data Merge - Identify Rows Not Pulled Over from Sheet2 into Sheet1 - VBA
- Problem with Folder Picker
- [SOLVED:] VBA Code to Match US Region to the State that is entered
- Get multiple values from sheet and assign to textboxes
- [SOLVED:] Compare two lists of numbers
- [SOLVED:] Delete row if it contains a certain word or phrase - and use array
- Extracting the URLs from a tweet
- [SOLVED:] If Cell is Highlighted -> Copy Row and Paste in Sheet2
- Cumulative sum based on a condition
- small logic is missing (auto mail)
- [SOLVED:] Left & Copy
- [SOLVED:] Combine worksheets and move row and columns
- [SOLVED:] Help Loop and Count if more than one unique
- Copy Worksheet to another Workbook - VBA
- Looping to find difference in time within string
- For loop delete entire row if cell is blank
- [SOLVED:] VBA Celloffset function in For Each Cell function not work
- Compare 2 different excel sheets
- Delete duplicate rows if they do not contain a specific word
- Run "x" number of random draws and calculate totals against a pre-defined set.
- Read outlook emails copy to excel.
- Range not selecting correctly?
- WORKDAY #VALUE ERROR
- [SOLVED:] Find unique records between 2 sheets and delete
- Active X component cant create object
- Time of creation of shape
- VBA code to lock the active sheet
- Can't get code to loop through worksheets
- How to check for conflicts in a schedule?
- VBA select/send email based off criteria
- run msgox at certain times of the day only if a specific workbook is still open
- Convert table of contents to another format
- [SOLVED:] A text box in excel that contains a Picture taken from a file
- path string in cell
- [SOLVED:] Linking Label Caption To Textbox
- userform menu problem
- [SOLVED:] How to reuse variable value across Private modules
- ThisWorkbook.SaveAs fails at second attempt
- disable close "X" button
- Using different Range in the body of email based on row criteria - Appointments
- Code error 9. Create a workbook and worksheets in relation with variables
- [SOLVED:] Fill Series of Sequential Numbers in Column A Based on Last Value in Column B - VBA
- [SOLVED:] Combine two arguments into one.
- [SOLVED:] Copy sheet and paste values - VBA
- Concatenate Multiple Cells
- Object required (Error 424)
- [SOLVED:] Copy values only not the formats.
- VBA to search in sheet1, match data in sheet2, return search results in sheet1
- Simplifying and looping VBA
- Modify VBA code for Advanced Filtering
- [SOLVED:] duplicating range
- ComboBox change for multiple comboboxes
- VBA auto outlook 2016 to send e-mail based off criteria
- [SOLVED:] Formula to calculate AVERAGE but only to last used row in a grid.
- [SOLVED:] Average values within time range for matching header
- Compare if any changes then highlight
- paste special values for multiple pivots
- VBA
- VBA
- [SOLVED:] Grab data between two dates using arrays
- VBA Loop help (Error Loop without Do)
- Excel custom data validation with drop down list
- Index / Match / and search for result between two dates and a little bit more complex
- [SOLVED:] Got Excel< 2007? Test if "Action Will Reset Project"
- Select added value from dropdown menu, program output
- Everytime I open my excel file open this file as new excel instance
- AverageIfs Dynamic Formula -Criteria Not Working?
- Making a leave tracker with VBA
- [SOLVED:] Create a new sheet / workbook for all Unique values (Including Pictures / Images)
- Two Workbooks - Search for Values in Workbook 2, Copy and Paste in Workbook 1
- disable cells DataValidation
- [SOLVED:] Need Some Help with SumProduct
- [SOLVED:] How to find which columns are being used in active chart
- [SOLVED:] "Run-time error '1004' on code to remove the ellipsis (...) character from a column
- [SOLVED:] Setting a found item to a Variable
- [SOLVED:] Replace certain cells in rows with values from same rows but in different column
- Pasting the contents from one sheet to a row after the last active row on another
- Not enough memory + Excel 2016
- Limiting User Entry on A Userform Combobox NOT working
- [SOLVED:] Last User Save
- [SOLVED:] Copying entire row from Sheet1 to Sheet2 if values in multiple cells matches
- [SOLVED:] Default to current date in textbox
- [SOLVED:] Reposition cursor in cell that contains the error
- [SOLVED:] VBA question on counters
- [SOLVED:] Error 1004
- VBA - Consolidating information from one sheet from multiple workbooks in the same ma
- [SOLVED:] Dynamically call function in sheet's VBA module
- Copy Data without Activating a Tab
- How to extract specified data to the other worksheet?
- Excel Error when arguments with multiple parameters are passed
- How to amend this code in order to copy the inserted comment also?
- [SOLVED:] Can someone tell me why this doesn't work.
- [SOLVED:] Type Mismatch Error
- Help subtracting sales from order
- For...Each + Merging Cells Leading to Error 2042 (Type Mismatch)?
- Macro to copy row, base in condition, into the botton of the table
- XMLHTTP - communicate with server - not working on Japanese OS
- Initiating a new instance of a class object
- Save worksheet as pdf using cell value and loop through work sheets
- VBA code to find current user default download folder, then open a specific file
- staffing rotation in excel
- [SOLVED:] help about my code (get data)
- [SOLVED:] Search a pdf file depended on textbox value in multiple folders and subfolders
- create filenames from the values in a MS Excel spreadsheet
- [SOLVED:] Compare 2 colums of different sheet and copy values for matching data
- Multiple Entry Dependent Drop Down Macro
- VBA Converter Required
- [SOLVED:] VBA Calculation
- VBA Insert array formula base on criterias
- [SOLVED:] VBA Question on InputBoxes to Fill Cells on Worksheet
- [SOLVED:] VBA Formatting Help
- Codes working for 2 templates but not the 3rd
- [SOLVED:] Formula for placing ascending and descending numbers
- Can't add new item to the listbox while running the userform
- Hyperlink
- VBA Error/Trapping/Identification
- VLOOKUP with variable workbook and worksheet names in macro
- [SOLVED:] Create a new workbooks for each Unique value
- [SOLVED:] merge 2 VBA enabled worksheets to 1 sheet
- [SOLVED:] VBA Code - setting cell background color doesn't hold with different selection.
- Help with time if/then in VBA
- VBA Help: Date/Time Stamp functionality
- Excel VBA to count the ADDITIONAL comments added to a cell
- Excel vba code to automate IE.
- [SOLVED:] Excel VBA -Comparing Two arrays
- Trying to only retrieve files that i do not already have
- Creating a dynamic piechart
- Vba to highlight the cell and remove duplicates
- [SOLVED:] Listbox - calculation based on selections
- [SOLVED:] (HELP) add multiple process to my code
- Passing an item and its key to another collection
- Error connecting to MySQL using VBA (3709 error)
- VBA code to store and count data filtered by other columns
- Identify keyboards with vba 7 (Excel)?
- [SOLVED:] grabbing error values
- [SOLVED:] Baffled by Runtime Error 1004 - Help Please
- [SOLVED:] return the value from 'A' which has the largest sum of values in 'B'
- Formula producing mixed results, may required VBA
- [SOLVED:] Process too long for counting received,sent mails etc. with Outlook
- VBA to loop through each row and subtract if conditions met
- [SOLVED:] Importing worksheets and retaining file order
- VBA error with parsing JSON
- Automating Data Retrieval From Terminal Emulator (OutsideView) with VBA
- Splitting multiple worksheet
- Filter Data and Copy to new worksheet
- [SOLVED:] Sorting in Excel VBA
- [SOLVED:] Pivots auto sort and dollar sign needs to be added
- [SOLVED:] To Uppercase
- [SOLVED:] Excel Worksheet_SelectionChange event not firing at all? (on both Office 2013 & 2016)
- [SOLVED:] Index & Match formula error
- Find values
- [SOLVED:] Problems with GetSetting function
- finding last column used and insert new data weekly
- Fliter listbox using checkbox
- Open File for Output hangs
- [SOLVED:] Setting the date as dd/mm/yyyy from a combined field
- dynamic way of Filter and delete
- [SOLVED:] Retrieve data(Time, From, subject, category) from Outlook inbox to Execl
- [SOLVED:] Is possible to show the UserForm of another Excel file?
- [SOLVED:] Application Defined or object Defined Error 1004 after every cell update
- [SOLVED:] Named Ranges - Same code, but one is cast as Variant and the other a Range?
- [SOLVED:] VBA Code to filter a list, then create new list in a new column
- FormatConditions.add to change cell color when something is entered
- [SOLVED:] Is MsgBox Suitable ?
- [SOLVED:] VBA Pivot Table- Datafields Horizontal to Vertical
- Run Time Error 13 (Type Missmatch)
- Excel templates and save as workbook
- [SOLVED:] Transpose non organized data
- formula error while cut/copy of cell contents
- [SLEEPER:] How to pick one webpage each from a collection of web page list!!!
- VBA UserForm Movement limit
- Fill Formula Down Column when Rows Inserted
- [SOLVED:] Help with SaveAs PDF
- [SOLVED:] Combining Data from multiple worksheets to a printable worksheet
- VBA - Excel Assistance on consolidating multiple workbooks into one
- [SOLVED:] Changing a cell font color upon cell entry & exit
- Error during import from webpage -> *** requires a JavaScript enabled browser.
- Paste multiple formatted word paragraphs into single Excel cell
- Arrays Compare
- Excel comments: a registered macro that doesn't work
- [SOLVED:] Need help with an vba macro for excel that adding an 0 in a number combination
- [SOLVED:] New-work-assignment / Sort data
- [SOLVED:] UDF called by another UDF sees Caller as an Object
- [SOLVED:] Countif or Similar Help Required and advise on Named Ranges
- How to fix this problem? "unable to set the visible property of the pivotitem class"
- Excel - Identify Shapes by Content
- UDF calculation very slow in excel 2016 (faster in 2010)
- [SOLVED:] Input cell value based on multiple dropdown list to populate
- Rename files using criteria in Excel
- VBA query while inspecting element on webpage
- Sleeper: Get duration of mp4 files
- [SOLVED:] copy rows if number doesn't exist in all worksheet
- [SOLVED:] How to get the index of ActiveChart
- excel file saving issues
- user form(vba macro)
- get file paths based on name criteria from folder
- Problems with xl2007
- [SOLVED:] Update column of selected items in Multi Select Listbox
- [SOLVED:] Recon between two spreadsheets across various columns
- Decorate my sheet as an interface
- Remove Duplicate Row IF Older
- [SOLVED:] Copy Data from one sheet to New Workbook with the New Header Name
- [SOLVED:] Assign value to pie chart
- Highlight and popup message Between employee dates are overlap using (vba)
- [SOLVED:] Macro for Conditional Formatting
- How to capture the lock time and event of System by vba?
- Sleeper: Gap in between the words in excel
- Help--Can't extract data from Mysql using cell content as select condition
- Union range vs Arrays (error out of range)
- [SOLVED:] Date Format in VBA
- sorting among workbooks
- [SOLVED:] callback an EditBox in the Ribbon
- [SOLVED:] ListBox Object -- Inconsistent behavior (sometimes unresponsive?)
- [SOLVED:] similar cells - grouping
- Producing hundreds of Multiple Regression analysis scenarios simultaneously
- Automation error
- [SOLVED:] Copy a column from excel and paste in the "To" section of a new email in Outlook
- Export single row from given sheet & append into existing MSAccess table.
- VBA replaces long number with # sign (Excel 2010)
- It's possible to add a Word document with a customized name?
- combine mutiple values into single cell based on criteria
- Should be a simple fix but not sure how to move and tweak my If statement....
- Relative Paths within Excel for CSV imports
- Looping Mirrored Cells between Worksheets
- Copy sheet to new workbook
- VBA code for multiple column loop - help please!!!
- Transfer row from list box to another sheet VBA
- Repairing & rebuilding workbook error
- Deleting All True Empty Rows in a worksheet
- VBA - HIDE/UNHIDE Rows Based on Output of a Formulated Cell
- (Single Workstation) Error, how to reset? Macros via Ribbon UI aren't firing...
- Specify which folder to open when using Get Open Filename
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.