- Solved: Assist in Converting IF-Then to Select Case
- Error Handling: Complete exit
- Buggy scope of a variable
- Pivot table macro
- Highlight row if date is this week
- Disable menu options
- Solved: Using Object Browser: Discover New Info
- Returning to Excel from Paste in Word
- Commenting code
- Get File Extension
- Running a macro when excel startsup
- [SOLVED:] Excel/Word timing problem
- Rename Multiple files. Help wanted
- Calling Word macro from Excel macro
- Excel 2007 Multiplication Bug?!
- Solved: Close all instances of IE
- Not sure how to Amend current VBA code to do one more step
- Excel Add ins - Free Ones
- Setting values to a whole range at once
- Solved: How to call an action based on input
- Solved: Loops and linking to Internet Explorer Excel file
- [SOLVED:] Prevent Delete of Certain Sheets
- Solved: Deleting group of rows if string pattern doesnt match
- Change empty cell to a character in VBA
- output to textfile
- Need a function to convert mm to inches
- Critical Error: Odd Behavior on This particular Line all day
- Solved: Multiple Pivot Tables - simultaneous field change
- Holiday planner/tracker
- Solved: Code execution interrupted
- Amend code -
- Check for active Word document
- Add records to table (excel)
- Solved: Insert Rows and Transpose
- Pivot Table Settings
- Shorter way of putting names to SeriesCollection
- Delete unmatched records
- Solved: Excel 2007 Multiplication Bug Da Capo...
- Paste Special?
- convert a number into month
- Count --> all worksheets
- WORKDAY function
- Solved: Changing text in multiple cells
- Solved: string problem
- VBA - conditional formatting on several sheets
- Solved: Copy works, copy/paste doesn't... (bug?)
- Solved: Excel 2007 viewer
- Send Key function help
- Copying an entire sheet into another workbook
- "Unable to get the Find property of the range class" Error
- [SOLVED:] Stopwatch in Excel !!!!
- Solved: Pass Variable Reference
- a list of all formula in activeworkbook
- Solved: Non-Contiguous Copy PasteSpecial
- Auto fill a form
- Solved: Creating new worksheets
- Solved: type mismatch on open
- A Free ebook on Excel from MrExcel.com
- Solved: Pass a workbook and worksheet name
- Solved: Shapes: Some Explanation Please
- Why does Object Browser Show Same Items Multiple Times?
- select case and looping problem
- Solved: VBA beginner exercise
- question on 'Install or Uninstall ActiveX Controls (.ocx, .dll files)'
- Solved: Cell Arrangement
- How to search for phonetic similarities in Addresses
- unsort after sort
- How to remove everything but one sheet?
- Shortcut to inserting rows
- Solved: UDF to emulate Weeknum()
- Solved: Why do my URL's change after saving a workbook?
- Batch file execution
- How to skip the cell?
- Hide Rows based several values
- Disable Macro Security by VBA
- conditonal formatting
- Solved: Deleting Rows if a particular string doesnt exist in it
- Userform to change password in VBE
- Postcode Macro - Amending
- AD lastLogonTimestamp Is my code right?
- How to copy two non-contiguous cells
- Left and Find Function Syntax
- Solved: Activating a worksheet whose name is customized
- Solved: SumProduct vs. SUM ??
- Solved: Deleting Rows
- Solved: IsBlank? Missing Library?
- inputbox help wanted
- Help appreciated
- Function to replace formulas
- Attention all Excel Experts
- Sheets Object problem
- Non-contiguous ranges (different sheets!)
- Function macro
- Solved: INSERT CELL COMMENTS IN PROTECTED SHEET
- VBA & Save File name HELP!
- array
- Open Multiple Files & Paste Data
- Solved: Importing data file into spreadsheet
- Date Problem
- Another one for the Experts
- VBA: Summing up a variable length row using ActiveCell.Formula
- Batch file
- Solved: Calling subroutine
- Solved: Sum Function
- Exit Sub w/out Error when Cancelling Routine
- Problems using if-then in direct window
- Solved: MisMatch error on joining two statements
- OptionButton madness...
- Memory issues (#7)
- set range conditional on the numbers of rows
- Solved: Delete same row from multiple sheets
- Error Handler
- Find last row, Offset
- Learning VBA - is this a good starter project?
- Show and Hide Label
- formatting cell or using functions to remove text from cell A into cell B
- Row Delete
- Solved: line continuation on formula?
- Solved: Complicated calculations
- Solved: What data type is this?
- Code Change
- Solved: Copy column "A" to column "Q"
- Percentages
- Solved: I can?t copy formula as text from one sheet to another.
- sum visible cells
- Solved: Trigger a Macro with a hyperlink
- Data Distribution
- Solved: Format(i, "00") works in 2003, bad in '07
- Solved: Quickie- Explanation Properties/Objects
- formatting & updating a group textboxes
- Copy Data from Excel to Access, via Excel VBA
- Solved: Extracting cell addresses from a formula
- Pivot Table Group Months Year
- Code in IE's Close event
- MsgBox
- Solved: finding last row w/ (xldown)
- Error Msg: vba code execution has been interrupted
- Solved: Class Modules??
- Subscript out of range
- [SLEEPER:] Filldown a vlookup with no fixed start point
- 2nd persistant messagebox occuring
- Excel can't find path
- Looping a macro to run at each change in variable
- [SOLVED:] forms and modules
- Option Buttons
- Formula from VBA doesn't work
- How to select & open latest time stamp workbook
- Copy & Paste ranges from multiple worksheets
- Auto SAve
- Solved: deleting rows again
- Solved: With-End With problem
- forms & multipage forms
- wipe up MACRO code when WorkBooks Expire
- for....next
- Using variable to define a range
- code to copy the contents
- Solved: Using Offset w/ rng variable
- CountIF
- Solved: Protect columnn widths
- Creating a Master Spreadsheet
- Solved: Check Value of Array
- Solved: Re-use Automation Object Variables vs. release and re-Create
- list all excel files in a folder
- Sleeper: Date Format
- default sort behavior?
- Cleaner VBA? - Building Array of Months (Fiscal Year)
- Limiting the no of times a macro can run
- Defining constants
- Autofitting columns with a condition
- Confusion about giving a chart a title
- Solved: Extract Excel Files from Outlook
- macro - pivot table
- Solved: Force characters in text box
- Solved: Use Offset to return a value
- Solved: Range Select from Found Cell
- Solved: Userform With Dropdown Selection
- Solved: Variant List
- Solved: [Solved]Copying contents of textbox to clipboard
- Solved: Date Difference YY-MM-WW-DD-HH-MM-SS
- Delete Hidden Name Ranges
- Accessing a macro in a locked project in another book.
- Solved: Searching for multiple values within cell
- Using option button properties
- Solved: Split large data in various sheets
- Solved: Is there a faster way to move these cells
- Data Extract from CSV File with date filter
- prompt
- Help programing an Excel Document
- Solved: Selection of columns and clearing values
- Alter colour of cell text based on value of cell next to it?
- Find "-n-t" in a string and skip it!
- Solved: User form- Need grayed-out options
- Solved: .Find for empty string
- Changing Printers and page sizes in Excel
- Solved: Menu maker
- Urgent help in VBA for averaging data
- Solved: Problem with macro containing Vlookup - error handling??
- Using XMLHTTPRequest within Firefox
- Solved: Highlight Row Based on Column Criteria
- Solved: VBA formatting
- Accessing a control in another (non-Office) application
- Eliminate noise in data points
- Solved: Counting colors
- find a way to copy link
- Text to column with line breaks
- How to add items to a combo box upon start?
- Save some sheets with name
- Solved: How to find the same numbers between two numbers
- For Each / Next Problem
- Solved: SELECT CERTAIN COLUMN BASED ON IF DATE BETWEEN
- Solved: Scroll Sheet Whilst Userform Active
- Solved: How to unprotect sheet in Excel in other program?
- Solved: Copy worksheets with msg box
- Custom validation
- Not able to enter a formula in a cell
- Quirk with Cond Formatting?
- Text box/userform - 2DP?
- Solved: send email from Excel with cells as body
- Sleeper: US UK Date format issue
- Worksheet with alternative calculation methods
- fill down code help
- Solved: repeat macro set number of times
- Solved: a "Sorting" Macro
- check credit cards
- Select first Item in Listbox
- Arrays and Accessing Elements by Index
- [SOLVED:] Factorial Subroutine
- Solved: Delete information in a cell which also exist in another cell
- Solved: hide/unhide rows based on value of target cell
- Excel select data from mess
- Solved: Zoom and Setting Column Sizes
- Solved: Preserve sheets before Macros Runs
- activate original window at end of macro?
- mail a workbook
- Formula / Memory Limitations?
- Solved: Solved - Help to build a function to detect Captial Letters in a Cell
- Arrays, one works one doesnt.
- How to enter a formula in Excel via VBA .Formula properity?
- Solved: Get functions list in Worksheet
- Solved: Convert with INDIRECT function
- Solved: Open pdf file into Excel
- Solved: Create short name
- Macro to tel user new data has been added
- Solved: How to select top three visible results?
- [SLEEPER:] Translating languages with vba
- Fill Column According to 2 Criteria
- Solved: MsgBox appears only once
- Install addin through code
- How to separate words in a cell
- Solved:Error when no comments found