Excel Help [Archive] - Page 111

round function in excel
Solved: replacement for Application.FileSearch
Method 'Range' of object '_Worksheet' failed
Updating from 1997 to 2007...
Renaming excel sheet in specific format
Solved: How to Hide the Sheets Bar in a excel File?
8192 areas error message
Application-defined or object-defined error
Solved: determine how long user was on a sheet
CC more than one person on email
copying text that exceeds the width of the page to the line below
Dropdown List from Table w/o Duplicates (NON VBA)
Solved: Please Help" Create auto hyperlink folders"
VBA code to copy files from one location to another based off of creation date
Solved: How to create a macro to unprotect the sheet?
Get data without opening Excel?
A Custom UI code to do ...
Code to move data forward and back, using a checkbox
Printing dates
Solved: Extra Series ("File") in Chart with VBA Code
Calculating Endtime/Duration
Color background detection in a cell
[SOLVED:] Change printer setting
Solved: List box value from an active cell.
Copying files from FromPath to ToPath VBA Code inclduing sub directories
Keeping a userform on top of another when using taskbar button.
Import text from word document into excel
Solved: Data picker and commandbuttons control
Solved: Search for Values and copy certain columns to different worksheet
How to use READYSTATE_COMPLETE
ADODB.Connection : Sourcefile + if condition = error
Solved: VLookup In VBA
Solved: Match 2 fields and paste 2 values
Solved: Range object acting up in 2007
Referencing a closed external workbook - VBA
Solved: VBA Excel Close Non Active File
Copy to another sheet with find variable range
How to solve this security alert message?
How to Disable the ...
Passing variables to a specified control
Solved: prevent errors with multiple user input simultaniously.
VBA run-time error 438
Solved: splitting a part of text into another column after last space
Solved: Update summery cells using indirect function
Pasting from Excel to word
[SOLVED:] Refresh listbox
[SLEEPER:] Call a function in another Excel 2010 AddIn (.xlam)
Solved: Merge two codes
[SOLVED:] Task scheduler to run vbs script
Compare two columns values with another two columns of same sheet
[SOLVED:] Adding a value to the first instance of duplicate values in a column
Macro help - highlight dupe cells
Retrieving Computer object information from AD
date display
A simple code to move data with a Button
VBA copy template worksheet to multiple new worksheets based on a range
Solved: Track Cell Changes
Solved: Error 1004 when copying and pasting with multiple sheets selected
Scrolling through a list box with a mouse wheel
Solved: how can i make this arry work
Create report from data
Consolidate Workbooks Into Summary Sheet
how to save a backup file
Merging Macros
Looping through dim'ed objects - can it be done?
VBA Code For Web Login Not Working
Solved: Switching between Userforms
Solved: How to read Excel or Word file (multi-word phrases) into Array
Only once error 91
Position cursor
[SOLVED:] copy and paste in certain location in word
create a permission on FIREWALL
Solved: Selecting Cells
Solved: Opening And Printing A Word Document
Passing values between userforms on different workbooks
Solved: Generalize code
[SLEEPER:] Worksheet change copy row &paste above macro
Solved: Custom Text Format
Calculations using excel vba
Helper column
Putting temporary data in a Combobox
paste cell offset to right???
CopyFromRecordset Decimal Values are copied as much longer decimals values
Solved: check duplicate data in different worksheets
Copy and Paste Values at 1 min intervals
Solved: Help with conditional formatting
un joining text in cells
Solved: Userform to Spreadsheet help
Hyperlink file based on cell text
Solved: Error on code to copy from excel and paste to word
Solved: Conditional Format help
Reference cell that has the fax number
Solved: Sumproduct and Countif error if there is a blank cell
Getting Trendline formulae - results OK when stepping thru code, missing when running
[SLEEPER:] Copying values from one column and inserting below the values of another
Automate logon to intranet sites
Deduct Partial Vacation Hours Taken from a Date or Date Range
vba code moving data of row from one sheet to another & vice versa
Solved: Looping through a two dimensional array, displaying element values, having problems
Copying results from dropdown to separate sheets
Find N, leave blank and move down
Automation Error Run-time error '-2147217871 (80040e31)'
Solved: Edit Cells finding the last row
conditional formatting help
hide/unhide textbox
[SOLVED:] Application hanging for apparently no good reason
Delete sheets with execption
Solved: Loading and unloading forms
Solved: Sorting Issues.
Incremental number for saved files
Copy rows to 2 sheets using criteria
Solved: VBA code to turn the formula into value
Unique List and tally from Rows
Sometimes Simpler is better
[SLEEPER:] Excel VBA Chart.Axes(xlValue).MajorUnit
trouble with modestly large integers
Compare Dates and Clear Cell Contents
help needed for column retrieval from various sheets.
Retrieve highest number from an array
How to average a column in vba?
Read/Export table from Outlook mail body to Excel using VBA
[SOLVED:] Get Column Letters (Excel 2010)
Solved: Resizing a range based on matching values.
Expert Needed Macro Assist
Combining Multiple Workbooks only grab 1st sheet
Solved: Move from first sheet to first sheet +1
Complicated Charting Issue
Autofill column to last row
dynamic chart in excel, size changes - desperate for help please!
Solved: AutoRefresh 5-7 Pivots within a Workbook.
open workbook - check date and percentage - send email
Adjusting MyPath Variant to point to specific folder
I need help with creating a Macro!!
accepting and storing a user/password temporarily?
[SOLVED:] Move selected columns data from UserForms listbox to different ranges in Worksheet
[SOLVED:] Searching and Copying
copy values to another worksheet in next down cell
[SOLVED:] Expand 2 Columns to Multiple Columns with unique ID Rows
[SOLVED:] Import data from closed WB to textbox in userform
More efficient code for copy/paste between workbooks
Need way to invoke macro at a different workbook the current
Solved: Using Index and Match with Dates
Sum Base %
Get data from closed workbook
Solved: VBA to convet to IF(ISERROR formula
Solved: Spinner Button
Solved: search for words in all caps in Excel
Unable to access the link for the Add-in
Solved: Text to Columns
Help with web adresses and vba
Auto deletion of worksheets based on multiple criteria, and automatically returning v
Selection Printing either Landscape or Portrait
Auto Extracting Recording From RTF to EXCEL using VBA
[SOLVED:] Check if File Is Open
Solved: Selection Caps Locks
Solved: Show top ten closest match amount
Could not change the cell color using VBA
Help Creating a Macro
Solved: Copy & Paste in same cell
Macro to group rows
Target prices
How to populate an array with results?
Email validation in vba
Solved: Create pdf attachment from Url in cell and send via Outlook
Save WordDocument as PDF using Excel 2010
Solved: Find N, Insert N and Shift down
Issue with custom Menu - how to have it only in one Excel file?
Solved: VBA indenter
VBA Shared workbook
Getting a handle on internet explorer instance
application.hide and opened file by two users
Solved: Userform Text Field Format
VBA code that sums column "C" in all active worksheets
Macro to email file location
Solved: Pivot help
Solved: Pivot table column totals
Solved: Creating an Array via a Range
Dynamically Update Defined Names Range
Solved: Code Not Cycling Workbook
Solved: Ranges are the Worst...
Defining Ranges Using VBA
MS Excel Macros to Update Spreadsheet automatically
Solved: make workbook close if in use by other user
Tool to clean up VBA code
[SOLVED:] Copy column and paste into rows
Match and copy, unique condition
Sum a range with values & blanks then paste product into a cell
Solved: VBA Sort
Regression
Lock Column Cells If Cell Equals
I Need vba code clear cells
Solved: .Application.Visible = False
SolverAdd ignores certain constraints
Solved: Incorporate VBA With Copy and Paste
Solved: subscript out of range
Need to copy part of active spreadsheet and save to desktop
VBA Autosort Exclude Text Value
Solved: Find value in column "A" on one tab to another tab and replace the value in column "B
[SOLVED:] Macro to copy cells in column G & H if cells in col K & L are blank
Solved: Icon software
Showing Sheet content in WebBrowser control
Excel Macro
Item Property of Files Collection
Run-time error '1004 Application-defined or object-defined error
Solved: Hide UserForm & Stop Closing Excel
VBA PASSING VARIABLE
UserForm Caption text with a cell ...
Repeat Rows at Bottom of Worksheet
[SOLVED:] Write-Once only rights
Shape Selection Dynamically
Solved: Sort Macro
Solved: VBA Delete Error 400
Excel Asking for DSN
Solved: Need a quick Indirect() reference
Excel 2007 - Change Default Format Data Labels Option
Import text file format to excel difficulty
Solved: Reloading a combobox with found data
Solved: Using Formulas matrix in VBA and drag down
Excel 2013 Compatibility
How to apply a Formula in a whole column...
VBA Excel - PPT loses textbox at Slides.Add !
Solved: Pie chart series rotation
Automate a process to run every hour
find large numbers and delete
Setting the Name for a Dynamic UserForm
Forcing input format for dates?
Solved: Autofill column with the values from next column ...etc
Userform label Text link...
VBA to auto-remove missing Refernces
[SOLVED:] Solved: force pastespecial values
Excel / VBA Left Function (Fine-tuning)
Calculation Speed
Change object properties for previously created objects
Macro not working in Excel2013
ELSE without IF error
Consolidate Worksheets(and new added sheets) into 1 Worksheet+sum by date & customer
Some fun with message box????
[SOLVED:] Popup when calling function
Splitting data in a cell to multiple
Need help in collating data from multiple excel files
Solved: Delete Cell Content based on criteria
Solved: Excell crashing for apparently no good reason
Find, Copy Text from Word and paste in excel
Hide the form on a worksheet
Macro/VBA Beginner-HELP!!
Subract last cell from above
Check Word, Powerpoint and Excel files for embedded objects
Errors all over the place!!!
Allowing user to select range of columns for comparison
[SOLVED:] Move the mouse cursor in the top left corner of the selected cell.