View Full Version : Excel Questions
- Error handling question
- forms...
- ADDING PAGES TO A SUMMARY PAGE
- Hyperlink Text to Display and Screentips
- Select rows from activecell all the way down VBA
- Opening a word (.doc) document from excel
- Easiest way to sort a pivot table?
- Timing out a Workbook
- Today command
- Help with my list box
- Tab name printouts
- Method 'OpenText' of object 'Workbooks' failed
- How can I substract 2 dates?
- Highlighting destination of Hyperlink
- Don't display zero values on pivot table
- autofill
- Converting Decimal To HexaDecimal In VBA
- Error: fm20.dll and <unknown>
- Sum across worksheets
- Attaching a pic to a post question
- Can't Sync MS Works Spreadsheet To Pocket Excel On IPAQ 3955
- Recursion and composing/decomposing strings
- Reformatting/Repositioning Negative Sign
- print weekdays in a given month
- Using the fill function
- Naming Worksheet Tabs
- Autofill Up
- If/then conditional formatting?
- Formula/Calculatons for insert row
- VBA for Excel Macro to copy groups of rows to a new sheet
- Generate UPC Codes
- print headers from query using ADO and copyfromrecordset
- format cell in xx.xx solved, thanks!
- rounding
- Convert MS Access to Excel
- Advanced Filter - when copy, why sometimes formulas, not val
- Macro to move cell to upper left of worksheet
- excel hangs on some PCs not on others - all on same OS/net
- Running excel macro autiomatically each time a specific exce
- Cells empty...but not???
- Search text string, compare to list, return position
- Method Error
- Print button macro
- Averaging By Initerval and DAY
- Need help on labor sheet.... please...
- How can I set up a Pivot Table range in macros
- Help with a database that has duplicate entries...
- Excel Utility Toolbar
- Validating a cell's contents when a user exits the cell
- replace "," with "." SOLVED, THANKS!!!
- Spread Dollars Across Date Range
- Formula Help
- Error message...???
- programming cells
- Index, Match, or VLOOKUP formula
- Need macro to replace positive numbers with zero in column J
- Macro that can copy
- How to get rid of ....
- Delete ALL text to the left of a particular character
- If includes
- Delete Duplicate
- automatically change author name
- other open workbooks
- Need to paste a formula into a cell
- Need Macro for Autofilter
- Formatting Many textboxes
- More efficient formula?
- Problem with 2/28/03
- vlookup question
- Can someone help with this??
- applying formula to collection of cells
- Setting up DDE channels to Excel - (Excel as DDE server)
- Worksheet code question
- Changing Username
- working with values not formulas???
- checking date in a row..
- Opening Graphs in new windows
- help with this one line
- Spreadsheet control
- (Should be simple) Formula help
- Calculating an average for aggregate data
- Pasting from 1 spreadsheet to another
- Convert percentage into ratio
- Get External Data/Web Query
- Incomplete Calcualation?
- Nested if's?
- Label update automatically?
- Data validation source code....
- Creating a custom graph
- Auto Movement Between Cells
- Automatic File Naming
- Detecting color fill in cell
- New to Combo Boxes
- Sumif with multiple conditions/operators
- convert into day
- convert into day
- Backup sheet1, save and close
- Log User's Details
- Lebel's question...
- Help using HYPERLINK function
- SUMIF using using the LEFT function
- Query not returning numbers...
- default number
- Macro wont do this !
- Save message
- HYPERLINK Q?
- Pivot Table (Hide-Unhide) Problem
- Is it possible to make the content of a cell flashing??
- Cell validation problem
- More Userform woes!!!!
- Help-balloons
- Bar Code Generation in Excel
- Printing all code
- How to print all custom fields?
- Creating Charts
- adding a value from a different sheet
- Early / Late time log
- Regular Reviews
- Splash Screen
- Help with a search macro.. please :/
- MACRO On start up
- Consolidate Sheets
- Strip text characters from mixed data?
- How can I protect some cells?
- MAcro to PDF Distiller as printer
- System date generated in VBA
- Kill executed File
- formula help !!!
- How to select correct data
- How to get smart ranges
- Help - Flashing cell
- I want to learn how to Program, where should i start?
- workbook calculation inactive for some reason....
- A macro to open a new copy of my worksheet
- Progress Bar on Userform
- Tapping into Excel's error object
- How can I assign MACROs to COMMANDBUTTON?
- hide sheets when selecting
- Personal file
- Selecting Page within Multipage Sheet
- Combo boxes
- UserForm
- Password field with *******'s
- Do While Not - Loop
- invoice Numbers
- compute loan balance when loan is interest only
- undoing a macro?
- Formatting VBA variant output
- URGENT PASSWORD PROTECTION
- help with complicated searches
- Want to export CSV data with commas to a text document
- trying to use "sumif" fuction...
- Help with inputing data into a database
- Open Excel as a separate application each time it opens
- OR Function limitations
- NOT Diplaying all (=INDEX,MATCH)
- Optional Arguments
- "Relative Addressing" (?) Macros
- Must you SELECT,COPY,SELECT, PASTESPECIAL to pastespecial?
- making cell value + or - depending on another cell value
- File Open: Auto Enable Macro
- Want to export CSV data with commas to a text document
- copy / paste cells
- Format within PIVOT TABLE
- I hit a wrong button!
- Active Cell question
- RELATIVE COLUMN REFERENCE
- Appending text/Padding
- VLOOKUP
- hyperlink
- Formula problem
- Start a macro before I get to work
- Data Validation & Case
- Borders!
- macro that will lock a cell once data has been entered
- Do Not Save Workbook
- Conditional Formating after 26 Columns
- Excel function/formula that calculates mortgage amortization
- Controls included in the basic Excel-VBA
- What is this feature??
- I am really stuck - userform
- Ok.. this is a little tricky.........
- Protect worksheets from being renamed
- Formula or Code Needed for Summary Totals
- Left Vlookup
- Same range name on different worksheets
- trimming string at certain character
- Picking the last number entered in a column or row.
- Pivot table subtotals
- Divisible by.......
- Data validation formula confusion... Almost there!
- Finding and deleting an unknown Macro
- Question about bar graphs
- Is it possible to celect all cells of a certain fill color?
- I am baffled -- help appreciated
- Pivot Table Help.....Please!!!
- HELP: cannot use wildcards on SUMIF with 2 conditions.
- Interpolation function in Excel?
- Remapping CALC by SunŽ OpenOffice SOLVED
- Hiding Rows, Columns, Scroll Bars etc.
- Headers
- Create array in Excel?
- Word 97
- Converting a Date format to a text format
- Range Find Method with Dates
- comparing 2 workbooks
- Using Text from a specific cell in a msgbox?
- links to other files
- Keeping Text Format in a referenced cell
- compare 2 columns and put text in 3rd column based on the 2
- Slow Delay When Using ActiveSheet.PageSetup.whatever = ....
- Need macro to put phrase in front of alphanumeric string
- Scroll lock for mutiple sheets
- Row Conditional Formatting, Multiple Colors
- cell locks and filters
- Range Selection dificulties when data exceeds screen display
- Macro to go to the last row of data set
- Compare 2 ranges for missing data
- Copy Worksheets (& PG. SETUP) without Copying the Macros
- getting an overflow error msg when running macro
- Conditional sum not working
- linked workbooks
- Using a formula / macro for an unknown range
- Formula only works once
- Conditional Format to Change Values? Maybe a Macro?
- User form
- User form
- Code question..... Thats Got It !!!!
- Function
- conditional averaging
- Importing from Access to excel
- Search cells and return location
- Counting text entries in a filtered range
- F4 repeat key no longer works
- run macro/vb code when a particular cell value changes
- I want a cell to always show in upper case
- Workbook.Openfilename
- selecting the oldest date in a range
- Extracting data with VLOOKUP. How to handle duplicates?
- Toggle situation!!
- Getting path and filename info
- Creating COM add-in for EXCEL
- Macro to find a name
- Using Hyperlinks in Forms
- .Find a year (yyyy) in a column of dates (mm/dd/yyy)
- I need programming help.
- How do I get rid of
- one of them "it sounds simple, but just cant get it&quo
- Please! I'm desparate!
- Don't you want to help an Excel user?
vBulletin® v3.8.7, Copyright ©2000-2012, vBulletin Solutions, Inc.