View Full Version : Excel Questions
- Excel - Access Question
- Storing data in VBA rather than Excel
- Too Many Graphs?
- Perfect Code that's Broken
- Password Protect Folder
- Change a cell to being locked when cell equals certain value
- Excel File Size
- Advice sought: most effective way to find a 2 col match
- Loading values from lists in different xls files
- Do a search and delete rows without the search term
- SUMPRODUCT within a RANGE
- GetAllSettings to range
- Pivot Table question using Excel 2003
- Copy macro
- reference data from sheet 1 to sheet 2
- Search column if it contains a word, if true, paste/concaten
- grouping data and worksheet protection
- Creating IP subnets from IP addresess
- reusing array causes subscript out of range error
- Paste special Formula & formats
- PivotTable: Error- This command requires at least two rows
- Countif Formula
- Open Excel file at a set time
- Help Me Pls
- federal tax formula
- Will COUNTIF or SUMPRODUCT somehow solve this problem?
- Count Numbers with differnt text and cell colors
- count if prob
- copy to new sheet
- dll files
- Adding "browse" feature to auto-prompt box
- Consolidating Data
- Web query problem
- Removing Selection Privelages indefinately
- Userforms - text boxes
- Question on protecting a worksheet
- Hiding toolbars
- Batch print with listbox
- IF?
- Moving Average Cross
- copying automatically ranges from 2 different sheets
- sum between to dates)
- Help on Workbook - BeforeClose event
- Aggregating values between dates
- Help with my if statement please...
- Template woes
- Inserting rows
- Pivot table totalling
- 2D Array Subscript out of range
- Autofilter & Copy - 2007 problem
- FAceID's in Excel
- VBA code for ranges in graphs
- vlookup,sumif or something else ??
- How to edit cells in ...
- correct this code please
- Open & Navigate Secondary Workbook w/Hyperlink ?
- Do until cell is blank
- TOP 5 TABLE
- Help with simple If statement, please...
- trouble restoring a deleted secondary Y-axis
- Alpha and Numerics in a user form
- [VBA] AppActivate part of app name is random
- looking for code to Move a worksheet into (New Book)
- Help! I can't create a range in Excel's VBA
- Calling a Macro
- Validation
- Calculating task completion time in working hours
- Saving a .xla file as .xls
- Edit workbook in a second instance of excel...
- Elapse Time includes days
- Linking files to a sheet
- Workbook not responding
- Gauge chart
- Count unique combinations???
- insert row if above row has a different value
- how to add an average line to a column chart?
- MODAL Text manipulation
- MODAL Text manipulation
- Print Area LINK
- Finding a specific cell
- vbs opening vba projects
- Graphs - missing data plots
- Automatic numbering
- Line on a grapgh
- fixed value in a formula
- A Macro to Delete Macros?
- Need help comparing cells
- excel file name
- How to do this
- Row transfer
- Displaying a userform while running a macro...
- Reformatting a Excel Spreadsheet...
- increase speed and simplify VBA
- I'm trying to use the SQLOpen Function and having Difficulty
- Question ABout Not Grouping two open Excel Files...
- putting data into a named range
- Printing
- CSE Formulas in Excel 2007
- Vlookup Issue
- Remove text
- TURNING TEXT INTO A VALUE
- Displaying Neg times
- Secure Excel Watermark
- Colour issue
- Pivot table calculation help
- File is read-only when emailed?
- EXACT: can it be used down ranges?
- Creating combo boxes and assigning generic event handler
- Replacement for OFFSET
- deleting macros
- Nested ? V-LookUp
- Renaming a bunch of files
- Installing Multi Operating systems
- Turning Auto Fill Off
- how to rename a sheet automatically ?
- Looking up data across multiple rows and columns
- Macro doesn't work for certain people
- Accessing data from another Sheet..
- Formula help Unique count and percentage
- Copying HTML data in MS Excel 2003 causes cells to be locked
- GENERAL MAIL FAILURE
- consolodating data
- If/Then loop that will return a blank space (?)
- Data Table in Chart
- Save XL as DAT file
- selecting a range of noncontiguous cells
- DIV/0 sign
- Search for strings in a cell using OR
- IF help
- plotting 3 axis
- Need to match information based on repeated identifier
- Check Box Question
- Easy ComboBox question I'm sure
- macro for duplicates
- How to create a Web Hyperlink based on Cell Contents?
- Convert numbers as displayed to text
- How can I delete or bypass code?
- Another SEARCH Question
- Pivot table problem
- COMBIN Function
- Create multi-condition sum formula
- Have shared workbook send an email notification when modifed
- Signatures
- Delete everything in a cell AFTER a comma
- Calculate SUM of one column after getting AutoFilter results
- Links
- can't Protect or Unprotect from BeforeSave event
- can't Protect or Unprotect from BeforeSave event
- locking cells
- Limit Row Height for Rows in CurrentRegion
- variable for range of contiguous cells
- Calculating Mean and Variance for Bivariate Prob. Dist.
- countdiff IF...
- Limiting Options
- Rank problem
- SUMIF and Concatenate Problem
- MouseUp Event Procedure Help
- Managing defined names
- Multiple arguments returning #VALUE!
- Fill in field based on another field
- find, count and alphabatize names in a table
- need more VBA help
- Adjusting the size of a placed graphic -- help please!
- SOLVED-Making a command button visible based on data in cell
- Formula resulting in False instead of a number
- Math question with addition. Is there a function for this?
- Need help with setting or something that is making macro err
- question
- Free grid control for VBA Form?
- How do I create a 3D "column" surface graph???
- Hide row based on cell formula
- runtime error '17' - Can't perform operation
- Please Explain this formula to me
- adding date and time in one cell
- Merge two arrays
- Column Headings
- Hide Columns
- Open new xls using
- Monthly compound growth rate?
- Putting an entire selection of dates into one cell.
- Listbox in a Userform VBA
- Error with code (Save button)
- Solver Decision Variables--how to include or exclude values
- Initialize a listbox-I'm sure this is an easy one for you...
- Not very good with excel
- VideoSoft FlexArray Control
- How can I make sure a workbook opens with macros enabled?
- Formula Query
- Extracting number from my data
- Confirm analysis toolpak installed before proceeding.
- Hyperlinking
- PLEASE HELP! multiple formula...
- Possible lookup question but returning column headers
- Read line or Arrow ( shapes) from excel
- Automatically Deal with MsgBox
- Formula to get windows username
- Changing names of pivot tables
- Excel 2003 problem
- Counting months
- COUNTIF
- more than 65k rows?
- UDF for Buisness Hours Worked
- Searching a workbook
- Delete and space text
- Return Which sheets have been printed?
- Mask in user form
- Formatting Cells on Excel.............
- Problem with a counting formula
- SUM PRODUCT
- Clear cells macro on a protected worksheet
- Worksheet change event help
- Report Filter in Pivot Table
- Identifying a worksheet
- Loop with changing variables
- duplicate cells a fixed number of times
- Conditional Formattiing
- Combo Box help - Hiding blank rows in the drop down list
- Graphs with broken Y axis
- F9 feature
- VLOOKUP with IF statement nested?
- Autofill with VBA
- How can I maximize my userform upon opening?
- Checking for Read-Only on open
- unable to sort
- Creating a variable function in a macro
- COUNTA function, subtotals, totals . . .
- Sheet tabs
- macro in shared workbook
- Fuzzy matching
- Converting figures from 16,500,000 to 16,5
- Macro creating a macro
- Macro
- Correct syntax for formulae
- Multiple Selection.AutoFilter Fields
- Send to Routing recipient - 2007
- Populate listbox with external data
- this should be simple for experts- conditional summing
- problem Spliting Names in a macro
- Subtotals - adding more rows
- Bypassing a Warning Box in a macro
- Turning Duplicate Numbers a certain Color
- Code not working on all computers??
- VB code for variables
- Combo Box To Jump Between Sheets
- Log in and get file w/o Internet Explorer and SendKeys
- Data Recovery
- IF Statement and Rounding an Equation
- sheet locked
- Sumif Error
- consolidating files with a macro
vBulletin® v3.8.7, Copyright ©2000-2012, vBulletin Solutions, Inc.