View Full Version : Excel Questions
- Trap on Cancel the close command?
- macro question
- Macro and pasting between sheets
- recover unsaved work
- Problems updating a chart
- Unhiding Multiple Sheets
- IF Statements etc.
- Column Data Merging & Unmerging
- Counting a number of text entries where the text is a filter
- Generating a cell reference
- Unique Counting
- Charting Projected vrs Actual
- Date Calculation
- Column Data Merging
- SUMIF statement
- how to make range
- Two different macros on view code
- Multiple IF statements?
- Knowing me, knowing you, choose baby
- edit a cell
- 3D Chart in Excel
- Merging selected data from Excel to Access
- Email link to spreadsheet
- Copying a Range From Active Book(xls) to Addin(xla) ?
- clearing ( fixed it by asking a question, thanks)
- Open file as read only
- Conditional Sum
- Clear date field
- MACRO HELP!!
- Using the Countif Function in multiple worksheets.
- String problem a clearer explanation
- Conditional Formatting with Macros or VBA?
- Cleaning up a database report
- Any one who can resolve it..........
- Creating a Colored popUpmenu items
- Finding the path of a .Ini file
- trouble with dates
- Calculate
- String problem simpler explanation
- Can I associate a flag /tag with an excel workbook?
- export large file into excel
- Conditional Counts
- Remove Duplicate Dates
- drop down navigations
- Auto open, save and close excel sheets
- test
- "drop down box". How to create?
- Counting Cells Containing a Value
- Close file if inactive for 5 minutes
- Counting Cells with a Unique Value
- Colors in cells associated to the "IF" function
- Ad-in? Need some help, please!
- Autofilter/Exceptions - (An easy one - I think) !!!
- Advanced Validation
- Lookup formula
- triming the cells
- Sharing data between Microsoft Access and Excel
- Assign Macro - sure this is simple!!
- Listing properties of files in a directory
- PIVOT TABLES
- Name a range in VBA (should be easy)
- So Close But Now Stuck
- Changing Numbers
- importing worksheets
- Website Quesiton
- Correct formula required
- Converting a number into written text i.e 10 to ten
- Rounding up (again)
- Protecting Excel Workbooks
- Blue background, White text like in MS Word
- Display a picture
- Protection Question
- debugging needed!
- "open in new window" hyperlink
- Empty Printfile printing to Generic/Text Only printer.
- Macro error: NO RETURN() OR HALT() FUNCTION
- Row Colour based upon Multiple Conditions.
- macro to delete a module
- Code to highlight a row
- Formatting Cells Using VBA
- No Code For Buttons
- Formula does not work after cells are merged
- Unique Values
- counter
- Can anyone crack this VBA formula???
- Surname/Firstname Split
- GetObject - CreateObject - I Object
- Move to column A after enter
- Automatic Date Insertion
- cell reference argument in Match function changes when copie
- share work book
- Access forms
- Selecting rows based on criteria.
- Next Empty Row
- Custom Properties in Header
- Activate a macro automatically
- Conditional copying, pasting & deleting
- How to populate records from a 2-tier report
- Simple repeating macro
- Stop Spreadsheet from hiding when clicking on hypertext link
- 2002 Crashing on Replace
- Protect cells with formula
- subtotal in filtered list doesnt work
- Text - find text?
- Type Mismatch?
- O.K. BUTTON
- Nice list of MSKB How To articles
- regression analysis
- Vlookup vs. Index & Match
- Vlookup vs. Index & Match
- Column title for all sheets
- Personal workbooks and Macros in XP
- Excel/Word Related Question
- Another question from me on filtering with VBA.......
- Charting age in years and months
- Can this be done? mail to not go out on a predefined date i
- Align Option Buttons
- can this be done and if so how
- another one from database...
- VBA Password
- IF AND OR FORMULA
- Filter question
- macro to password protect sheet
- writing to a range
- Data Change
- moving selection box
- excel help....Nested IF statement
- Problem with a Conditional Sum
- how do i delete blank rows?
- macro question
- I need a schizophrenic “Days in Stock” formula
- conditional formatting
- How do I delete a VBA Project?
- Find and Move
- excel to acad
- Format Cell
- Userform Zoom
- Formatting after subtotal(s)
- Applying formulas to horizontal data
- Autofiltering for more than 2 items at once
- passing arguments and function results
- Counting filtered results
- Help on Past Tip of the Week - Copying Worksheets in Workboo
- how to find and replace
- Details inside...
- Printing Non-adjacent columns
- If statment
- If statment
- File path in footer
- Can conditional format pattern color shine through on page-b
- Problems with chart not showing correct data
- Run macro on cell change
- PivotTable formatting- from server?
- Normal.xla?
- Removing text from the right
- print listbox contents
- Autofilters
- Clear contents
- Basic info on User forms
- Send a task using Outlook
- A question about searching for data in a 2-d matrix
- How to hide row/column id's?
- Time
- Protect worksheet with formulas and still be able to use con
- F1 Peculiarity
- Question?
- background letters
- Change Positive Value into Negative,I give up!Please help.
- change all cells in a columns format?
- Flashing MsgBox title bar (SOLVED)
- VB-Macro question
- Forgot to clarify Re: Change Positive to Negative
- filter & show filter
- Advice - Suggestions
- Toolbars
- Recording an action
- formula problem
- Excel 97 chart
- index match formula ?
- Help with copying data
- Vlookup
- Error message on running macro "Can't find Project or Libra
- how to know worksheets is already created in a workbook..
- ColorIndex, Linestyle problems
- Checking if Borders have been applied?
- formatting problem
- fullscreen
- find bottom of range with value
- Making a graph from es / no questions
- Moving Average
- Gah Brain Fart
- Formula Problem
- get programs name in VBA
- Create own Formula
- Help with conditional format code
- paste in problem
- user form from EXcel
- RTD implementation
- macro for pivoting
- dumping contents of UserForm into next avail row
- Leading Zeros (THIS TOPIC IS NOW CLOSED OUT)
- grrrrrrr. printing heap of blank pages
- USING & IN SUMIF (OR OTHER FORMULAS) WITH RANGES
- Unhide sheets
- copying sheets between workbooks
- help
- Conditional MessageBox
- Lookup or similar function for data
- Formula for 'aging' Invoice dates (over 30 days,etc)
- Email macro hangs
- Change color of row depending on first row cell entry
- R1C1 Formulas
- Keep log in and out
- Conditional Formatiing
- pivot table totals
- Strange one
- If macro with Msg
- Today's date problem
- Calculate working dates.
- Remembering sequential numbers
- Link problem
- Can i do three
- automatic formatting
- Excel link to Lotus Notes Database
- Calendars in Excel
- Cells highlight when I move mouse
- Problem with Form
- Convert Data List to Values, eliminate link
- using vba or hyperlink to create a new spreadsheet from a te
- Pivot Table Data
- Getting Formatting Cells to work!
- Formula Error
- Copying named ranges to new workbook
- Building a Form
- Open, Copy, Close spreadsheet w/o Dialog boxes
- Open, Copy, Close spreadsheet w/o Dialog boxes
- Open, Copy, Close spreadsheet w/o Dialog boxes
- using Dim function
- Add 10% to a column of numbers
- Sorting cells By color
- between
- Ctrl+Alt+Delete
- Input Box Query
- Error #NAME?
- 1414
- msgbox
- use a cell entry in a macro
- Auto Fill Cells
- Here is my BIG problem!
- Control Arrays with Excel
vBulletin® v3.8.7, Copyright ©2000-2012, vBulletin Solutions, Inc.