View Full Version : Excel Help
- Moving data between sheets based on headers
- Numbers update as per Pivot table
- Show column headings and corresponding values/text based on dropdown selection
- Barcode Asterisks Around Date Formula
- vba - vlookup on data stored in array
- [SOLVED:] Run time error -2147417848 (80010108) Method "_range" of object "_worksheet" failed.
- Export specific sheet from a file to a specific sheet in many closed files
- Code for Slicer
- How to change code for sheet to work whole book
- VBA - Outlook to Excel
- Need help : fill listbox with search result
- VBA variable url webquery
- Force User to Enter Date but in UK format
- Excel VBA game help
- excel help
- Copy Data from one sheet to another IF cells are specific text colour
- VBA msgbox help
- Eliminating Pop-up when using RemoveDuplicates
- Turning Multiple Optionbuttons subs into one sub
- Aligning Columns and rows
- data transfer through loop
- Copying charts from all Excel worksheets onto Powerpoint slides
- Different Phone Number Formats from list of numbers
- Change Check Box character to text
- [SOLVED:] Search using two ranges
- Help with time diffrences
- Search for Specific Text within a Cell
- [SOLVED:] YTD SUM
- [SOLVED:] VBA to Copy / Paste into New Workbook With Different Layout by Column & Row Headings
- [SOLVED:] Filter between two dates on multiple ranges
- Auto update Form Text box with form editor name
- [SOLVED:] Changing code from copy entire row to copy specific cells
- Checking for MULTIPLE duplicates on save_click
- Run-time error "438"
- [SOLVED:] Switching worksheets unexpectedly after exiting UserForm
- Make Cell Blink 3 times
- [SOLVED:] Extracting intersecting values from two or more ranges
- [SOLVED:] Need help parsing subtext in cell
- [SOLVED:] Find zero
- [SOLVED:] Find specific words in a worksheet and change the font color of those words
- Distance between 2 locations 2D array
- [SOLVED:] How to fix Compile error: Else without if
- [SOLVED:] Help with renaming files (Name "xxxxxxx" As "yyyyyyyy" wont work)
- Compile error argument not optional
- Macro listing files in folder, used to list all now only first
- Run-time error; Invalid procedure or arguement
- Help Looping through array
- VBA Newbie question
- Two dropdown lists
- Function to list file names in a folder
- Help removing encryption from an excel template using VBA
- [SOLVED:] Deciphering VBA Code
- Extract value from HTM file
- [SOLVED:] Hide and Unhide Columns based on Cell Value
- Compare list of values to rows in another sheet, copy row on first match
- Copy Paste VBA code Required with some additional requirements Button
- Sum adjacent columns based on criteria
- Salary Structure Calculations
- How to run macro only selected rows
- VBA to read text file and import specific data from it to excel columns
- X-Y Scatter plot using VBA
- Yes/No Optionbuttons
- Excel VBA: resizing a pasted image in word using excel VBA
- VBA format Word
- [SOLVED:] Microsoft Object Library Reference Missing - Outlook to Excel
- Mirroring of sheets to a single summary sheet
- 2 selection critria in a WorkSheet form
- [SOLVED:] How to keep Inserting Rows Command from moving other cells in a sheet
- Select data through 2 slider bars
- urldownloadtofile-is-downloading-files-to-inetcache
- Senders Email Address: Outlook 2013 to Excel 2013 Not Working
- Download and open Excel file
- VBA: website scraping in general and specific problem
- [SOLVED:] Changing Multiple ranges to Dynamic ones
- [SOLVED:] Can you Format as fraction in VBA -- Format(123.456, "# ??/16")
- Message when you try to open the file
- [SOLVED:] VBA Coding Help
- [SOLVED:] Value & Formula - Export Sheet from xlsx to CSV
- [SOLVED:] Select range till last empty row
- Add double quotes to cells that contain spaces
- VBA Table of Contents
- [SOLVED:] Select data down to next empty cell in column
- [SOLVED:] Need help w/formula to show just some amounts
- Copy from RDP (remote desktop) to local desktop
- [SOLVED:] VBA- how can i have a userform behaviours just like controltiptext?
- VBA help solving assignment
- Compare cells
- Split to Files - adjustment
- Upon exit excel woorkbook save charts as picture
- [SOLVED:] Arrays using MMULT Function
- Vba view active ie window and mouse over text and pull to text box
- VBA for Setting Min and Max Axis for Scatter Plot Graph
- [SOLVED:] ForEach Loop Trouble
- Import Multiple txt files
- [SOLVED:] Dashboard prepration
- Slicer vba code
- compare dynamic arrays and copy data from another array into a cell in WS
- Splitting data into other worksheets based on data in ROW
- Macro - Mail every worksheet using A1 as address
- [SOLVED:] Limiting Window Size to the used Column range
- Excel Macro pulling data from Word 2013 form - formatting question
- [SOLVED:] Retain excel cell format when copying to word bookmark
- Catching fatal VBA errors
- Copy partial rows with criteria to new workbook identified sheet
- [SOLVED:] UDF to count colored cell pairs fails with #VALUE!
- VBA - inserting picture on from clipboard to userform image
- Transferring Excel data into Word
- macro save as
- VBA Code->copying sheet from mutiple sheets excel into single excel with diff sheets
- How can I find next small value(look up value) in a range?
- VBA Cells update vica-versa using VBA code - Level 100 Can somebody solve this?
- [SOLVED:] VBA - uppercase of the first letter in each word, while the rest remains intact
- TextToColumns FieldInfo ignored
- [SOLVED:] Adding batches of serial numbers
- Ribbon Control not displayed at file open
- [SLEEPER:] I like to find next small value..
- [SOLVED:] Vba Code for sorting date
- Parsen/Scripting web-pages with Excel-VBA - no refresh data
- Every possible combination
- Print Charts to pdf
- [SOLVED:] Ribbon customization issures
- Smart View - Connect to a Shared Database
- [SOLVED:] Match Overlap Date Range and multiple criterias
- [SOLVED:] Take absolute value of all array elements - Please Help!
- [SOLVED:] Set value to variable in vba to use different sub
- comparing elements of 2 arrays
- CommandButton button in Excel 2016 does not work
- [SOLVED:] Removing end elements of an array (they are all 0)
- [SOLVED:] Find row index where max value is located
- Huge working excel document
- [SOLVED:] Help with vlookup in VBA
- [SOLVED:] Auto copy range data and paste on last empty row
- [SOLVED:] Force opening a file as a .XML
- Automatic Hyperlink documents in excel workbook using a command button
- [SOLVED:] Code that opens a file and uses data from that file to replace data in another
- function with paramarray help
- Deleting rows which consists cell value PM and CM and remain cell value intact.
- Results changing from a drop down selection - understanding VBA code
- VBA in Excel to search for PDF's and report if exist yes/No
- Hiding Quick Access Toolbar (QAT)
- Userform on Mac
- [SOLVED:] Setting the width of an inserted word document
- [SOLVED:] Excel MACRO that make variable sheets with conditional information
- Finding out leaves and exits
- I want to make change in data model in manage data model of powerpivot by vba code
- Run-time error 438: Object doesn't support this property or method
- SSL connection to external source
- [SOLVED:] HTML href cutting off URL at first space
- How to avoid hardcoding a filepath
- Attemping to loop data/extract/compare
- [SOLVED:] Array Indexing - Please help, at a loss for words...
- [SOLVED:] Generate Text Files
- Looping Macro
- [SOLVED:] Range(Cells()) and the 1004 Error
- Text stretched in inserted word object
- Addins and CustomUI, OnAction to only run Subs in book?
- Storing Previous Cell Value in Historic List
- [SOLVED:] Chart Title and Axis Title positioning
- [SOLVED:] CDO Email, specific cells in the body
- [SOLVED:] Overflow Error in Array Assignment
- code for the filerting and copy n pasting in another sheet
- Copy paste with VBA
- Change Direction
- [SOLVED:] Random Select Rows and Copy to Next Sheet based on user input value
- Add a row below an activebutton, keeping the format without resizing the button
- Merge two pdf files with partly same name in 2 different flders
- [SOLVED:] Delete Rows in Table
- [SOLVED:] Open Window in 64 Bit Excel VBA 7 using Windows API
- [SOLVED:] Code is dropped when sheet is copied and emailed
- Code for Vlook up
- Sum for a certain criteria
- [SOLVED:] Forms, Formulas and Dropdowns. Difficult
- cant figure out compile error: do without loop
- Connect via ODBC to Access FE on remote server from Excel
- Copy from worksheet to worksheet in different workbooks with IF condition
- Custome Date Picker! Duplicate value
- [SOLVED:] VBA - Moving files
- errore
- [SOLVED:] Hiding Rows
- [SOLVED:] How to disable "traditional" Save and Save As functionality
- Save file to folder with variable
- [SOLVED:] Error 1004 with method "Columns" - only when opening the file
- Ways to optimize VBA loop
- [SLEEPER:] DTPicker - select date, then continue automatically
- [SOLVED:] Compare and replace- Long Sentences
- Import CSV files in a Loop
- Run-time Error 438
- [SOLVED:] Creating consistent charts and layouts
- [SOLVED:] have cell take value of another cell when a thir cell's value is changed
- Consolidate datas from workbooks to masterfile
- [SOLVED:] VBA Copy Clear Paste
- return only values from one column which have different values in another column
- [SOLVED:] Set Focus To A Particular Cells with OptionButton
- VBA - How to select range of cells based on value of 2 cells in each row
- Delete columns based on current month
- [SOLVED:] How to turn off "activate when cell changed" while other macros change cells?
- [SLEEPER:] Switching from one tab to another VBA
- [SOLVED:] Multicolum list box displays incorrect format
- [SOLVED:] problems with copying the values of one cell to another
- Removing Conditional Formatting When Printing to PDF
- Help needed to edit CSV files
- [SOLVED:] UDF returning multiple values
- Copy range in worksheet into new workbook - input box
- [SOLVED:] Transpose multiple rows, varied length, to a single column?
- Removing all non-numbers from the last portion of string
- "You've entered too many arguments for this function"
- VBA Transpose Paste Loop (looping recorded Macro)
- Excel Crashes
- Struggling wth VBA, trying to specify paste destination
- macros to search for string in cell from text files under folder & return no of count
- [SOLVED:] Error 438
- Sleeper: Macro to stack lists until empty
- [SOLVED:] Excel VLOOKUP to Google Sheets
- [SOLVED:] Transpose Column - But Exclude Rows - Found in Array List
- Adjusting my working Excel -> Outlook Calendar Code to work with an exchange calendar
- [SOLVED:] Weird forloop behavior with worksheets
- Trying to create an interactive UserForm
- [SOLVED:] Trying to Shorten/Simplify some Code to Make it Easier to Apply To Other Workbooks
- [SOLVED:] VBA - Help Needed - Macro SpeedUp
- VBA to Download documents using URLs, create a folder and save it in
- [SOLVED:] Getting The Cells to focus!!! Using FOR LOOP to find and select only the last row)
- [SOLVED:] multiple columns in a list box
- Month report in excel doc
- Code that will compare two files and merge the data
- [SOLVED:] RibbonX customization issues (XML)
- [SOLVED:] Looping trough varibales names - is that possible
- Programmatically Add Procedure to Sheet Module
- Index/Match over multiple tabs
- Populate and Sort a ComboBox with visible unique values from an Excel table
- PowerQuery refresh / Pivot Table refresh
- MkDir Runtime Error 76
- Control Box Data Validation won't change font size
- Control Box Data Validation won't change font size
- [SOLVED:] Need help with eisting event code to in regards to recording row of active color cell
- Automatic calculation problem
- Randomly selecting 50 cells from a range & filling with color
- scheduled macros execute a few times VBA?
- how to click href using vba
- VBA syntax question for Dynamic Web Query
- Copying Excel Tracker into Access - Endless Issues with INSERT INTO statement
- Merge data from multiple spreadsheets into one master sheet.
- Merge data from multiple spreadsheets into one master sheet.
- [SOLVED:] Different results when execute code by "F5" or "F8" (step by step).
- cannot get Listbox column count property
- [SOLVED:] FillDown VBA Excel doesn't work on second Worksheet
- Updating AutoCAD Attributes with Excel
- Run macro if cell has a specific value
- [SOLVED:] Goalseek last cell in column, changing last cell in adjacent column
- How to set Range based off Target Range?
- [SOLVED:] Add Dynamic Named Ranges to Each Sheet (Excel 2013)
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.