View Full Version : Excel Help
- [SOLVED:] Excel macro, combine cells based on same merged row i different column
- [SOLVED:] Run-Time error '91' Object variable or With variable not set
- Charts and forms freeze after VBA macro execution
- [SOLVED:] Macro For Re-Coding Variables after a Specified Cut-off
- [SOLVED:] i want VBA to display values greater than or equal to the given number
- [SOLVED:] Improving Cell Change Macro
- Delete columns in spreadsheet based on list of column names specified in listed range
- Sleeper: Create table array for Vlookup with match and count to next blank row
- Need Help to modify this Macro
- Sleeper: Can anyone help me with this code ?
- Combining three different tables in a chart
- [SOLVED:] Calling a function
- vba import data from another workbook with auto filtered of specified name
- Move to right column after return when I press enter
- List (Sort by) Birthday Anniversaries in .txt file
- Filter and sum the column values
- [SOLVED:] RUNTIME 13: TYPE MISMATCH ERROR
- Based on Cell value, from next cell has to move to 2nd row
- [SOLVED:] TABLE OF CONTENTS NOT USING TABS
- [SOLVED:] URGENT! GETTING DATA FROM ONE WORKBOOK TO ANOTHER USING VARIANT
- run time error '9' subscript out of range
- Map cells based on text
- VB Code Help " Error Variable not Defined " and Run time Error "438""
- Extract data from string to new sheet
- How do I check values on 4 columns simultaneously on two different workbook?
- [SOLVED:] Match code is not returning the desired field
- [SOLVED:] automating calculations and adding to existing table
- Find specific cell and insert page break - repeat till end of sheet
- [SOLVED:] DATE VALIDATION IN TEXTBOX
- [SOLVED:] Extract Matching Cell Values in Two Columns and Paste in New Columns
- insert sum formulas based on worksheet data
- [SOLVED:] VBA to provide search data from text box value
- Listbox.Column
- [SOLVED:] loop thru every sheet and filter out a specific name and create a new sheet
- insert sum or =+ formula based on value in another column for variable rows
- Heading Row Returns NULL
- Need to delete a workbook
- MULTIPLE FIND AND REPLACE FROM USERFORM INPUT
- [SOLVED:] Log to generate tracking numbers
- Need help writng macro to insert Spanish accented characters into a line of text
- [SOLVED:] Event Handler for external DLL events not triggering
- Macros to highlight three or more consecutive numbers entered in a set row
- match cells based on a string provided
- [SOLVED:] Source and target cells specification in a macro
- Search for Numbers
- [SOLVED:] Find string in multiple rows
- VBA to copy paste data in Master File........and adjust row as per data size..
- Excel VBA UserForm not working. Need help pls!
- [SOLVED:] HELP GETTING DIMENSIONS OF A VARIANT ARRAY
- Update data from one sheet to another sheet with header mapping
- [SOLVED:] ADDING A SHEET USING VBA BUT GETTING ERROR
- Hide / Unhide Rows and Columns based on selected cell value (drop-down)
- Number of days inventory held
- [SOLVED:] RUN TIME ERROR FOR A VARIANT! DONT KNOW MY MISTAKE HELP
- Restructuring of data without a standardized format
- Converting countif to frequency
- Help Creating Macro for Selection, copying ranges
- Listing Conditional Formatting on Separate Sheet or Workbook
- [SOLVED:] Saving Current Worksheet as Text in Current Directory
- Excel Macro Copying Information From Many Folders
- Force Excel Macro With Some Sheets Remain Hidden
- XLSX to XML Macro
- Show Sheets which have links to other sheets
- Add rows to existing table
- XLSX-XML Conversion through Macro
- VBA from access to excel
- [SOLVED:] Sending Email Drafts from secondary outlook email account
- Copying an active range
- [SOLVED:] Protected cells - want to enable comments
- VBA - Merging and Bordering of cells if condition met....
- Transferring Data from Multipage Userform to Separate, Subsequent Rows in Excel
- VBA - Unhiding a Worksheet and setting Sheet1 as current view
- Modifying COMport Code
- Run-Time Error 13
- Pull data from overall sheet to new sheet based on criteria
- Replace multiple repeated texts in multiple word documents from excel with excel vba
- [SOLVED:] FINDING LAST ROW IN COLUMN NOT WORKING
- Insert Two Blank Row if Condition Met
- VBA - Seperating Column data based on Criteria.....
- Select case using a collection of values
- [SOLVED:] Using an array to transfer file names into workbook with multiple sheets
- VBA Help - Run-time error '-2147417848 (80010108)': Method 'Value' of object 'Range'
- How to Merge Two Worksheet_Change Codes
- Copying spreadsheet into 120 sub-folders
- [SOLVED:] Copy/Paste Loop is only transferring rows 1,2, and 4, but not row 3?
- Ranking with conditions
- VLookup VBA Code & Elseif troubles
- VBA loop copy & paste range to same worksheet name of another workbook
- [SOLVED:] HARD:MADE A FUNCTION - HOW DO I LOOP THAT FUNCTION IN MY SUBROUTINE????
- Inset formula into last cell of table column
- RUNTIME 13: TYPE MISMATCH ERROR
- [SOLVED:] HELP!! GETTING MULTIPLE VARIANTS INTO ONE RANGE!!!!
- [SOLVED:] Pass the range from userform to sub of module
- [SOLVED:] HOW TO ADD 2D NAMED RANGES WITH SAME DIMENSIONS?
- Can't start edit or remove macros
- VBA code (macros) understanding
- [SOLVED:] Help With VBA Document Counter
- [SOLVED:] Automated Login Results in URL Change After More Than One Use
- trying to count total rows based on group of values in another column
- Object required on .Find
- [SOLVED:] Event Before refresh pivot cache
- Multi Find and Replace VBA Script Macro Not Working
- VBA - Select Case Error
- VBA - loop help in Seperating the data......
- [SOLVED:] need help with filtered table
- Get COM Addin list of functions
- [SOLVED:] conditional month()
- Pass variable from module to the userform.
- VBA sorting error
- Bug? with activeX combobox
- [SOLVED:] Trying to code this VBA macro but it's beyond my knowledge
- [SOLVED:] Adding links of files, seperating filenames with Split() - Error: Object variable or
- [SOLVED:] Merge specific word files from excel VBA
- VBA - Textfile Skip line Help in Looping
- '1004': Application-defined or object defined error (VBA)
- VBA Help: Email attachment via folder or direct-link
- Dynamically adding and positioning check boxes to wrap inside frame
- RUNTIME 438 ERROR WHEN CLICKING IMAGE
- How to hide textbox in userform by option button?
- INSERTING MULTIPLE PICTURES THAT MEET CRITERIA
- [SOLVED:] Copy value of active cell to another worksheet
- Searchable dropdown list (data from two columns)
- VBA Code Required to autosize image - I can pay via. Paypal or other method...
- [SOLVED:] Cross Referencing Filenames Using an ID and "Charting" Results Across Columns
- Search, find, hide columns - VBA
- Need to select a workbook which changes names everyday
- Excel Data Files
- Arrange Data Properly
- VBA to copy specific columns from word table to Excel
- VBA vlookup in file a with data from file b
- [SOLVED:] Trying to set color to a range
- Transfer of data between two workbooks using name of worksheet?
- [SOLVED:] Comparison isn't finding as true; but values sent to MsgBox show it should be....
- Cant count integer partitions by recursive function.
- [SOLVED:] Working with Dates in VBA
- [SOLVED:] Attach event to multiple ComboBoxes
- [SOLVED:] Filter and Sort with Multiple Headers
- Run-time error code "438"
- [SOLVED:] Suggestions regarding speed and efficiency
- Lock Cell/Cell Range based on Cell value
- [SOLVED:] Progress bar...%
- Send reminder emails based on date in column, after finding last email correspondance
- [SOLVED:] Is there code similar to "If Not Application.Intersect" & "If Not Intersect(Target..
- [SOLVED:] How to create a public array in class module?
- Copy and paste if cell contains specific text
- [SOLVED:] Perform calculations on a field that has already been added to pivot table
- Select and Edit certain type of ChartObject in VBA
- [SOLVED:] Need advice on VBA Conditional formatting Formula : Run-time error '5'
- Copy paste the data by vba
- extract data from a row with a lot of data
- [SOLVED:] “Application.Speech.Speak”, to announce the greetings.
- Add current selection to filter in VBA
- [SOLVED:] Turning 100 Data points into 6000 using VBA HELP!
- [SOLVED:] Multiple drop down selections in the same cell
- Run time 424 object required
- Possible to clean up my formula
- Double data and runtime error when running macro
- [SOLVED:] Excel Freezing Up When I Run Sub
- How to get msgbox output with spaces between every three numbers?
- Extra Screen for Laptop usinig Android Phone
- [SOLVED:] Loop sheets that begin with given chars
- [SOLVED:] Vba to calculate the number of days from today to the 1st of the month.
- VBA: Copy and Paste if criteria met
- I am having an issue with macro assigned shapes
- Employee number according to timetable sequence
- Several questions about the collection.
- [SOLVED:] Edit Excel Links in PPT Using VBA and Early Binding
- Summarized data based on timetable sequence
- VBA Merging duplicate -cells issue
- Conditionally put - sign
- [SOLVED:] Data Comparison
- [SOLVED:] Using a string in names of dublicates
- extract data from Excel Columns to an Output sheet
- Scanning Input not considered a Change
- [SOLVED:] Modify a macro to remove blanks from a worksheet
- [SOLVED:] Userform TextBox Loop Syntax
- [SOLVED:] Dynamically passing value to Sub using buttons
- Bold and color numbers in specific format with special character
- Is there a way to write this "for" loop?
- [SOLVED:] Overflow Error when using Format()
- [SOLVED:] All VBA Worksheet_Change Events Not Working
- VBA to check for PR SAP attachment
- Can't calculate long recursion
- VBA help in creating a dependent and source views
- [SOLVED:] HELP NEED TO MAKE CODE GENERIC LOOPING THROUGH CELLS TO IMPORT DATA
- [SOLVED:] Formula to return two multiple lookups in one cell ?
- [SOLVED:] If/Then/Else, Search & Set Active Cell VBA Help
- Excel Hyperlink when click ,automatically compose a message in outlook
- [SOLVED:] Loop through all open Workbooks in all Instances
- [SOLVED:] HELP GETTING SUM OF COLUMNS IN A RANGE
- check macro execution / speen
- User form in PowerPoint to feed Excel database
- [SOLVED:] Increment number based on two criteria
- [SOLVED:] Help speeding up macro
- [SOLVED:] Find word and delete else exit Sub
- Removing Rows Based On One or More Cell Values
- [SOLVED:] Extract amounts from text strings using VBA
- [SOLVED:] Compare and copy
- Pivot Table Creation Error
- IF LOOP FOR LOOP AND IMPORTING FROM ANOTHER WORKBOOK
- Coding Excel User Form
- Search whole row for
- Copy and Paste loop
- Suggestion for Best Practice
- VBA - Copy Multiple Columns as per mapping sheet union help
- How to put a named range in one workbook to another and call a button VBA
- [SOLVED:] Deleting Queries and Connections not working in O365 version
- VBA script/code to email range of data from an excel spreadsheet
- Get Unique list of cells in a Column for loading a Combobox
- Trouble Changing Active Cell After Pasting To 2nd Workbook
- Can I use vba to add hyperlink shortcuts to folders
- [SOLVED:] Extracting 8 digit PO from Field
- Excel file needs help
- [SOLVED:] Find Function
- [SOLVED:] how to make filter from data base and show count in VBA tool
- [SOLVED:] how to marge multiple sheet into one sheet
- [SOLVED:] how to use both userform and other excel
- How to pull data from a Sheet to create a Context Menu? How to combine two VBA codes?
- problems with printing
- [SOLVED:] vba tool for admin database maintain & analysis
- Filter Data Based on Dates + other criteria & copy to another sheet
- Defining range from First Cell to Last Used Cell
- [SOLVED:] i need Vba code that creates an input mask for a password ***** in an input box
- Retrieving all files in folder or subfolder containing specific text
- [SOLVED:] Trouble Assigning Error Bars with Array
- How to adjust the size of the `Note` after opening it?
- [SOLVED:] Find All, Copy & Paste to Next Blank in Sheet
- How to backup settings of Microsoft Office which are in registry branches?
- VBA - Open each file from directory in ascending Order
- Copy last 20 rows (or all if less than 20)
- Checking the values in Sheet1 with multiple entries in Sheet2, Write the output
- Using an addin to package all my source code
- [SOLVED:] VBA To Re-lock a specific cell after 30 seconds
- Find currency and add/debit according to amount
- Undo/Redo or CTRL+Z – CTRL+Y »» does not work for my own macros
- [SOLVED:] how to use userform to operate pivot table
- [SOLVED:] Countif and Count on visible rows
- [SOLVED:] Edit textfile vba
- HELP! VBA Problems
- [SOLVED:] .TextToColumns doesn't seem to work reliably.
- [SOLVED:] Need help getting results of macro displayed, starting at row 5 column B thru F
- Starting from specific place in a row
- [SOLVED:] Sumif multiple criteria
- [SOLVED:] Prompt user for date and user to Open file
- [SOLVED:] Copy and Paste
- Help to make VBA Model in Excel run quicker
- Very Very Very Very Complex excel formula required...
- split text in different cells after each underscote "_"
- Find previous day balance.
- Moving Sent Items To Another ARCHIVE Sent Folder.
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.