View Full Version : Microsoft Excel Misc
- Compile Error in Hidden Module: Autexecnew
- Pivottable linked to Access problems
- Macro Security on 97
- export database
- a macro to collect data on a loop every minute.
- linking column data in sheets to a summary sheet
- counting numbers in a cell
- need euro currency in excel 97 when formatting cells
- # of worksheets that can be created?
- Excel Formatting
- Trouble with conversion
- Parse out a name
- Spell Checkers Language Option in Excel
- Re: Key use with Excel 2000
- Re: average data by months and quarter
- Web Query: Number convention
- Re: "last saved by" property
- Corrupt Excel 2000
- Re: Merging cells in MS Excel
- Cell right next to colored cells is automatically colored on entering a value
- merging cells and mailing lists
- Multiple excel spreadsheets only show up once on taskbar
- Mail Merge from Excel Data Source
- Disabling Auto Hyperlinking
- macro button refers to prev. workbook?
- starting with a macro
- Sum based on criteria in list
- Help with autofilters
- MERGING CELLS WITHIN XL
- Parsing out complex string
- EXCEL ROW DELETIONS
- Automatcally Hiding Rows in Excel 2000
- Re: Printing to worksheets on 1 piece of paper
- Macro Help!
- Calendar continues sending appointment messages to the Deleted Items folder (2nd post)
- border line in every 3 cells using a excel vba
- MVP's please help. Turning off Auto Hyperlinking in 2000
- Re: Count number of types
- copying a formula when the referenced data is not adjacent
- Can't open two Documents with same name !!
- formula in the same cell?
- Please Help! different widths of the same column?
- Add every third cell
- Re: Forms combo box populated by "Code" sheet
- Deleting Linked Source(s)
- TODAY Function
- Office Clipboard
- Blank Spaces Help
- HELP!!!! Date Calculations
- Excel File Size Too Large
- VBA pasword
- Macros
- Conditional Formatting
- Re: Subtotals
- Re: VBA Code
- Back Up
- Excel generated report via Access
- Using Promp in input box to move between sheets in a workbook
- Pivottables missing down arrow in the row and column fields
- "Calculate" always ON
- Mailing List Duplicates
- Automated Series Numbers
- won't display landscaape
- 15 digit limit
- Excel opens multiple programs
- Re: Can't copy worksheet (second copy in same workbook)
- Re: links across workbooks being truncated
- Re: Microsoft office security update 09/12/03
- Re: Can I Import data from .nab file
- Re: Can I Import data from .nab file
- Quarter of the hour formula
- alphabetical order mailing list
- Alphabetical mailing list
- Re: Alphabetical Mailing List
- Re: Alphabetical Mailing List
- Re: Excel executable File
- Re: The simplest graph
- Problem opening an .xls file
- Do I really have everyone stumped
- Re: Exporting file in Excel 2002 to Outlook Contacts
- Re: How do I Automatically Number?
- Filling range of cells with alpha-numeric text
- Re: Using Auto Fill with Non-Contiguous Columns
- Mailmerge Records Limit
- Trying to find a students location at a given time
- Formula dependant on month/date
- converting neg. # to positive ones..
- Ctrl shift end
- Re: Web query blues.
- Re: Can I Import data from .nab file
- Re: Wrap text
- Gantt chart in Excel
- print Grid Lines
- Excel Database
- Re: How do I print a file list?
- Re: How do I print a file list?
- Multiple Source
- Re: How do I print a file list?
- How do I formulas to convert values into numeric order?
- Re: scroll bars- outputs with percentages
- Multiple conditions formula
- Re: How to do multiple conditions
- Re: How to do multiple conditions
- How do I Define A specific a value?
- how to count characters in a cell
- Making a cell always "point" to another cell
- Need help with format
- Re: Tracking users on workbook
- Autonumber and autodate
- Filter by Color
- Re: How do I print a file list?
- Office XP - Excel
- Excel programme
- auto recovery
- Charting question
- showing numbers lower than 8 in red
- Re: Unique Records
- Date/s
- Extracting data new collumn
- HELP WITH A MAIL MERGE
- converting to access
- Weekdays Autofill
- Re: Quotation marks in a string
- Today's Birthdays
- Re: Quotation marks in a string
- Enabling menu items
- dashed line printing problem
- Even Number Formula?
- Excel Formula for Column
- Re: Quotation marks in a string
- diagonal lines in cells?
- Deleting blank rows en mass
- Re: Unique Records
- Negative dates and times
- How to calc a column of formulas?
- Math Symbols
- replace/substitute
- Data Shifting Question
- building a master price list
- master reformat cells to comma delimited format
- openning word file in excel
- openning a word file in excel
- Number of characters per cell
- Re: "Unable to read file"
- non-regular payment amortization sheet
- How to open newer XLS files in Excel Version 4.0
- "Unable to read file"
- Calculating age from DOB and DOD
- multiple work sheets
- Nested Vlookup Looking for Error Workaround
- Select worksheet with Application Input box???
- Charts - To change axis intervals/display
- whats excels prob
- flashing background
- Scroll Bar's bubble identifier
- HELP: Excel changed all my hyperlinks A:
- Excel 2000 Error - Memory
- Printing sheet to pdf file - lines on graphs don't match axis
- Stopping: Cell Editing hides cell above
- 1. excel file read only 2.login/logoff
- Re: Calculation Updating
- Re: Counting weekdays between two dates
- Re: Counting weekdays between two dates
- split worksheet
- Cells not printing
- Re: IF AND Combination
- Multiple files problem
- Re: representing -ve & +ve values with text in adjoining column
- Function to Assign a Value to a Different Cell
- Modify Excel default cell width for Access export file
- How to find duplicates in my document
- Windamail.dat
- List of paper sizes incorrect/incomplete
- Exact column width using keystrokes
- What is a comma?
- Cell Text run-on question
- Exact column width using keystrokes
- Adding an image to a footer
- running totals
- Using an if statement to display an array
- SuperSlowMovementInWorksheet
- VB6 - ADO - Excel XP, cell formated as text
- Re: What is a comma?
- importing access data into excel
- pivot chart formatting.
- If Formula
- Active Server Pages to Excel Sheet
- exel convertion
- format change
- Accumulating Daily Updates
- Opening an Excel file in Browser
- Multiple Conditions and formulas?
- Help! How can I upload data and display it in Excel on client
- How to sum in base 60
- Message to replace contents
- Excel Sharing Problem
- Comparing Repeating Cells
- Solver add in ?
- Office errors
- Compare adjacent numbers Within Cells
- Re: Not so hidden?? Unprotected??
- Importing an ASCII time one character per column
- Autofilter Issue
- Re: Not so hidden?? Unprotected??
- Sorting with headers
- Macros
- Re: Using pivot tables to consolidate data ranges
- Changing the case of items in a column
- counting cells with time criteria
- pasting into merged cells
- Find Blank Cells
- Re: What is a comma?
- Format date
- Conditional Sum - Error 1004
- Re: Placing Result of Calculated Data in Same Column
- Placing Result of Calculated Data in Same Column
- Re: Converting from Lotus
- toolbars
- Last name, first name
- Help copying an entire workbook
- Re: Re: Excel ignores "Move selection after Enter" setting in protected
- Re: Information or articles about Excel
- Assigning a value to each unit
- Re: Date Functionality
- Filtering
- XLODBC32.DLL
- Sound in Excel file
- Looking for "Side by Side" Excel Add-in by Jim (James) Cone
- Re: Deliminated Text
- Format a date
- cell formatting problems.
- Excel 2000 Help
- File/Cell Protection
- excel 2000 tutorial
- Printing
- Taskbar
- Re: number of char per cell
- calculating months without edate
- Re: comparing Excel files
- Re: Making A Summary
- Re: HYPERLINK
- VBA/Row number/column numer
- Creating new option button groups - how?
- Excel Data to Word Mailing Labels
- Re: format change in excel 2000
- Re: problems pasting in customized header
- Excel missing from drop-down menu
- Extra blank pages in Excel worksheet
- Re: help with locked file
- Re: Automatic Sorting
- formatting
- Display in linked cell is not identical to source cell.
- how to sum up qty totals for non-duplicate values ?
- Customized Menu Item
- CHANGING TYPE CASE WITHOUT RETYPING
- Negative numbers
- How to change number to text
- Splitting cells / diagonally displaying cell data
- Working with more than 65536 row of Data...
- Re: excel 97 vs excel 2000/2002
- Comments for command button
- problem closing excel
- Randomised Number
- Excel.exe has generated errors.
- Re: representing -ve,0 & +ve values
- formatting dates into weeks
- Duplicate Name List
- Directory Structure starting with the Current Directory ..
- Filter Data using wildcards
- Saving a workbook
- Filter
- Excel takes 10seconds to open
- Re: calculating with displayed values
- calculating with displayed values
- Re: calculating with displayed values
- Using a lookup in a part of another formula
- Excel - Shared Workbook
- Headers and Footers
- Hiding Columns and Rows
- Deleting blank rows
- linked cells
- Moving Average based on criteria
- Re: calculating with displayed values
- using a macro to change code
- Excel word-wrap format
- Re: using a macro to change code
- Re: using a macro to change code
- Web link to Excel file
- ActiveX vs Forms
- Re: excel 97 vs excel 2000/2002
- Automatcally Hiding Rows in Excel 2000
- Conditional Formatting
- Using Date in Filename
- Excel 97
- Re: calculating with displayed values
- Nested IF statements ...
- Gridlines
- Re: Excel sheet - Pop up reminder ??!!
- Importing French Numbers
- Named Ranges
- Scanned Documents
- Print problem
- cut and paste filenames from explorer window
- Re: Active Cell Border
- Re: Looking up data then counting results
- Making cells hidden/not selectable
- Pivot Tables
- Date Format
- paste object from excel into word does not print properl
- importing web logs
- Long Save Times with Linked Workbooks in XP
- Macro
- Can I display blank dimensions in a pivot table?
- Add a blank row
- Simple VBA Deletion of certain rows.
- Using Electronic Signatures
- Importing old data
- how do you remove a macro using VBA?
- Recovering a file that not saved
- Need Help With Entering Current Time
- Merging Cells + Wrapping text = losing wrap after about 200 words
- Large import
- Serial Names of Worksheets
- LINKING WORKSHEETS
- Prevent text from overflowing
- Printing Problem
- Excel Number Formatting
- inserting check-mark in a cell
- Re: highlighting column and row.
- Re: highlighting column and row.
- How do I find and compare specific values?
- Excel 2002 Pivot Table Field List not visible
- Re: calculating with displayed values
- Advanced Sorting
- VBA Cleanup
- Re: Hiding a hyperlink path in Excel 2000 XP
- Excel 2000 run-time error '7':
- Blank Work area with Formula Bar
- Lost formatting when put on the web....
- vLookup formula
- What is Personal.xls
- cut and paste from explorer window into excel
- Updating Inventory
- Query alias
- Data Validation Lists & Ranges
- Default seems to be absolute references?
- Excel to Word
- Appologies for double posting
- Links
- Formatting (General to Number)
- using the range method
- Need help with Excel and database...
- Re: ASCII quote/comma delimited
- question....Can a query retrieve data from a streaming java table?
- Calculate Fluctuation
- converting room scheduling data to grid...
- Re: Fast Way to Convert HyperLink to Text
- Re: Preventing Text Overflow
- disabling the copy and paste
- Entering Data Into Text Boxes and Worksheet Protection
- how to
- Watermark
- Small macro problem
- Formatting change on 2nd copy printed from Excel XP Pro
- "No more new fonts may be applied to this Workbook" message
- Re: Excel 2000 format changes under XP
- return next # in sequence
- Cut and paste from Explorer window into Excel spreadsheet
- Re: Unable to read file
- Cell Reference
- viewing
- Changing the underlying SQL table that a pivottable uses
- Background Text in Excel 2000
- Re: Fill Down
- Re: Fill Down
- Sorting highlighted items.
- How do I launch a .bat or .cmd file from a link in Excel? {EOM}
- Box Plot Help
- Re: Exporting Fixed-Width File
- Re: Using Sum Offset &Count function
- getting word data into excel
- Is there a way to auto save in Excel?
- Re: Selecting non-adjacent cells
- Re: sorting data with combo boxes?
- Auto Recalc
- Re: Pivot Table Drop Down Formatting
- Inverting text
- Re: Excel to Word
- Re: Pivot Table Drop Down Formatting
- IF statements
- Maintain cell references when data is deleted
- Re: Links
- Selecting non-adjacent cells
- Re: Run-time error '53'
- Changing Cutting & Pasting Default?
- Filter by relative criteria
- finding specific day in range
- Hide formula, show result
- Changing default fonts and color for comments that are tied to a cell
- Re: Exporting Fixed-Width File
- Footer path
- Re: Excel cannot find file downloaded with Internet Explorer
- Re: Cut and Paste from Explorer window into Excel spreadsheet
- MAX or MIN from a conditional statement
- Re: Preventing Text Overflow
- Automatic BackUps
- Text over 255 characters won't display
- Re: Fast Way to Convert HyperLink to Text
- Trendlines - 6th order polynomial
- Doing a VLOOKUP from the MIN value in an Array
- Date format problem
- Re: how to save formula
- How to force upper case entries
- excel solver
- accessing grouped cells when sheet is protected
- How to make quick click in sheet to send file as attachment
- sorting algorithms
- Re: Help!
- Euro symbol missing
- Show worksheet name
- Deactivate URL links
- Live URL links in excel
- Help!
- Re: Directory Structure starting with the Current Directory.
- remove object
- Re: Paste Special In Excel
- Bar Chart Column Width?
- Running a macro depending on a cell value
- Selecting non-adjacent cells
- Protecting as part of a macro
- Re: Paste Special In Excel
- concatenate
- Excel Options - Wrap Text OFF!
- print error usb001
- Re: Change the number of charaters in a cell by adding a zero to the beginning
- freezing and splitting
- "Unable to read file" Message
- Is Excel XP Buggier Than Previous Versions?
- Multipule Worksheets
- Self-Deleting Worksheet/UserForm
- Windows shutdown when <tools><options> selected
- Protecting the print area
- Dividing by zero
- To many formulas??
- Selecting 2+ random cells
- Date Formatting
- strikethrough
- Excel, Page Header
- headers disappear
- Re: Merging Cells + Wrapping text = losing wrap after about 200 words
- Why it's impossible to use a format in a function
- File Size
- Re: Filemaker pro
- Date formatting
- excel
- Re: 1 pivot table from 4 sheets
- Unable to open file
- Formula Stays On The Whole Row
- Filter Per Relative Criteria
- web discussion server
- Excel Find Replace in batches
- creatng pdf in Excel
- how to formulate Mth-Year & Year-Mth base on yyyymmdd ?
- Eliminating Hard Returns
- Opening Hyperlinks
- Calculate No. on Months between 2 dates
- Excel URL's
- Excel Toolpane not opening when using IE
- Excel won't open files
- In Excel - Draw Circles, Ovals, Etc. Around a Group of Cells Without Hiding Cell Contents?
- Excel error message
- Re: sending a file to an email recipient
- Re: Won't Lauch xls Files on Dbl Click
- Format field doesn't transfer
- FREQUENCY and COUNTIF
- remove all nonprinting whitespace characters
- Opening .wks Files
- same subject
- Saving as PDF file
- Re: Excel 2002
- Delete duplicate data.
- Re: Pivot Table
- Re: Opening .wks Files
- Re: Excel attachment won't launch in Notes5
- Find/delete text string
- Re: refresh chart with a macro
- Convert data into one WrapText cell
- Change case of text
- Returning a range from a function
- Printing
- Portrait to landscape
- forgot the !#@$ password
- Excel 2000-percentage
- Re: How to stop date conversion?
- External Data Range Properties
- Re: Printing gridlines
- Pivot Table
- Re: Excel Reboots
- Formatting several worksheets at once - Excel 2003
- Protecting certain cells
- Re: Calculation question
- New to the Board, help w/ hyperlinking
- Uninstall Excel 4.0
- Protecting formulas in cells
- Calculation question
- Reverse Print
- rows of data - need to be filtered
- Re: £ symbol types as ? but only in macro scrip?
- Replacing Formula with a Value
- Calculation question
- Re: Spreadsheet hyperlinks
- Re: Paste Special In Excel
- Re: Creating an IF and OR function combined
- Re: Method 'Visible' of object '_Worksheet' failed
- Filling out Excel Form
- Fix text length
- Lookup from a list
- Re: multiple worksheet count
- Can you automate e-mail within macro?
- Reason 31
- how to add 5 numbers dropping the high and low
- read only message
- Re: read-only error message
- How to pull every tenth row of information out of a 5,000-row spreadsheet?
- How do I grab data from every tenth row of a 5,000 row spreadsheet???
- Re: Eliminating Paragraph Marks in EXCEL
- Re: Style Master in Excel 2002
- Inserting Specific Symbols
- Re: Excel Reboots
- How to turn off autoformating?
- Re: How to pull every tenth row of information out of a 5,000-rowspreadsheet?
- Open Excel file in IE without Excel program
- How do I use a Macro to ...
- decimals or fractions
- automated e-mails
- Re: Pivot Table
- Column Headings in Excel
- Error Message In Visul Basic
- Printing gridlines
- unwanted toolbars
- help please
- How to retreive data from previous records
- Re: Feet and inches
- How do you sum only visible cells when you have a filtered list?
- lines and connectors
- print only odd or even page
- Different active cell
- Date Increment [If A Sunday]
- XP and IE and EXCEL
- Hyperlinks
- Make a add-in
- csv-files with '+' in field -> treated as formula
- Save AS
- Keyboard shortcut
- Re: Excel and address book
- Error opening xls file created under XP on off2k machine
- Re: Loop through cells in a column?
- XL97: Application.On time / Protection?
- Closing an Excel file generates a .txt file
- Excel problem turned into Update problem
- Hyperlink question (easy)
- combo boxes
- Pasting into a filtered list
- Last name first
- Pivot Tables - Multiple Consolidation Ranges
- excel-vb interface
- The selected area keep growing!Help!
- Mouse issues with Excel
- Re: Selecting 2 or more non-adjacent cells
- Re: Time Question
- Re: Time Question
- Re: Headers and Footers
- INSERT DATE
- copy and paste a row doesn't get it all
- excel formula
- Re: windows on the task bar
- Can this be done?
- Deleting Records based on criterion
- Cant convert to values
- Re: Absolute cell references
- Re: Date format ... 5&6 characters
- Paste Special, Formulas, is also pasting values. Why?
- Re: Spreadsheet opens twice when opened
- get the active color of a cell
- Re: Loop through cells in a column?
- Excel spreadsheet - wanting to slant 3 column headings
- Highlight Cell if Hyperlink is Lost?
- Printing header row on each page
- Re: If statements based on colours
- Re: Spreadsheet opens twice when opened
- Re: EXCELL
- Re: If statements based on colours
- Array or Lookup?
- Chart with data from multiple worksheets
- Close button
- Closing an excel file causes a .txt file to be generated
- Pasting Cross-workbook 3-D reference formula problems
- Worksheets
- Help
- lookup question
- Callout shadows
- No Prompt when saving
- cppying multiple cells using left cell only
- Excel number formatting
- DAO 3.6 doesn't load all "tables"
- merging cell without losing contents
- Maximum File Size
- Exploding File Size
- Re: Starting a marco by entering a letter into a cell
- Re: Macro Button Colors in Excel 2000
- delete rows
- Re: Macro Button Colors in Excel 2000
- Re: Date format ... 5&6 characters
- Re: Copying Controls
- entering the string CNA in a cell is changed to CAN
- deactiving a group of hyperlinks
- Re: Multiple Instances Opening
- pick from a list
- Column AutoFit
- Re: Check duplicates using VBA
- Template
- Deleting "mail to:" email address links
- Re: deactivate range of hyperlinks
- unique units?
- Worksheet protection
- Re: league table
- User-inserted external file path used to pull cell values
- Re: OR Function (multiple options)
- Re: league table
- Re: Duplicates In Workbook
- Re: Converted 97 link values not coming across?
- Re: Worksheet protection
- Office Update doesn't recognize current Service Pack level
- Order by date
- Excel diagrams in word
- converting from Quattro to Excel
- Template Wizard???
- Excel 2000 Template Wizard
- template
- Add-ins
- Testing
- Re: user name in the excel footer
- Re: column width
- Re: Transferring Excel Macros
- Re: Transferring Excel Macros
- Re: Converting Times
- Hyperlink to Outlook E-Mail note?
- excel and links
- change csv list separator per file?
- Excel
- Duplicates In Workbook
- Re: Read-Only Error Msg - Currupt file (Excel)
- Re: Headings
- converting a worksheet
- Re: Headings
- Help Screens in XL2000
- Re: formatting
- External Data Range Properties
- Object Linking and Embedding error
- Formatting text as numbers
- Re: Receiving Error..
- Excel subtotal
- Re: Loop through cells in a column?
- Re: Absolute cell references
- Re: Excel
- creating dialog boxes
- Copying Data From SQL
- Re: sorting data with a picture
- Re: Slow Excel XP Network File Save
- "Getting Started"
- Re: Copying Controls
- Re: Multiple Instances Opening
- Saving info before cleaning of computer
- Text in cell
- importing data from closed sheet
- Excel 2000
- formula
- quattro 6.0
- Converting from Excel to text w/o quotes (" ")
- Number Automatically divided by 100 and stored in cell
- drtzujrtz
- Re: Floating Macro Button
- printing problem: what I see is not what I get
- Re: Formula/function Not Sure???
- Parameter criteria when updating Pivot Table?
- Re: Cell format to round down
- Moving data to blank column??????
- Auto fill & search in a list
- SourceData range in pivottables
- Re: How to disable Automatic Calculation?
- Re: sorting data with combo boxes?
- Format in if formula
- PivotItems
- Re: Cell format to round down
- Re: Can you view two sheets at the same time?
- Re: Can you view two sheets at the same time?
- Extending worksheet row number
- Re: Cells Showing through from workbook behind
- Tab Key Unexpected Behavior
- Re: derivatives
- How do I tie a web Form to an excel database
- How do I tie a web form to an excel database
- Condition Format #1
- Re: Can you view two sheets at the same time?
- Re: Dates
- Adding Minutes & Seconds expressing time differnce if total is over an hour
- boolean result format TRUE/FALSE or 0/1
- Application Workbook Counter
- Cell Contents in Header/Footer?
- "PERSONAL" workbook
- Finding data on another worksheet in same workbook...?
- Can a single worksheet be emailed without all the header info?
- Automatting hyperlink removal
- Excel Spreadsheet
- Dollar Conversion
- trouble with functions
- Freeze Panes
- How to remove links to other spreadsheets?
- formatting
- Easy way to change names?
- Bullets
- Re: formula
- vlookup for words content when there are duplicate values
- Re: Dollars to text
- Excel on the Web
- Re: Using the Filename in a cell
- Re: Using the Filename in a cell
- Opens in Read-Only
- Help with locating duplicate entries
- excel copy to powerpoint
- formatting a cell
- How to have a formula insert a carriage return as part of a text string
- Re: Cells Showing through from workbook behind
- Copying Data From SQL Into Excel
- Copy Multiple Sheets
- Change the Normal Template
- graphing multiple data points from refreshed cells
- Date Math in Large Column
- Re: Opening .wks Files
- Re: Saving to next in series
- Re: derivatives
- Clipboard error message
- larger name on file
- Re: excel copy to powerpoint
- upc barcode in excel
- Linking formulas to text boxes in VBA
- Re: Trying to use graphics in a field
- Recovering deleted files
- undo button isn't working -- HELP!
- convert from quattro
205
vBulletin v3.0.5, Copyright ©2000-2008, Jelsoft Enterprises Ltd.