- Working within workbooks
- Conditional Count of Cells in 2 columns
- Problems with multicolumn listbox
- Urgent help needed: Count Unique visible cells
- Inserting column through VBA on locked sheet
- Entering numbers as text
- Quick syntax request
- Sort dates by day
- Runtime error - '424'
- User Input problem
- Run-time error '438': Object doesn't support this property or method
- Protected Cells AlertBox
- Dynamic variable state combinations
- Trying to close (not hide) userforms
- Compile error: Object required
- Only running code when certain criteria is true
- Problem with ActiveX and Matlab Object
- vba to copy formula
- Remove duplicate records
- Break out of loop
- data
- Indirect function
- Double Autofilter problem
- Make a sheet with selectable info, send email using info selected
- ref edit for folder directory on cpu
- call a sub
- Need Help!!
- IF Function to create message or alert
- Placing Logos in Printed Pages
- Merge Duplicate Values
- text to excel conversion
- Criteria Based Cell Replacement
- hiding columns when printing
- format or copy/paste (if)
- highlight formulas
- two sheets to one
- ComboBox control question
- Macro Advice
- highlight duplicates on another sheet
- IF Function - Colour
- copying data using an array with criteria
- Need Assistance With This
- Preventing calculating open linked wb
- Due Date Notification macro
- Copy sheet
- Sorting Error
- Automatically generate new row w/ prev formulas
- why sum range changing automatically
- count and move unique entries
- Sorting Numbers containing Text
- Selecting Rows
- Question about possibility
- I want Your Help
- automating a macro to increment row
- How to copy modules & thisworkbook event code with VBA?
- pls help me
- Make default macro security as low
- Copying Sheets with Variable Names
- Updating Dates
- Function Arguments dialog and VSTO Add-in
- Can I Change the Default Macro Settings ?
- Automation macro produce error when copy and paste
- Copy Function Options
- Array error
- turning off ON_TIME
- Question about creating code through a routine
- fast(er) indexing array??
- TreeView and Tabstrip Activex components
- Search for Range not single number
- Sum values by month for charting
- Insert row code
- Macro shortcuts & VBA
- If and Statement
- Force overwrite when using SaveAs
- Loam Amortization With Grace Period
- Surveys in Excel
- Receiving Object Error
- VBA + Excel - Save ActiveSheet as hmt then Send Email
- VBA to run Query Designer
- Hide rows between 2 pivot tables if they are empty
- save data in anthor workbook
- How can I find underlined text?
- Consolidation… but not really
- Removing text
- SendMail Content in Body of Email
- sorting data
- save a worksheet as xps
- copy from list
- Reading "data" in a sheet and applying to another sheet
- programmatically adding both normal and formatted text into the same cell
- Close after inactivity prevents data transfer macro.
- How to separate a column into two?
- Arrays
- Min Number in a row
- Check for ODBC Connection
- how to query several external workbooks?
- Trigger a macro when leaving a cell
- Excel 2007 Problem w/ Macro
- posting values from one sheet to another
- Excel UserForm is blocking me to scroll down
- Auto Fill IF & Replace IF
- Display form in an excel worksheet without clicking a butoon
- ASCII or ANSI characters
- Change cell background based on another cell
- Macro Optimization
- Reference Variable Sheet in macro
- Spreadsheet Control (import from spreadsheet)
- Problem with macro that works on multiple workbooks
- Storing Column Data in an Array
- Problem with Multiple Ranges
- Cannot insert or delete columns
- Make Cell on Separate Sheet 0
- Calendar with appointments for mulitple users
- Summary page for Payroll
- Merge Sort
- Creating new row in locked worksheet
- Using variable with FIND - REPLACE
- Drop down lists
- Search for Range not single number
- vba/macro
- Timesheet
- IF Macro, insert text
- VBA warning for misplaced workbook
- no duplicate records.
- Worksheet_Change function
- calculating end date&time of a project (workday f.)
- Macro Buttons
- Checkboxes and Dates
- How to get the PivotField i've clicked on?
- Creating Multiple Charts via VBA
- Fire Access Make-Table Query from Excel
- Put filtered data to another sheet
- Pulling data from excel using select
- Import contacts from outlook
- Calculation Based on two Workbooks
- define range based on cell value in another column
- Sorting by Color
- Auto Filter
- Sorting Macro
- calculate slope on dynamic array
- Counting sheets
- Exporting data to CSV file
- Lists - Reavealing All List
- Delete Rows - Blanks & Header Records
- Automatic message box when deleting a worksheet
- Send mail to specified mail addresses if a situation qualifies
- Code To Run Upon Active Page..
- Cell coments into Word
- Dynamic Range using Autofilter
- Simple Line Add-on function
- Saving a file
- How to make worksheet availale for multiple users.
- Locate CD-ROM without specifying its Drive Letter
- Conditional Merge VBA
- Dates in an input box
- differences between cell formula and vba?
- Search dynamic selection and delete cell string
- mail Code no longer working in 2007
- vba text search
- Bring Back Multiple Items Based on Common Number
- Delete rows if found in a range
- Radio Button to discount value in cell
- Calling Formas and macros in an external workbook
- stock levels
- Count filled cells and insert rows
- Automatically Clear Old Information
- Validate a textbox
- Getting a macro to automatically run by date
- Comparing Months with Numbers
- How to add column values using a macro
- Macro to detect bold text
- Finding non duplicate entries
- Add Hotkey for Sub?
- Colorindex and Comment array
- Call Macro from Workbook Variable
- save copy and run macro.
- Macro to insert formatted row above active cell?
- Min and Max Function
- Loop through certian sheets
- create a sub-folder
- Add-In Menu
- Find and Delete Using VBA
- Running a macro automatically when a cell is edited
- Select a range of cells
- VBA Match into Open Workbook
- macro that hides rows run slow
- Select and compare multiple cells within rows
- Open WKB, run macro, export data, close, loop
- Code to copy rows
- Parenthesis
- make one workbook close another
- Data Sorting
- Input box text format/hiding
- How to reset the combo boxes (remove selected values)
- Public Variable
- How to get the Path
- VBA Code vs Macro Recording code
- Delete Button for Combo Box list?
- Selection.Interior.ColorIndex
- Create word document
- Override Delete Confimation Dialog Box
- Copy, Paste, Move onto next cell...
- Hyper link to call function
- cell referencing
- create cell names from VB
- Cross Post >> Use Vba Variables In Formula And Function
- Unselect locked cells when protect/unprotect worksheet
- three rows data in one row?
- Run Spell Check
- Covert Formulas to values
- VBA Teaching Book
- Changing Auto Filter Based on User Inputted Cell
- Detrmine How Many Rows are Frozen At Top Of Worksheet
- how to call a macro from vb code?
- macro to automatically send email to two addresses
- Excel Solver
- Trying to Email the files in a folder
- seperating a number into many by percentages.
- From one drop down to another
- getting all the excel file name in a folder
- Multiple if nesting
- Using same subroutine for multiple Command Buttons
- Data Consolidation
- Saving a workbook when a cell changes
- Workbook Event to generate InputBox with validated data after copying of worksheet.
- Select and format to end of row
- WRAPPING column info to rows
- CheckBoxes / OptionButtons reference to Cells
- Automatically move data to another sheet
- Finding an insert point in Word
- Changing cell data by just clicking on it...
- compare workbooks
- Display sheet on day of the week
- macro to spread costs dependant on criteria
- Hyperlinks Within a Workbook
- Where to Put Common Code
- Spin button function
- Multiple IF statements??
- Iterating through discrete multiple column selections.
- sum calculates by row, not column and does not loop
- Compile Error
- Common Values
- curdir malfunction?
- VBA conditional cell coloring
- Passing Variables to a UserForm
- Formating a form
- Upload data from excel to sql server
- Julian (dddy) to Date
- Executing On 'Return' or 'Enter'
- Conditional Formatting & VBA Code