View Full Version : Excel Help
- Complex Macros needed to Make and Save Workbooks
- [SOLVED:] Deleting empty rows
- Custom Option Buttons VBA
- Custom XLAM ribbon question
- Accessing Hidden Sheets Via Hyperlink
- Every time i run the macro it has different values, need help please
- Last saved issue
- [SOLVED:] How to write VBA code to auto insert the last row occupied into Master Sheet
- [SOLVED:] Write an IF statement relating to 2 different worksheets
- Copy function from workbook to another in VBA
- [SOLVED:] Ctrl-C selection in memory - how work with it by VBA Excel code?
- Date Variable Showing 12:00:00 AM, Why?
- [SOLVED:] Combining Static Series and Dynamic Series in a Dynamic Chart Issues
- [SOLVED:] Unwanted selection change
- Can you customise the results from comparing two worksheets?
- If-statement with relative values
- Sleeper: Adding a certain number of cells between sets of data based on a comparison
- Help with copy paste code
- Convert from Text to Columns Doesn't Work if Source is Modified
- Values are not copying over as entered on one sheet to another.
- Identifying file type in excel
- [SOLVED:] Excel coordinate projection - distance and bearing
- VBA to copy url from excel sheet and open in webpage and copy source to notepad
- [SOLVED:] Search for data highlighted in red return it and return the data in next two columns
- [SOLVED:] PivotTable.DrillDown and filtering the output
- insert six rows at specific points
- [SOLVED:] Autofilter latest event date
- [SOLVED:] Store special cells in one range
- [SOLVED:] code for copy and paste
- [SOLVED:] Re allocate Named Range addresses
- New to Macros - file naming issue
- Save active sheet only as pdf + Increment the invoice number + print active sheet
- Creating an xml file from each row in excel
- VBA Error - Missing 4 columns Data after copying
- [SOLVED:] When using open text file how to tell if the file existed, or a file was created?
- Adding comboboxes in a loop
- File folder to single spreadsheet
- Get the heights related data in row D
- [SOLVED:] Extract the formulas of each cell in range - VBA
- Populating PDF document with Excel vba
- Excel Function -Address
- [SOLVED:] Select from Cube Through VBA
- Customised spell check in VBA
- [SOLVED:] ActiveSheet.Previous.Select
- [SOLVED:] need help gettng macro to run faster! please!!!
- Combine Multiple Worksheets w/ Different Headers Into One Worksheet
- VBA: Match string and color substring
- [SOLVED:] VBA: Chart with Combobox
- Copy and combine files using VBA
- [SOLVED:] Unmerge cells across rows only not across columns
- [SOLVED:] Message in Every Cell
- VBA code for extracting report from Outlook Mails
- Adding functionality to an existing Excel Workbook (example pictures included)
- How Do I Filter In Excel Using TextBox?
- Compare values inside the range (sheet1) and copy the row to new sheet (sheet2)
- [SOLVED:] Summing of columns into specified cell loop
- Help in Pivot
- [SOLVED:] UserForm VLOOKUP to get Data and Change one Column
- pivot table - sort items with different order for each parent item
- Auto Save excel file to another Computer on the network
- [SOLVED:] Help with updating formula's with VBA
- [SOLVED:] loading a variant array
- [SOLVED:] Help with code on language translation file
- [SOLVED:] Adding a Scroll Option to The Text Boc Functionality
- [SOLVED:] Need VBA to arrange data Cell adress data please!!
- [SOLVED:] Macro to Set Page to Print in Particular Range & Adding a Company Logo
- data transfer
- Formatting, Highlighting Travel Times Conflicts
- Need VBA to create inputbox for multiple values & filter multiple columns
- [SOLVED:] Text Size Issues in Text Box
- Macro to copy excel recordset and insert in to Database based on a condition
- [SOLVED:] Rename text file with new name
- Userform- Populating Dependent List Help
- [SOLVED:] Progress Bar for macro
- VBA - SAP 'Save As' dialogue box
- [SOLVED:] VBA to fill up website form and upload file path via “Browse” buttton
- Macro to Copy certain WS's based on Key to a New WB and email
- Code suggestions required.
- Significance Testing Macro
- [SOLVED:] Loop through column data and delete or copy based on value given
- Labor Tracking / Time Tracking
- [SOLVED:] Project Planner Not Working
- [SOLVED:] How to export and save each worksheet as new workbook in Excel?
- Help with pulling names from online database
- [SOLVED:] IF, AND, OR Nesting - Part of it not working
- [SOLVED:] MACRO: SaveAs Cell Value File Name (Pull Two Cells within Worksheet as File Name)
- [SOLVED:] Module Level Variable Loses Value
- [SOLVED:] Sort by row based on column value
- [SOLVED:] How do I set passwords and how to save as a certain name for a file
- File size reduction
- [SOLVED:] Alternatives to MINIFS (Minimum IF's)
- Required Email generated with signature and attachments
- VBA Macro to copy multiple charts from one excel file to a word bookmark locations
- Import data from different files and sheets into file with corresponding data cells
- [SOLVED:] Array limits?
- Open all CSV files in folder, and merge to one master file.
- [SOLVED:] Copy range to blank cell
- [SOLVED:] Remove symbol
- [SOLVED:] Extract part of a line and paste in another cell
- [SOLVED:] Create 2 Dimensional Array from "For" Loop
- Find out row and column range
- Vba Compile Error :(
- Get (some of) Excel Clipboard contents via Windows clipboard "XML Spreadsheet" format
- [SOLVED:] Angles between 2 lines
- [SOLVED:] Modified a function that is called in another function, now getting runtime error?
- [SOLVED:] Save Outlook attachment into an Excel cell, as OLEObject in VBA
- [SOLVED:] Pull specific data based on If statements
- [SOLVED:] Handling Formula Errors & Formula Length Limit
- Subscript out of range
- VBA to update a table from another table
- Run macro on all files
- [SOLVED:] Split function in vba
- excel vba macro to apply filter multiple column using header names
- userform icon in taskbar problem in win10 office 2016 bit 32
- [SOLVED:] need macro added to current to automatically move to next row for next search and
- [SOLVED:] Need help with Question, is it possible to Call modules to work or loop through?
- [SOLVED:] Select working(Active) range with mouse
- vba adding image after clicking on the textbox
- [SOLVED:] VBA function to return MySQL Data
- Help with filter by date
- [SOLVED:] Break up column A content between column A and B
- Find and Change Values
- [SOLVED:] Format Issue
- VBA code running too slow in Excel 2013
- [SOLVED:] VBA code attach an excel file to outlook with a variable file path
- Autofilter failed
- [SOLVED:] VBA Code assistance to separate a workbook into several different files.
- Function to update a cell in another worksheet giving #1004 error
- [SOLVED:] Running Macros from ComboBox with Items from a Range
- VBA: referencing cell in one worksheet and using it as range start for another sheet
- Reading and Writing to dat file via forms
- [SOLVED:] VBA code to cycle through sheets
- [SOLVED:] How to send email in excel using content in word as email body
- [SOLVED:] Take out space
- [SOLVED:] Convert to a number
- [SOLVED:] Copy and Move files to existing Sub-folders based on filename/Sub-folders's Name
- Change marker size for all series in a plot (VBA)
- VBA To Check That Value Appears In Single Cell Range Before Starting Macro
- Run-Time error "7" out of memory
- Compare two strings for similarity or highlight differences in Excel
- [SOLVED:] How to Send a HTML Email using Word Email Template using Excel Macro
- [SOLVED:] Simple for each loop problem
- Trying to copy a macro into another workbook
- Can you speed up my vba that copy and pastes the header amongst worksheets?
- [SOLVED:] Auto Save excel workbook every 5 minutes
- Subscript out of range
- [SOLVED:] Looping through ActiveX checkboxes and adding items to ActiveX List Box
- [SOLVED:] Highlighting a cell if there is a match with another cell
- [SOLVED:] Pivot Table Error with VBA Code
- VBA Use hidden cell to run IF Statement
- [SOLVED:] Populating colums based on cell value and conditions
- [SOLVED:] Two rankings
- Empty a Module within Excel 2016 …
- Disable Overtype / Insert Ability in VB Editor for Excel 2016 …
- Add Data Field in Pivot Table
- Export all the sheets in excel to images individually files
- [SOLVED:] vba help on vlookup
- [SOLVED:] Need help duplicating a row (if not already duplicated)
- [SOLVED:] VBA FILTER
- [SOLVED:] VBA VLOOKUP ON Historic trades
- Search string in two columns in different excel sheets and copy the matching data
- [SOLVED:] Procedure Too Large - Compile Error
- [SOLVED:] Sort/ transfer data
- USER-FORM FILTER DATA EDIT
- VBA Conditional Formating
- modifying function cohort/matrix of ratings migration
- Vertical Column with possibility to filter
- [SOLVED:] vba Double for each Loop combining task
- VBA code for lookup table
- MSO File Picker Help
- [SOLVED:] #Name? error for TextJoin UDF
- VBA Macro - Use relative ranges to graph
- [SOLVED:] VBA code mysteriously timing out
- [SOLVED:] Searching with recursion
- [SOLVED:] Unzip files to a folder udf
- Move cells to another worksheet
- Macro to convert from Paste Bottom-Up to Top-Down?
- [SLEEPER:] VBA code in Cash Flow forecast
- [SOLVED:] Need help with Do While Loop or If this AND that then....
- [SOLVED:] Move File to Folder if filename matches foldername
- how to make CommandButton1.Rotation = 90 in office 2016
- Advance Filter using VBA
- Control strings
- adding selected rows into a sheet with a specific selection
- vba help to copy specific colulmn.. from a sheet
- If Formula not working as expected
- VBA getElementById doesn't work correctly
- Macro is not recording sheet protection password
- Change Sheet name
- [SOLVED:] Copy and Paste Macro help please
- [SOLVED:] Loop thru all sheets and copy a value
- Timer + Stop Watch
- RTF field in Excel by keeping formatting
- [SOLVED:] Can't call several subs in a macro
- Identify employees late login
- Sleeper: VBA If formula help
- [SOLVED:] Delete zeros
- Cell Value Confusion.
- [SOLVED:] Macro To copy and paste data from a list to corresponding worksheet and cells
- create and store pdf, attach to email and send, with loop
- Subscript out of range and SaveAs Method error
- Quote Generator - Advice
- [SOLVED:] sum of variable range stop working
- Trying to copy all sheets into one combined sheet
- VBA Help, to Pick first Column Data and its file name
- [SOLVED:] is it possible: If Me.Controls("CommandButton" & i).clicked
- [SOLVED:] Shorten loop using boolean
- Getting Problems in Making a Query from SharePoint
- VBA code to delete rows based on value
- [SOLVED:] FileSystem Object, Folder.Files.Count Does Not Match Files.Item Count
- [SOLVED:] For Loop does not seem to be working
- VBA Code to Run Other VBA Codes in Multiple Workbooks
- Dividing data records fairly into clients based on categories and amounts
- [SOLVED:] Monitoring Remote Workbook for Changes
- [SOLVED:] How to display a chart on a certain position (e.g. centre of screen).
- What are your favorite Excel VBA automation success stories?
- Vba code for partial transpose
- [SOLVED:] Help with formula please
- [SOLVED:] how can i save userform settings
- Parsing data to several sheets
- [SOLVED:] Countif using arrays
- [SOLVED:] IF then
- [SOLVED:] Blank cell
- [SOLVED:] VBA code to paste data to a row with today's date in column A in another sheet
- [SOLVED:] Insert Pics Macro Not Working on All Cells unless name manually typed in
- [SOLVED:] Selection not displayed when combobox item is selected
- [SOLVED:] VBA check if a specific value has been entered into range
- Subscript out of range and SaveAs Method error (Revised)
- Encrypt password for database access
- select radio buttons in IE
- Using RANK on a range of data - need an exception
- [SOLVED:] combine selected worksheet into one worksheet
- Cell locking macro not working
- Need code to merge PDF files in a folder using adobe acrobat
- A neat timesaver for Immediate ("debug") Window - abbreviations
- Rewriting Referenced Data for VBA Pivot Table
- [SOLVED:] VBA to operate on an external drive + files dispatching in folders
- Hide Worksheets dependant on domain name
- [SOLVED:] Coloring rows through value in column
- VBA Function - Last Row
- [SOLVED:] Excel VBA to Transpose lists
- VBa code to transfer rows base on a sequential number
- Writing a macro to capture values on a spreadsheet and add them to totals on another
- Using checkboxes to copy rows from one sheet to another in the same relative order
- index match between 2 workbooks
- Macro to Convert Flat Data to Database - Amendment to existing code required
- [SOLVED:] One Row.Delete works, another doesn't
- [SOLVED:] Format data in Excel with subtotal
- Web scraping with complex chronological events
- [SOLVED:] Table transpose
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.