View Full Version : Excel Help
- Return cell values as date
- QR Code system for Excel for estate inventory and sales
- [SOLVED:] Problem inserting formula with VBA
- [SOLVED:] Adding continuous Series Collections with loop
- [SOLVED:] How to Disabled a Command AFTER the last row is inserted.
- Delete entire column with duplicates in row 2
- vba autofilter with several search cells as a filter
- Importing CSV through PowerQuery to Excel
- Help with VBA
- perfomance VBA with loop
- [SOLVED:] Code for Hiding Slicers on Pivot Table: Getting Error Message
- Compile Error with ComboBox
- Multi Condition Average
- Getting runtime error from Range object that VBA Debugger shows as "String * -1" Type
- Hiding rows based on cell value - VBA
- Substitute a value from a Choice of multiple words in a offset cell - Randomly
- Can't find DLL entry point
- [SOLVED:] Can't copy data from new created workbook
- [SOLVED:] Countif function on varying ranges
- [SOLVED:] Bold while adding text to excel in vba
- when drop down value is month or weeks or days, force user to enter required rows
- Excel Online - Sharing workbook between two companies - Editing Permissions
- File extension issues
- Can't find "div class" element
- Get Range according multiple Listbox values
- Double Do...Loop does not work
- Extract a word from a text in a tab
- Setup a formula to be completed later
- Insert The Created Time And Last Modified Time In Cells In Excel With VBA Code
- VBA VLOOKUP always returning zero.
- Refer to Grouped Charts (or anything that's grouped) in VBA
- VBA Pivot Table Creation Doesn't Sum all Rows
- Shift clicking files storing filenames in an array
- Web scraping
- Transposing Excel table using VBA
- Automatic Sorting while typing
- VBA copy cell data based on value in columns
- Help !!! struggling with run-time error '-2147352571 (80020005)': Type Mismatch
- Dynamically referencing multiple named ranges
- Clean trim code explanation
- Foreign Language Characters
- Monthly Payments With a Final Payment
- reduce all pdf file size which kept in folder below 100 kb excel vba code
- Help needed: looping within loops
- [SOLVED:] Else problem with clicking on a row to run macro
- [SOLVED:] Indirect Cell references from VBA gives error
- Display Columns in Listbox only if cells are not empty in a selected Range
- Not specified issue
- Code to transfer data from one workbook to another
- [SOLVED:] Modules not accessing userform objects
- [SOLVED:] Copy data from multiple files in a folder to master sheet
- Date entered to next column of pivot table, reflected on master sheet
- [SOLVED:] Maximum workbook and set to page layout view
- Request for tips and notes for code structure and style
- On Call Rotation Schedule with no VBA (Defined Rules)
- [SOLVED:] Create timeline in Excel with several phases on single row and only 2 input dates
- copy row, based on columns header and row color
- [SOLVED:] creating a access db with autonumber primary Key
- Efficient method of creating dashboard in Excel 2016
- Sleeper: VBA Macro help needed to compare to column different sheet
- [SOLVED:] Excel Formula full update?
- Run-time error '91' Click html button
- Excel Formula full update?
- For each loop with data validation lists
- [SOLVED:] VBA Code to create a folder based on cell date
- Calling Subroutines in VB
- Word to Excel Copy and Paste
- need help in writting VBA Code to save file sequentially after each loop
- [SOLVED:] List Data Between Two Dates
- **Macro is waiting to close the form**
- [SOLVED:] Array resizing help
- CONSOLIDATE 2 WORKBOOK INTO 1 MASTERSHEET
- [SOLVED:] Context menu on UserForm "reluctant" to show first time
- [SOLVED:] maximum Value from other column
- Automaticall change dpi settings of windows to 125% for all devices that use the file
- add formula to first available cell column B
- creat multicharts
- Dynamic drop down lists with OFFSET, LARGE, INDEX and MATCH
- Loop based on text
- Visual Basic code gets separated from workbook
- Excel VBA reuseable copy and paste below last cell
- Updating a master sheet from nightly data
- [SOLVED:] Problem writing to minimised workbook - worksheet minimised when saved
- Runtime error at #dataname = ActiveSheet.ListObject(1).Name#
- Update Links question
- Need help figuring this code out!
- [SOLVED:] ODBC connection error through VBA in excel
- write SQL table output to excel using VBA
- How to set "A1:A" & to variable and convert column number to letter
- VBA Macro help needed
- MACRO to record real time data
- VBA code for automatic open sheet & Update & send mail
- VBA Outlook single mail instead of multiple mails to recipient
- [SOLVED:] Changing tab names dynamically
- VBA code to count number of only weekdays between 2 dates
- "collect" data / string from another open window (which is not the excel)
- Modify text string all over .txt document
- VBA LOOKUP - How to Return Multiple columns of dynamic range?
- Website Auto Login - Type as Hidden - VBA
- VBA Code for highlight a row based on cell with fix column and row
- VBA to insert text in adjacent cells
- [SOLVED:] Changing the properties of many charts
- [SOLVED:] Get datetimestamp in Excel through VB
- VBA Help - on Visible cells
- Send Textbox Text to Array
- Excel VBA Delete after timer
- VBA Pivot Calcfield
- [SOLVED:] Clear contents with in a range in Excel through VB
- Have a shortcut key to command bar
- [SOLVED:] Excel VBA Email with PDF attachments
- Compare Two Sheets and Extract Differences
- [SOLVED:] VBA remove all records from master sheet while auto refreshing and auto archival
- Macro auto filter to create report pasting hidden rows. Help
- Transfer data from one workbook to another
- Using Dynamic Ranges (without range address) inside a Formula
- Using a Userform with Multilple Checkboxes to complete a Range of Cells
- Copying Sheet into Master Sheet
- [SOLVED:] Two different additions alternatively
- Reading in a Text File
- [SOLVED:] NEED HELP MODIFYING EXISTING EVENT CODE BY ADDING ANOTHER CODE RUN AS ONE CODE.
- Run Time Error 438
- Count unique values with three conditions
- Transpose an array - type mismatch error
- Sorting a multicolumn listbox
- Insert a date in a cell in one and only possible format
- [SLEEPER:] vba macro to loop through find and return search criteria
- Class module for userform command buttons
- Run-Time 1004 Array Copy Error Charts to PPT
- [SOLVED:] Date Format Help
- Help with VBA Code: cell values and matching values
- VBA website scraping - multiple link clicks to show full table
- Compare Main List and Sub List, included new items in sub list to main list
- How do I fix this VBA Code?
- run macro in workbook1 then go to workbook2 to run macro
- Filtering on checkbox text
- [SLEEPER:] Want to convert markovitz excel variance model to VBA
- Multiple similar If Statements
- VBA Script seems working at first glance, but does not..
- Unique Random Number Generation
- BEG FOR HELP-EXCEL VBA CODE/FORMULA FOR A LIST
- [SOLVED:] if and match formula
- Help: VBA Training to pull data from online database to worksheets
- [SOLVED:] Switch Values Between Sheets
- [SOLVED:] Split the excel based on headings list
- Delete multiple files, based on cell value.
- Split the excel based on headings
- If cells in a column contain a value, input text into another column.
- Help with Compile error: Else with out if
- [SOLVED:] String || How to do selection.replace with space?
- User Form to Select Pivot Table Filters
- [SOLVED:] Shell Command results in Runtime Error 5
- Want some idea on transposing function
- [SOLVED:] Finding Min and Max Times for Each Date
- Excel VBA creating emails via web browser
- VBA not running correctly in Excel 2016 (worked perfectly 2010)
- [SOLVED:] Search Replace in Text files - Loop to Next Search & Replacement
- Modify the code in the userform
- Loop Format (Not Looping)
- [SOLVED:] If cell is N/A, how to replace it with the average value of the cells above and below
- Required Conditional formatting
- [SOLVED:] Adding Email Addresses From Names Rages to Lotus Notes
- [SOLVED:] Select Folder and Rename Files according to list in excel using VBA
- [SOLVED:] Analyse a subset of numeric Array only
- Excel vba code to iterate through list and match to total
- [SOLVED:] VBA Code to open PDF file using LastModifiedDate
- Need assistance pls
- How to group Files in windows explorer with VBA / VBScrip (a .bat file)
- [SOLVED:] Copied Table Missing First Column
- Delete Rows based on Input Box Enrty
- Paste Link is greyed out during Paste Special
- find all path between any two nodes
- [SOLVED:] Date Lookup Problem
- Count values in rows based on column name
- Transpose and insert a column to a row on a different sheet
- overloaded excel workbook - ETL replacement ?
- Find copy and paste into same worksheet
- Excel VBA CDO Email
- Insert new row in excel which is protected
- [SOLVED:] Loop to Cut Down on Long Code
- Duplicate Values only on ListBox
- Search string or substring from range
- Unique Variable Name for File
- Help!
- Excel Graph Paper Not Measuring Correctly
- Not VBA - INDEX MATCH MAX DATE Question!!! :)
- Clearing a Shape from a Chart
- Copy data from Pivot table(except headings) to a new tab using VBA
- [SOLVED:] Conditional Formating Issue
- Compare and replace- English and French Translation- Optimization.
- Urgent help needed - "Runtime error 9: subscript out of range"
- [SLEEPER:] Facing Run-time error-13 "Type Mismatch" while edit and update user
- search for words or symbols in files
- Search for number in another Excel file and get adjacent cell
- modify vba code
- Modify Macro to have sheets added in particular order
- Auto filling data w/ VBA
- VBA reset all pages in multipage
- VBA: Workbook won't open until the macro is completely finished
- Creating comma separated list from multiple columns
- Expanding between two dates (start and end) along with other information
- Renaming a closed excel file by info in it, Excel VBA
- VBA with a lot of condition statement
- Format Object
- problem with api call
- Help with production counter in VBA
- Dependent Combo Box in userform
- Download and extract zip file, and open file in it
- Not able to use the find command in vba ,Please help
- [SOLVED:] Automatically enter the value of a formula in adjacent cell
- [SOLVED:] inputbox coding for invalid selection(s) - column
- Combine 2 sheets into 1 PDF file
- [SOLVED:] Excel Calculation issues with UDF
- [SOLVED:] Trying to Make Macros Run More Efficiently
- Floating point question, exactness of integers
- Cancel querytable.refresh
- Need to Match two or more rows values based on their ID in another cell
- vba help to shorten the my code...
- Inserting Multiple Rows in Excel based on cell selection
- [SOLVED:] expand and complete series excel
- [SOLVED:] vba conditional formatting - compare range of adjacent cells
- Insert and Delete rows based on value
- [SOLVED:] Conditional Data Validation issue
- Highlighting cells that contain specific characters with VBA
- [SOLVED:] I Need help to reconstruct code to add to existing code, please
- Option Enabled Search
- Copy Sheet From file to workbook, and save it as origin name in different file
- [SOLVED:] Need help with highlighting duplicates of data in 3 columns, Please
- Macros not enabled etc. Runtime Error 1004
- Automatically save on insert/modify cell data.
- [SOLVED:] Create x,y points from mouse clicks
- Creating CAD files using Excel.
- Change code to include range of cells
- Overview values pivot table
- How to store an embedded wave file into a variable
- Adding Slide in Powerpoint via Excel VBA
- Creating automatic chart using other sheet's data?
- need help leaning or restructuring macro for highlighighting duplicates on large data
- [SOLVED:] Getting last modified date shown in footer and cell
- Counting Consecutive numbers > 100 in a column by multiple criteria
- Macro does not copy to the next row on the destination sheet
- complex slicer
- Preventing closing a workbook
- Need to build a macro with the following logic. Don't know how to start!
- [SOLVED:] requesting help on restructuring code to work on extracting data w. int color red
- Need Help VBA Find Certain Value
- If statement to copy data to correct row
- Angle of a trend line
- Checking format of a selected Range
- [SOLVED:] Updating PT Slicers is Causing Macro to Fail
- [SOLVED:] VBA Makro Load Data from Website with Java Script
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.