View Full Version : Excel Questions
- Match function
- search for *word*
- collapse and expand columns
- How to get input from the user
- ARRAY of SUMPRODUCT - trying to use OR in array or sumproduc
- Tab colors
- Using strings in workbooks("") commands in VBA
- how can I filter a series of dates
- How can I modify excel to function as like a form
- Press key in drop-down list to get to the right entry - idea
- A Macro Button Question......
- Need help with excel formula
- Java, Excel and PowerPoint
- cells that change run macro
- Toggle unlinked CheckBox with another checkbox
- copy specific info
- change status bar text
- Take a number, any number.
- De-Bug (THIS POST IS NOW CLOSED OUT)
- Trapping an open file
- Removing a custom bar when sending a mail
- Simple Code Error
- Addends
- Validation and me
- Populating Comboboxs depending upon another combobox selecti
- Producing Graphs to Scale
- Active sheet not re-sizing to maximum
- Running Macro in another app
- Visual Baisc Code for Existing Pivot Table
- How to sum several rows with criteria
- COUNTIF problem (conditional and one condition includes subt
- Empty series - can you set the legend to automatically not d
- ;o(
- Call .dll from VB in Excel
- userform textbox array
- special formatting
- Combo box creation / deletion
- Can a chart contain a dynamic set of series?
- Userforms
- Function to copy to clipboard?
- Memory?
- random numbers in a range
- Listbox display
- Close Application with a macro.
- SUMPRODUCT - how make formual dynamic, if that is right word
- close msgbox automatically?
- How can I uncheck a checkbox?
- End Sub
- Writing to an existing Excel file
- help ! i've run out of ideas for my project !!
- Enable a checkbox
- Run-Time Error 1004
- how do i link a reference to a tab in another workbook to a
- Enable a checkbox in VBA
- Worksheet_Change behaviour - Excel 97 vs 2000/XP
- how do you round to the 9's?
- how do i make a cell change colour on a specified date?
- Changing links in converted Lotus 123 files
- how to pick from a list
- msgbox and range name
- Enable a checkbox in VBA
- I am trying to make a Call Duty List for my work.
- Combo Box Font
- IF AND (Vlookup) combination
- Combo Box Font
- if formula's
- Got my checkbox to click...now what?
- VB to add rounding to formulas
- request to save changes but no changes were made
- excel 2000 -vs- 2002 cell formats
- Multiple ranges to fill
- Unwanted Macros
- Deleting Userforms
- Can Add-in Function use in Application.WorkSheetFunction
- Please help my macro
- Pivot table formulas
- Finding a Row
- Printing Comments
- Adding text after a formula
- Missing Library Error
- References to multiple sheets
- DISPLAY COMMENT ON MY CHARTS
- UP
- Change color
- Remove unsused empty ending rows/columns
- Clear data into box FIND
- sorting "the"
- Calculate difference between two dates
- VBA codes
- problem with some code
- formula
- Combining rows
- Row - inserting macro?
- Repeat entry in Sheet1 for each entry in Sheet2
- Duplicate Values Next to Each Other
- Another Rounding Question
- Excel Help Index dissapeared
- Custom Toolbars (Add / Delete)
- Excel Xl grayed out "Send To" in file open window
- Please help my macro
- various sorting features needed
- establishing codes in a column
- Nonsequential dates on chart axis
- Workbook and Worksheet Security
- Date Stamp in columns
- Putting a message with SendMal
- SUMPRODUCT - not working because sheet name has space and da
- LOCK A CELL ?
- Date and Time when row is used.
- Function
- Max number of sheets
- Msgbox - Have part of message start on a new (next) line
- accounting
- Workbook_change event question
- Password
- Access to Excel Questions
- Cell content is changing the cell format?
- Filtering Combo
- Macro to copy from another workbook
- Linking between points within Different graphs
- vlookUP IN A WEB PAGE
- return cell number when condition is met??
- Calculating number of years
- Copying data from row to column - *HARD QUESTION*
- Cells to display nominated view (another go)
- Selected row as top row
- Returning corresponding table values to another worksheet gi
- Personal macro book and sharing macros
- transpose rows to columns between worksheets
- creating a back button
- List
- random numbers
- looping thru a horizontal list, and presenting it vertically
- Macro Help Needed!
- Excuse me.....list Issue
- bizarre rounding
- Copy Conditional formats only
- Newbie Help: Basic Time Issue
- A bit of help with VB Code Pasting into a "NEW" Sheet and
- Copy pasting formulas
- Error from sumif
- cell reference code
- Summing variable number of rows
- Set up a routing message when a condition is true
- deleting links
- Printing Entire Excel Page (Tab, Formula bar, Tool Bars)
- Custom Help File w/Add-in
- get rid of "enable Macro/ disable Macro"
- Excel as front end- dynamically generated worksheets
- can you make a table read horizontally?, field titles in a c
- Referring To UserForm in Add-In From WorkBook?
- want to automate some work using macro
- assigning decision
- Strange problem while openng a workbook through macro...
- auto enter date
- SPREADSHEET VIEWS
- please repond From: Walsall, England
- Help on error traping
- Can i validate validations?
- Each cell in range
- drag letters..?
- IF's and Text
- I have a problem....
- Clearing Combo Boxes
- Data Selection and Analysis
- joining text cells without loss of value
- Count number of variations
- Creator / Author of File Property Return
- Copy between sheets
- Months and years
- Add & Subtract
- Duplicate entries
- unit conversions
- Rogue Speech marks
- VBA Enter & Return keys ON/OFF
- Compare and return
- Need To Remove the #N/A from the Cell
- Conditional formatting not enough
- Calendar days - i want business days
- Checking for Field Names
- Highest value held in an array
- Monthly Gridlines on Line Chart?
- Close a worksheet using VBA
- adding time
- Converting Military time to MM:SS
- sequential numbering in a column
- Application.DisplayAlerts = False
- #N/A formula
- Maximum value of Row 1 * Row 2, NOT Sumproduct
- Click on a Control Button from a Macro
- automatically alternating background color
- Conditional format
- VBA Cell Formatting
- Worksheet Tabs
- Macro to hide columns
- Formatting cells that have been merged
- Userform causes unslightly window error ?
- Gif File
- Macro to e-mail files using Outlook?
- Can I "pause" my macro while cells recalculate?
- Percentrank Array
- Convert number to time
- Convert number to time
- Refer to a workbook name using a constant?
- Formula Needed
- Floating Text Boxes
- Conditional Format
- Exempting SelectionChange when certain cells are activated.
- Exchanging data between workbooks/workstations
- internet explorer\email
- Can't open wrkbks in separate windows
- combo box type thing
- Removing dashes from a body of text
- Default feautures Tool Find
- Pivot table and external data
- sharing problem
- Getting rid of #N/A
- Worksheet_calculate usage with conditional formatting
- Formula Question
- "sumif" not working
- Macro Question
- Real Challenge. Don't know if possible.
- trim
- Skip or delete blank pages when printing
- Make cell UPPER Case
- InputBox (THIS TOPIC IS NOW CLOSED OUT)
- Cell to always be select
- saving .xlt to .xls
- Right Click Menu Help
- Printer Object Missing
- Suppressing Blank Pages
- Graph
- need help with an "if...then" macro
- Copy rows from sheet to sheet
- Excel not reading David (Hebrew) font
- SUMIF - need to know how to how to use MID in below statemen
- Blank Cells, Zero on chart?
- A programing problem
- Comment Box
- A programing problem
- Storing a variable for use later in a macro
- Activating an open workbook
- Moving to new row automatically
- Keep information in merged cells
- Macro Warning
- Halting data entry
- Stupid question...
- count function
- A very simple question
- text to column
vBulletin® v3.8.7, Copyright ©2000-2012, vBulletin Solutions, Inc.