View Full Version : Excel Questions
- stumped on date formats...going mad!
- Macro madness
- Editing text in cells
- All the fields in the review template are mandatory
- Automatic sorting without macros
- Textboxes on a chart are in different positions on different
- Nearly there.......
- select Unseleced cell
- The opposite of...
- Search/Return a cell value
- Runtime error 9
- tough one lookup
- Re Prints/ Re Quote (Quotation System)
- help for Inputbox which has text in two columns.
- Array Question
- Formulas
- chart ranges
- EXCEL TOOLBAR BUTTON ICON LIST ?
- Assigning Solver Results to Range via Array: How?
- interpolating
- memory problem?
- Excel automation from VB. Preloading workbooks.
- Formatted Concatenating
- Find the nearest matched values?
- vb macro, saving and running external programs
- Basic Template Questions
- Problem with formula
- Changing the date
- Charts not updating
- Error when opening an excel file from diskette
- macros that save
- dao2535.tlb
- Stepping through columns using a macro.
- How do I enable Macros?
- Macros Cell Reference
- Parsing worksheet names for a value?
- #Div 0/! Error
- macros calling macros(not a hard Q)
- Testing if a file has been opened as Read-Only, alerting the
- automatic color coding
- Can't get formula results--just formula
- Running a query with a macro?
- ranges
- Ensuring that only numbers are used
- Visual basic autoformat bug
- Addressing
- Automated hyperlinking - code works, but no hyperlinks show
- Cell Linking Problem!!!!!!!!!
- Merging data from 2 Excel Spreadsheets
- Excel Auto Document Recovery
- Too Many Different Cell Formats???
- How do If ThisCell "" Then statements work?
- Tracking occurrences within sheet
- Excel 97 Formula
- looking up a value from a tabel....help pliz:)\
- mac vs. windows
- Line Chart Grouping
- UserForm w/List or Combo Box that lists worksheets--finally
- If then statement
- Copying Entire Row
- lookup item
- Getting one cell to accumulate amounts typed individually in
- Excel 97 - Remote Update of Row Number in Equations
- Pivot Table Solve Order Problem?
- Excel Formula's that change with the date
- Loop Help
- Excel Formula's that change with the date
- pivot chart from multiple pivot tables
- Detecting a formula result change
- Return Contents of Non Empty Cell
- Column labels - change from numbers back to letters
- creating an email from filling a cell
- using a map to show customers in an excel sheet
- Formula help - cumulative principal/interest
- Run-time error
- UserForm - w/MultiPages & Comboxes??
- Formula
- a macro opens a work book, then closes it......
- skipping blank cells for graphing purpose
- Compare answers macro
- Pictures
- deleting rows
- Combining Text with Formulas
- Conditional Format
- Help with multiple Pivot Tables
- date to number
- inserting rows
- Consolidate
- Method for Highlighting duplicate cells?
- Formulas
- Create an Array, loop through the elements until the end. Ho
- I need to restrict data that is entered into an InputBox
- Centering text within a label, text box, or frame
- ASCII Sort
- How do I dump DIM data within my script?
- Data validation
- Summing the 3 lowest values in a range of cells.
- multiple use of one worksheet
- Protecting Cells
- On Error code in VBA
- 'If' Question
- I NEED HELP
- Personal.xls is locked for editing
- Anybody familiar with F9 Add-In for financial reporting?
- Renaming Page in Pivot Table
- Formats of labels in Data Forms
- select window
- Adding a simple dropdown/scroll bar to a column
- Line Chart
- Saving a range of cells
- Using Small Business Manager(office 2000) w/ Office XP
- Centering text in a MsgBox
- Conditional action on a userform
- Clearing The Clipboard (Visual)
- Excel and Word 97/2000 merging
- marcro help!
- Listbox item alignment.
- Cell Search, gotta be easy
- Data Validation
- Cell Referencing/Spacing
- Histographs and data series
- COMBO BOX - how to get top data to show when it starts up...
- Excel XP GETUSER Function Replacement
- Activex Designer type error message
- Stock Graphs
- Prob an easy one for you (Left lookup)
- Coding help needed
- Number of months
- Filtered List In the rowsource
- IF statement result not displaying in cell
- reporting maximums(further to yesterdays question)
- Stack space
- moving a row to another sheet based on a yes or no
- open workbook and copy sheet
- Run on Cell Change
- An easy one (for a change!)
- function to get active worksheet name
- macro to create a worksheet
- duplicate Personal.xls
- Variables
- Query a column for a particular name, then have a variable a
- Counta
- External Reference using VBA
- Find in VBA
- Spacing in Excel
- To create Summary for a workbook with a big worksheets
- Help with Forms in VB
- Limit number of columns
- In VBA how to determine the named name of a reference.
- Insert field... Username, is there a similar function in Exc
- A couple of easy ones
- Format numbers
- Multiple comboboxes one rowsource
- wait for .bat file to finish before continuing//declaring fu
- Macros always available in my excel
- Traffic Lights
- Need help moving moving multiple worksheets
- insert row ??????????????????????????????????
- Code for Carriage Return to wrap the text
- lookup non ascending
- what does Dim do
- Dating
- can't edit excel database with query wizard
- worksheet event as application event
- SUMPRODUCT function
- Create a chart using arays in VBA
- Code grammer
- More dating - for Dave Hawley
- Textbox maths question
- Select a single cell from a range of cells
- checkbox true/false based on criteria
- cell borders
- Macro Basics
- Protection of a Page in Word
- Sheet Protection Indicator
- concatenation
- Summary worksheets
- Help with forms
- Always Uppercase Text
- randomize statement
- Excel Program registration
- Input from user
- Vlookup with a twist
- Second date
- Gantt Chart
- Hard one ?
- Posting Question w/ Excel Workbook
- Clearing textbox contents
- Excel 2000 and NT4.0
- Date Calculation
- Now I'm really confused...
- Paste link and transpose
- Formula needs improving
- How to Remove VBA Code when copying a workbook
- Excel 97 - opening multiple files in taskbar
-