- open excel file via VBA with a twist
- data validation cell populating another cell
- Interesting problem between excel2003 and excel 2007
- Finding and assigning data to keywords...
- Auto-populating checkboxes
- Query close Class Module
- Multiple Lookups
- editing formula's in lots of cells
- How to lock external workbooks
- Auto populating check boxes
- Ribbon and Menu's dissappear when opening Excel 2007
- SharePoint And Excel version 2003
- Help with Max Value Problem
- Remove blanks from a drop down
- Conditional Values
- Code to select header, subtotal, and grand total rows
- Can't start excel
- roundup / down
- Specialty Search with Calculation and Output
- Excel and Solver. Problems with Precision and Convergence
- Average with multiple MAXes
- Mid, left right extract.
- Count # of #N/A
- Excel inserts wrong number of rows
- 2003 vs. 2007
- Axes problem on Stacked bar graph with 2 axes
- Combining data from worksheets in different workbooks
- Macro - Task List (Process Check List)
- Macros enable
- Help with IF command formula
- Summing values in a LOOKUP formula
- Userform commands to print and convert to PDF
- Need formula to parse data
- Excel For Mac 2008 - how to ungroup a series
- Count every day
- grey out title or cell heading in cell to be typed in
- Graph issue: From a formula to a list of data points
- Paste shortcut?
- Unmerging text
- code for sort
- Vlookup multiple columns
- Help needed with code for saving file as attachment.
- Mulitple IF statements over write each other?
- Preserving gridline colour when filling cells
- protecting sheet prevents me from selecting filter
- Clearing out spaces in a value
- Splitting Excel sheet into multiple Access Tables ?
- Pushing a 'slider' to the limit
- Automatically filling in rows for a column of numbers
- How To: Query dates in another sheet
- delete row if cell in column contains text
- Assign Macro to Button
- Extracting numbers and text
- clear & select macro
- excel coulmn to lookup table in access
- Copy/Filter from Unopened Excel File
- How to change a Label.Caption with Worksheet_Activate
- Count on Filtered results not working
- Conditional formatting for 2 cell value
- Run Macro after Data Validation
- applying macro's to cells
- Categorising data according to a table
- Is this possible???
- Conditional Vlookup
- Auto Insert
- Change default pivot table function?
- Option Button
- Adding a sheet to a Addin
- ComboBox saving changes problem
- Sum, Copy & paste data with VBA
- Putting data in chart cells into worksheets
- IE7 launched via VBA won't load pages from google
- Possible to call objects with a variable in VBA
- Remove Zero In Front of Decimal Point
- MsgBox in two languages - How to choose?
- Rounding to the nearest 6 degrees
- Locking exact graph size
- Export chart to HTTPS path
- timer issue
- How to find #N/A
- help for newbie
- VB script in excel
- sumif
- Make appear Cell Value automatically
- Get the column-name/row-number from a named cell
- Help needed, replacing delete row function
- recording a real time data.
- Pop Message required if value is not same
- Formula for automatic recalculation of index performances
- Array Formula
- Modifying the INIDIRECT Formula with several arguments
- VBA to access web folder
- Date time test
- Locking cells upon saving the file (VBA)
- Clustered-Stack Charts In Excel 2007??
- Friend called me with a strange issue
- Find earliest date and latest date in a series of data
- disable button in excel spread sheet
- Dependent Lists
- VBA unique lists onto new sheets
- finding missing invoices and recording them
- move rows
- Executing Perl script in macro
- less than greater than
- Textbox Time Format
- Exclude #N/A
- Calculating an average number of hours over a rolling period
- Run a macro on the cells a user has highlighted
- Loop ActiveCell.Offset Problems
- Excel Solver!! help
- Delete Cells Containing Certain String
- Multitab search
- Odd Year Even Year
- what does method 'Unprotect" of object_Worksheet failed
- Report based on TextBox input
- Excel Table Objects, How to refer to?
- Calculating an average number of hours over a rolling period
- inputting unique references
- drop down lists
- N/A Error
- Help Fixing Code...
- IF AND Formula
- Named Range / use of Indirect?
- Text Box name
- populate next empty cell with sheetcount
- Registrate information in cells based on textbox input
- word to excel
- Search sheet2 for value in sheet1 and output rows to sheet1
- stop a text field reverting to scientific notation
- Validate a string char-by-char
- Sorting Hi to Low
- VBA - Application.CutCopyMode
- Macro - Graph
- VBA: copy of a cells value disregarding the cells formula
- IF function check for Format
- Macro - Graph
- Querys in protected sheet ?
- Return a list from a column of values
- Consistency checking...
- Need help with a formula
- Excel IF Function Problem
- Searching a data range to return a value
- Passing a variable into a different piece of code
- Do I use SUMPRODUCT
- or worksheet function
- Weird Excel 2007 Help!
- Certain Number of hours multiplied by whole number
- dynamic data in table and index, vlookup, match help
- Error 1004 in VBA
- Formats: Half Protected and Half Unprotected!
- Dialog box subfolders
- Disable macro icon
- When copying 2 worksheets update formulas
- Graphing the top ten - Should be an easy one
- Add comments to UDF
- Can I create a pivot table with multiple sheets
- Why am I getting error 400?
- Macro to Check User Accessible Permissions
- Come Together!
- Macros in spreadsheet?
- Deleting cells with a value
- Returning Top and Bottom values of a column
- unhide sheets macro
- how do I find next value?
- Statistical T-Test in Pivot Table
- Loading User Form Before the Worksheet Loads
- Help with a formula
- ActiveCell = Yes
- Cool Worksheet KeyDown Event (like the one for TextBoxes) & w/out Subclassing
- Help[ with a formula
- data validation and cell population
- Dual Ranged Conditional Format
- VBA help with worksheet selection
- Sum of a number series
- Help please is suggesting project approach for multiple user data entry
- filling up the blank cells
- Macro to match the data
- Fill the next three rows
- sorting question
- Copy data from one worksheet to another under condition
- Duplication of a formula
- Insert Multiple Options in Dropdown List
- Create mail and add multi attachments using loop
- Pivot Table Filter from cell text
- dynamic ranges and drop-down boxes
- Detecting if a auto-filter is present
- Hiding cells within my range
- Conditional formula help!!!
- Setting up a dynamic range chart in Excel 2007
- RC sum formula references
- Vlookup for Picking the values depending on the date range
- Hide Except
- Copy formulas from one workbook WITHOUT the references to that workbook
- Can You Add Text and Numerics Without Getting "#VALUE!" Error?
- Help w/unique nesting of countif statement
- Find and Replace from list
- Worksheet_Change: Running when not needed
- VBA to Change front to red if within 30 days
- spreadsheet
- VBA code that generates a user form when a conditional date is entered by a user
- Weighted Average/SumProduct
- A possible formula or lookup table
- Calculating where lines cross??
- Easy Open File Question
- Increment cell reference by six rows
- Inserting symbols using =IF?
- Is there a way to change 126½
- VB date and time question.
- Modify code to look through Specific Sheets instead of all the sheets.
- Library Reference Changing Automatically
- default template on network
- Pulling in Rows of Data into Another Spreadsheet
- Problem with Nested IF
- Vlookup Prob..
- transpose data with a twist
- Hyperlink between two workbooks
- Graph - Query
- Shorten formula
- Start at bottom of Array
- VBA - Merging info on Multiple Worksheets
- Unprotect sheet
- Concatenation problem
- Sum of Named Ranges Across Sheets
- Show highest consecutive cells
- 2007 Query Refresh on Paramater Change Issue
- Auto complete for a combo box
- Can you do a lookup from right to left?
- vlookup and hlookup problem
- Match multiple columns in VBA
- Pulling web data
- If Then Loop
- complex vlookup and if situation..help!!!
- VLookup returning zero
- Having a drop down selection in one cell populate another cell with associated data
- add/subtract last rows in columns
- Excel 2007 Text Cell stops recalculating
- If then, date + 15yrs
- VBA Sort Based On Two Columns
- I need to get a count and can't figure it out.
- Ranking/Sequence Challenge
- Vlookup across mutliple sheets
- can I set my own object type like in java
- Button that knows where it is...
- Creating a custom symbol/button for the quick access toolbar
- conditional formula
- combine the dynamically named sheets
- IF(ISERROR(VLOOKUP) vs IFERROR(VLOOKUP
- Insert Row Button Macro
- Rand pick from 4 pools
- Formula: Simple but complex for me