View Full Version : Excel Questions
- Formula - Date
- Any ideas on what I am doing wrong?
- Breaking dates a joining them back
- using functions like IF
- Find Number of last row in a non-contiguous Print Area
- Revision
- format value to be displayed in msgbox:
- New Cells, One line at a time!
- Protection of cells and memory usage
- Message Box
- Advanced Topic: Can Events "Bubble Up" to the Form
- Excel---simultaneous entries??
- Excel
- HELP! I'm getting a new computer - AS WE SPEAK!
- Find and paste value
- Sumproduct help (again)
- Need to run three for next loops at once can't figure it out
- need bond formula
- Conditional Formatting and Check Boxes
- Detecting a change in selected items of a listbox
- Can macros link to word?
- Dynamic Print Ranges, Possible?
- Need VB Code Help
- Pass A Password To A Protected Workbook
- UDF Lookup vs Vlookup (Efficiency Problem)
- Excel N00b vs Da Comb0 BoX!
- duplicate names on a list
- Help with Symbols in arrays...
- suppress message box before deleting sheet
- Highlight a Row Depending on Active Cell Using Button?
- VBA: Create BackUp, Error Handler
- Down 1 cell with auto-filter on
- Indirect sums (easy for you..hard for me)
- Can you email from excel?
- Paste without Selecting
- Update a file automatically from a web page upon opening
- Trigger macro with keystroke + left mouse click
- Grand total for subtotals in a group
- VB
- Candidates Files
- Colour Index Number
- Macro requirement
- Data Validation - "Indirect" Help Please
- Array Tables
- inputbox
- Adding values to pivot charts
- Formula 360 days
- Preventing e-mailing of spreadsheet
- Formula for working out minutes per mile.
- Countif but using multiple conditions
- Magically Appearing Link!!
- (Real) Automatic Layout and Row numbering
- Stop recording toolbar
- Countif Help!!
- Simple Macro Doesnt Work
- Z Axis Chart Scale
- Problems with a line graph in Excel 2002
- Using Workbook_Beforeprint from the .PrintOut method...
- Dates and Years
- Crash (send a report to Microsoft) when file opens with form
- Rebuilding progressive numbers into filtered cells
- uk tax formula
- This is a strange one.
- let's try again - pasting values and recalculation
- worksheet dilemma
- simple csv import Q
- Help with LOOKUP formula
- Macro to copy subdirectories...
- Formula for counting weeks /year
- CHECKBOX, ActiveCell, Range, If - how to get hyperlink in A1
- VBA Autocorrect - ActiveCell.row not auto correcting?
- rearranging rows of address field cells into label format?
- Nested IF AND question?
- Links
- Style Templates
- Go to lastrow using other column's lastrow
- Disabling a Confirmation Screen Possible??
- SQL.REQUEST Array Formula Help Needed
- Print & Exit Macros?
- Percentage in Pivot Table
- How do I prevent duplicate entries across sheets
- Excel Crashes! Alot
- XLA-references change on different computers...
- Looking for peak day, lookup
- Creating forms
- Array Math Problem
- Looping Problem
- Upgrade
- Holidays list with Workday
- Is there a Message board like this for MS WORD
- RANGE - merged cells / columns causing problem
- Get Number of records from Access query, to put in an array.
- RANGE - merged cells causing a problem?
- Get Number of records from Access query, to put in an array.
- File Locations
- Option Button Printing Problem
- worksheet 'growing'
- Find button
- Copy Only First Six Digits of Column D into Column E?
- BETAINV function
- transfer textbox value to activesheet
- Need formula to determine units produced in 1 hour
- Passing a Range from a one Sub to Another
- Selection Problem
- Convert Function
- Two-variable data table
- VBA Cleanup
- Protecting worksheets from Copying.
- importing txt, not all of it though
- Hide Graph Data Source
- Lag When Changing Cell Value Via VB Code In Macro
- Corel read VBA just as Excel?
- Finding the average of a month
- Message Box Cont.
- Suggestions on how to optimize for speed...
- Removing numerical values from a text string
- Restore Cell fill colors after printing?
- Trying to work smarter not harder
- Summarizing two columns
- Refreshing data loses subtotals
- Delete (or hide) the 'ALL' in a pivot table Page field.
- Criteria or Tables Not Shown In Microsoft Query
- Macro
- Extracting hyperlink from a picture
- filedetection ==> phantomfiles
- Stability of linking with Word
- Pause button on Form
- Is there a way to Pass a image between sheets using =INDEX
- Lookups, cross-referencing, matrix-style tables
- vlookup question(?)
- How to identify data in 1 sheet using data from another
- Match
- textbox focus
- sumproduct not "picking up" some values
- Excel Madness
- Some very basic Excel questions from a Newbie
- Return to Excel after sending w/ Outlook
- How to Create Two drop down buttons
- textbox treats all data as text
- Compare two variables in pivot table
- VBA Code: From cell A of last row of data to cell X
- Copy Cell Values
- Is there a way to do that on Excel?
- Listing files from your computer
- Inserting a Page Border in Excel? Is it possible?
- lookup and match
- Auto Filter
- Maximum different colors Excel can display via VBA?
- Speeding up a filesearch loop
- Fill cell when width changes
- Adding Issue
- Emailing
- deleting print are in name box
- Finding and replacing multiple cells
- Workbook open VBA question
- Advance VBA
- Links and auto filter
- counting cells in a column by interior color index
- Print macro problem - stuck in a loop
- Msgbox positioning
- Problems with different versions of Excel
- Long column is causing blank pages on print even when hidden
- (Mutiple Chart Types) Ranges inserted in Bar Chart
- Scatter Graph Labels
- [Excel 97] Print link sources
- Little help on generating text in Userform
- Default Left
- Indexing an Excel Sheet
- quickie "sendkeys" question
- method ok code not so ?
- Ipmorting txt files
- Formula to grab data from another open workbook
- Fill down formulas problem with shrinking columns
- closing large workbooks quickly
- Can macros link to word?
- Automated downloads
- Newbie Question
- vba to close open instances of Exel
- Formating TxtBox's
- Any clue if this should work ?
- get an Excel sheet from powerpoint back to Excel
- Managing Access from Exel
- VBA Code Needed for Auotomation
- Auto Filter Macro
- Problem in Vlookup formula
- Group by percentages
- copying from rows to column
- how to import....
- Return Next in List
- Combininations of statements
- Hyperlink to another document
- Merging 2 columns
- how to prevent a user from seeing the visual basic
- Hindsight is 20/20?
- auto look up for stock numbers
- Vlookup different sheets
- Excel VBA -Cell Validation
- Referencing Current Column
- CHANGING BUTTON CAPTIONS
- Auto Sort macro Problem
- Checking if a worksheet exists and delete it if it does
- Formula that has text and a cell reference. (Dear, Client)
- Quoting cell refrences
- Sumif -- two requirements
- Creating Forms (Templates) from Databases
- Question on custom formatting cells
- What am I doing wrong with this Is statement?
- Automating the File Save As command
- Lookup
- VBA Autofilling a Range Question
- Conditional Data Validation
- Matching text and numbers
- respectfully rfc VBA code to prevent run macro twice
- Formula to match 6 numbers
- Why wont this macro work ?
- What function can I use?
- Picklist
- Optimum LOOKUP/MATCH question
- Array IF statement problem
- Copy Subtotals to new tab?
- VBA date code needed - help!
- Hidden Rows and Columns
- Looking for reference forumlas to cascade a list
- text lenght with zeros
- Subtract Time
- Counting
- hour calculation....
- sorting numbers
- Class module for textbox will not work??
- Changing Printers Mid-Macro
- Concatenate all possibilities from 3 columns
- having some problems with web front end
- match, index help...
- Remove quotes when saving file
- trying to figure the ratio
- option other than OFFSET...
- Excel Bar Chart / Vary Colors by point
- more than 3 conditional formats?
- combo box properties
- The First few characters
- Not sure if there is a way to cartire macros being fired
- Code for opening a password protedted sheet
- Cell Validation Based On format cell
- Format Question
- Possible Sum Product...but with a nested vlookup as one arra
- Selecting a 'Calendar' option ????
- Combinations
- Replacing Text In A Cell
- Printing new Excel rows to a line feed tractor printer
- Run time error '9': Subscript out of range
vBulletin® v3.8.7, Copyright ©2000-2012, vBulletin Solutions, Inc.