View Full Version : Excel Questions
- stationary column
- Default data in form
- how to access data by referring to two different variables
- VBA hacker? How can I protect?
- Nested Do…Loop Statement
- Graphing in Excel
- If FileExists
- Graphing
- Interesting Multiple Coincidences or Pivot Table Problem
- Open on Today's date.
- Make the number go away
- Countif on a different sheet
- [b]Change Data From a Columm format to horizonal format[/b]
- Len/Mid In Macro - I'm stuck :(
- VBA code that will pick up values from different workbooks
- Linking 2 Combobox
- On Control Toolbox Combo Boxes
- Copy adjacent cells and paste to last row on new worksheet.
- timesheet
- Textbox and Combobox
- Eliminate Macro warning (I have no active macros)
- Open .xla with VBA
- If date greater than 30-Jun, go to sheet 2
- keeping links relative in location not absolute
- keeping links relative in location not absolute
- What is the maximum number of worksheets I can have...
- SEARCH VALUE
- Extracting date from text
- Randomize upon openind
- Enabling and disabling macro's
- Using INDIRECT to sum a 3D range
- Formatting only part of text field
- Formatting only part of text field
- How do I password lock a XL workbook...
- Distribution chart
- cell formula help...
- Close Problems
- Radio buttons linked to macros
- CHART - can a bar change to green, yellow, red based on
- execute macro if worksheet is active
- Using text in a cell to refer to worksheet name
- User Defined Array Functions?
- Disappearing Excel
- How do I wrap text in a combo box
- time function
- Formula needed
- Freezing a split screen
- Lookup or Vlookup quandary
- Count Number of Occurrences of a Text String
- auto filter question
- formula error
- negative values
- msoControlButton actions
- Thank You
- Matching data & returning its location in a range
- SUMPRODUCT: Too volatile/Not worth it?
- Stopping Macros
- ChartTitle Object Properties
- Last Business Day
- Countif
- GoTo behavior (F5 key)
- uncollated column Selections
- Protection
- Turning off Read Only warning
- Sum daily data into monthly data using array formulae
- counting formula needed
- Sum daily data into monthly data using array formulae
- Sorting or filtering by cell format(highlight)
- Formula not working when pasting using a macro
- Getting a total based on a rep code
- Can I only copy the visible rows?
- Delete a cell if a condition is met?
- Hyperlink Table of Contents (not a ?)
- drop down lists in a cell
- Insert Meta Refresh tag when publishing as web page
- Formula Bar
- error message DIV/O! causing probelms
- Formulas DISAPPEAR when Edit/Move or Copy 2+ sheets together
- Getting Rid of Decimal Points
- EZ Pivot Table Question
- formatting Vlookups
- List box functions
- Data Tables with Excel??
- If cell containts string of text, return value
- Formatting in Vlookup
- Excel and Internet Forms
- Page Margins
- SUBTOTAL MULTIPLE ROWS
- Displaying contents of a folder
- wierd question about number roundup
- Convert time
- help with a macro PLEASE!
- delete empty rows
- Saving in statusbar
- adding controls to multipages dynamically
- Autofilter - Retain every third line formating after filter
- SumIf Help
- Section 508 Compliance for Spreadsheets
- Excel Lotto Checker
- Formula linking a workbook before the source's creation
- Gifs
- "Enable Macros" Box
- MID VBA?
- How to determine the boundary of a defined name of range
- need to graph an equation in excel 2000
- clear contents special
- User name and password to open excel file
- Vb 6 to excel
- R1C1
- Best non VBA method of returning the last cell in a column
- Restricting Input
- Deviding numbers
- HELP !!! Please . . . .Global change to a column
- Matching List with Labels
- timing a macro
- formula required
- locating links to other data sources
- timesheet2
- Live updating data
- Paste Special
- AVERAGE function variant??
- Trying to do this formula and no luck
- Negative Zero
- VBA for Excel
- Sheet copy from one workbook to another workbook
- Underlined Cell Entries
- A littel help is needed, pleaseeee
- odd numbers
- Require to calculate Work in Progress
- How to overcome limitations on n° row fields in a pivottable
- RETREIVE QUOTES
- Using VBA to Rename Open Workbooks Without Saving Them
- Number of service years
- next empty row formula
- STRAY SPACES - have stray spaces that are messing with COUNT
- showing the nth match without the use of an IF
- creating a running cum % to total
- please help-how can I get excel to recognise a vlookup #N/A?
- Dealing with that equal sign in web query
- ComboBox Question
- Calculation help
- Excel 2000 - Where do I start?
- FORMULA - changing in to read down a row....
- I am Stuck on this
- Time related formula
- Excel 2000 Where do I start?
- subtotaling by day, week and month
- sorting in VBA
- PRINT - printing pages that APPEAR to have nothing on them?
- Code for Next record/Previous record buttons on Userform?
- cut off the first row
- Validation
- Problem
- Add Hyperlink to OLE Textbox
- copy sheet
- Is it possible to make a text box with scroll bars?
- Help with addin displaying #NAME? instead of values
- paste from clipboard
- Lead me in the Right direction
- Very Specific Row Hiding Macro Needed
- Organizing Excel files for efficiency
- Custom Printing Macro
- How do I finf and delete macros from a shared worksheet?
- Need formula to get data
- Formula Help needed
- Automating Data Sort
- IF AND Function
- x & y coordinates
- Getting a value from a MS Access Database
- Why isn't this working? Single argument IF()
- escel databse
- Pivot Table Problem
- Using API calls in VBA to query and write to the registry
- help with this code
- excel97 - excel 2000
- How to print cells from different sheets
- form using a macro !
- Auto Filter.
- How to have the user set a labels caption?
- Automatic self deletion of records older than 6 months
- Statistical formulas not working on worksheet
- cmdPrint_Click Problem
- Names list: create first & last name columns
- disable copy/paste
- Finding Minimum Date
- Editing Cells within a MSFLEXGRID control
- assign STOCK refresh macro to picture
- Convert Case Using VBA
- Background Fill Not Working
- Cell reference for a query filter
- Loging the date when a formular changes
- Track Changes - Out of Memory
- Printing with from page x to page x
- Spreadsheet Size
- Macro Newbie
- Updating one workbook from Separate workbook
- TOC - studied numerous, code to put Index in cell A1 of ever
- Enable Macros On Opening File
- Referencing between worksheets
- Multiple Userforms
- Using a Formula to match a list
- Counting unique entries (3 variable)
- Problem: How to perform conditional COUNT with 2 variables
- Every file in a folder
- 4000 rows, only need a few
- Adding a text character to a cell
- 5 day week
- Getting formatted cell value rather than raw data through VB
- Pivot Table If problem
- Just one more formatting question
- HELP Runtime Error 1004 HELP
- Subtotal summary copy
- Pivot Charts - add another series (line) to a bar graph?
- Copy/Cut and Paste Error
- Number of characters within a cel???
- How to assign a Hyperlink to a Command Button
- help with a do loop
- Excel form on web site has text fields disappear??
- Re:email macro
- Find certain values and create new table using replaced ones
- Chart
- Background cell color - List
- Userform opens, Caps Lock turns on
- Using Ctrl+F within Macro
- Clear Content
- Hopefully simple question about displaying numbers
- parameter value
- Setting Excel to Put a word in from one letter
- Need help with database query
- Line Breaks in cells
- OPEN COMBOBOX AFTER POPULATED
- Solver from VBA. Reference in VDE is ok.
- A formula which compares dates??
- Show block of data when value typed into sheet1, A1
- Strange Result - USing Vlookup
- Weeks and days calculation
- Excel macro referring to Word doc
- VB Copy/Paste into a new file
- Pivot Table %'s
- Function determining what cell it is being called from?
- Conditional Formatting
- Clarification
- Pivottable Not Calculating Totals Correctly - XL97/WinNT
- Macro Question
- Returning the Path of a Shortcut
- Fonts Across Spreadsheets
- Retrieving information from a list
- Printing results of a ComboBox
- TIME Question
- Should be a simple filter
vBulletin® v3.8.7, Copyright ©2000-2012, vBulletin Solutions, Inc.