View Full Version : Excel Questions
- vlookup returns 0 can this be hidden
- Automate Sheet Names
- If then And statements
- Clearing contents from another cell
- Unprotect multiple files, & do search and replace
- Easy Userform Question
- Trouble identifying HTML source code for IE Automation from Excel VBA
- Create histogram based on a column
- 2x2 Matrix / Scatter Diagram
- remove rows
- Vlookup Help!?!
- sorting date values within pivot table
- Counting formula: counting new entries between sheets and numbers deleted
- Autofilter Date VBA Issue
- Update a function as soon as columns are added
- Macro to save a CSV file
- Help copying info down to last line on sheet.
- Command Button on Userform that checks Checkboxes are Ticked
- copying ranges
- Display font of listbox/ combobox (not dropdown)
- Run Open File Macro
- Cell > 0 Condition
- Cell > 0 Condition
- Full File Path
- 2007 Copy Conditional Formatting
- Help with Line Coordinates
- Loop through charts to change number format
- Passing variables in Macro calls?
- Check Boxes Question
- Multiple Copy and Paste
- How can I stop reference errors in formulas and still delete cells from it?
- Ending a macro with the [X] button
- Macro for ISERROR
- Multiple Pivots
- Finding # of years between 2 dates
- What's wrong with my macro? "Corrupting" my sheet?
- VBA code to place formula in cells
- Simple macro question
- Simplify this nested IF?
- Sumproduct And Right Function
- Would Appreciate Some Help - Please
- Selection Change Event
- Enter Keys Different ?
- Look-up macro not finding what it should...
- Formatting a worksheet for a user view
- Modify THis code to avoid 1st Empty Row
- Incrementation.
- Delete empty rows and columns
- Method Range of Object_Global Failed
- Excel Number String - VBA formating
- Help- Translating entry in input box?
- Data Validation - Drop Down Font
- Run Macro on multiple worksheets
- Copy data to summary on next available row?
- Need help deleting half of the worksheet w/ MACRO
- Merging CSV's
- Cleaning up an Old Excel Spreadsheet
- Before Close Event
- Fill blanks in a table with macro - Excel 2007
- New to user forms
- drop down lists
- Display table from Excel in UserForm
- I thought it would be simple
- Combining Multiple Columns According to Name
- Dates please help..
- Using a value in a cell as a max range for a sum
- macro for deleting/refreshing certain cell values
- Which formula should I use?
- VBA Macro help : matching column headings
- Using EssVSetSheetOption macros to turn retain on/off
- html in excel
- Countif question
- Column Selection
- Dynamic Range and Next Available Row
- Help Validate UserForm Fields . .
- Count Function Help
- Combining two columns of data to create new series
- VBA: adjusting size of comments
- Vlookup and Copy and Macro
- Percentage for Yield
- Calendar Form when cell is activated
- Cross table/3D table to Flat File table
- #Value! in pivot table - can't get rid of with if(iserror...
- Dynamic Chart Failure
- Access to Excel Sql Query Memo Field
- Event Driven Macro
- vba: windows path dir invalid? spaces possibly causing the problem
- Reset Variable to Empty
- how to filter multiple values in sheet ?
- Automatically Say Yes to Excel Questions and Continue Loop
- Macro help
- Custom Toolbar Question
- How to remove unwanted rows
- Simple code for checkboxes
- OR Function nested inside the last criteria of a COUNTIFS
- Delete blank cells in linked table
- Currency Formatting Having No Effect
- Type Mismatch
- Excel "If" Statement Query
- Line chart
- Statistical Questions
- Excel 2007 - I need macro buttons
- What is this mean?
- External references
- Trouble at picking up correct sheetname
- Formatting Text from email to Excel
- Querying and Relating Data from Multiple Sheets
- VBA - Exporting a file
- If then Else
- Combining Cells
- Dates
- Keeping a graph attach to a row when ranking
- multiple conditional IF AND
- Referencing clip art in a formula
- Compare value in cells on different pages.
- Help With Small Code . .
- Shortcut Key for Custom Toolbar Command BUTTON
- 2-Column Listbox on Form Help
- Using Macro to add 1 to cell that is looked up
- "Office 2003 Access Keys"
- Freeware code editor?
- Using Formatted Data in a Pivot Table
- ADO Connection Error
- Multiply All Cells in a Range by a number using VBA
- Shared file Prints Differently when Accessed by Different Users
- Macro to Create a Complete List
- Merging duplicate cells
- Lookup feature
- Blank Spaces in downloaded data
- Dynamic Range by Column
- Prompted for File Password When Executing Macro
- Merging two Databases
- Fill color with gridlines
- D Lookup in Access
- Copy row with data to second sheet
- Transfer a .ps file into Excel
- Data from one Colum to Another
- Subcategory list based on selected category
- Selecting multiple items in dropdown
- Find and Delete sub
- VBA code for comparing data?
- Open all .xlsx files in Directory and Refresh
- Emailing Worksheet
- Mailto after print???
- Conditional Formatting
- Converting Text to Variable Names
- Activesheet as form variable
- Difficulty with IMPOWER() Worksheet Function
- Clearing rows with a zero or "" quantity
- plz help with macro for deleting certain cell values
- property for blank cell?
- Lookup Formula
- What's wrong with =SUMIF(G:G,"occ",F:F,"utl",B:B)
- msg box
- referencing cellswith values in them
- msg box only once
- Drop down menus have disappeared
- Add 1 to a cell with macro. Cell will frequently sorted
- Codes Need to be Concise
- Help with multicolumn listbox
- American vs Australian Date Format Issue
- mem. mgt.
- Drawing Lines w/ Cell Values
- How can I get the Cancel button on an InputBox to Exit Sub?
- finding first empty cell in a column
- Numeric AND "-" Entry Help!
- Loop and copy
- Dynamic sheet reference Or dynamic List
- Macro to sort descend on a timed basis
- how to make use of reference tables using if, else if functions
- Excel help!
- adding columns to table
- Fixing a target cell in copied formulae
- Close a file with a marco
- Run Time Error '9'
- Duplicate Entries
- Conditional default value
- Ojects and Conditional Statements - Help, please
- auto add ( + )
- Writing an Array to a Defined Range in Sheet using a Function
- Fixing columns so they don't scroll
- month subtract
- Is this protection possible?
- Age based calculator
- convert several raws to one column
- function for assigning customised week number in XL2007
- Locking cells based on criteria
- Help to execute one formula in excel
- What formula do I use?
- Order Form to Show Only Items Ordered
- Macro - Howto use InputBox value as Row Reference.
- undo disabled after vb statement: range.name = nm
- excel and word
- VBA help
- Counting Cell Colors
- Create Text file from Excel (part 2)
- Scanning to Excel?
- Macro Help - Another Slow One
- Merging cols changes bold to non-bold or non-bold to bold
- Automatically copy data from one sheet to another in a workbook?
- Add names to Groups
- ?? multifiles hyperlink
- Extracting dddd from dddd, mmmm dd, yyyy format
- Need help with ActiveCell
- formula for date stamp
- Active Worksheet Problem
- VB Loop to to delete blanks
- User form command buttons
- Change userform backstyle to transparent
- HELP!!! Command Button Image covers text
- Change Command Button Shapes
- How to call up a cell.
- Increase Scope Of A Routine
- Hide/Unhide Rows using VBA...
- Trouble with New Sheet Macro
- named ranges problem
- Strange character in textbox
- not enough resources
- Text inside cells?
- VLookup Formula
- Help on protected spreadsheets and user edited data
- Search Comma Limited String
- easy If statement problem
- Excel 2007 and Excel 2003
- Change position of Autoform
- How to make a function between 2 Excel Books?
- UserForm to select Row and Column from 2 prompts
- Msg Box Question
- MS Excel help
- Even/odd number question
- vba vlookup & named range
- Help!! Need Fields in ONE row instead of THREE
- MS Excel help
- Compound Daily Interest formula Help
- Problem saving Sheet as Text file
- Pmt
- Set focus on Image Control
- Average Based On The Day Of The Week
- Interactive Excel on Web??
- Need To ID A Cell If Text In A Cell Is In Color
- Last ten bowling game average?
- Auto Fit
- Using Class Module of ComboBox to Change Other Combobox
- Count days of the week
- Macro help please
- what's wrong with this code? im desperate
- Match number in two columns of data and copy assoc. data
- Calculate difference between dates excluding weekends
- How do I copy a bunch of formulas, but change the worksheet they refer to?
- Moving Average...Calculate average of last 5 days?
vBulletin® v3.8.7, Copyright ©2000-2012, vBulletin Solutions, Inc.