View Full Version : Excel Questions
- How do I shorten this
- Combination: DataValidation auto appear + show all rows
- First Post! - Want to sort by pushing buttons
- Publishing Excel has a Web Page.
- VB Loop
- Using leading zeros in a formula
- A little complicated
- Tab Indexing Textboxes in a Worksheet
- Need help with a formula -- probably easy for most of you
- Weighted average on status bar
- Save worksheet as read only
- lookup help
- Closing Excel
- Userfrom Textboxs
- I like to add or subtract time with a whole number
- Need Help With Excel 97 Macro Code
- Automatic Time Entry Based on Other Cell
- Problem to actualize a Combo Box
- VBA code Error. Copy range from 1 workbook into another one
- Cell Pattern matching
- Formula for "the contents of the cell in the prior colu
- prevent from debugging
- On screen resolution.
- rounding units of time
- Using pop-up windows to enter values in excel using VB?
- ShowPicD Function - Aspect Ratio
- Simplify Code
- formula help PLEASE!
- viewing all of conditional format formula
- Multiple IF statements as well as ISERROR and ISBLANK help
- If statement for a Month Value
- Deletes Everything, Not Just Selected Cells
- Countif ... date range
- Enable Copy/Paste
- VBA Code Genaric and Indespensible for everyone?
- convert Variant to string
- List Box Features
- Group Sorting
- VBA Function To Run VBCode as Text
- problem with macro
- Column of numbers in Excel file into SAS 'WHEN' clause...
- pausing code until database import complete
- setting the autofull destination range
- Creating table for working week for a month
- I need a code adjustment
- Locking the aspect ratio of an image embedded in a comment
- Hyperlinks
- How to Shorten Excel VBA Code
- How do I add this kind of functionality to a drop down list?
- MATCH function with Dates
- migrating Lotus (Smartsuite) to MS Excel
- Delete rows which has Hyphens in Column A
- Format cell elements when cell contains a formula.
- web service. Any sample code avaiable?
- Getting rid of green arrows
- Sorting dynamically changing data
- Performing calculations and looping w/ VBA
- Sum multiple worksheets by months
- Formula problem
- Disable close (x) button on topright
- =pmt
- last command
- Moving workbooks into one
- Print Question
- how do you make a row stay in place when scrolling down...
- Help With Conditional Formatting
- (xlCellTypeFormulas, 3)->What's the "3" for?
- Text Display
- Price varies with order number, How to Price Total Order?
- Get unique records from set of 7000 and ignore repeated entr
- Extract Data from 1 workbook to multiple workbooks
- A Different Tab Name Question
- form output
- Repeat macro in for all worksheets. Please Help
- ages in excel
- will a VLOOKUP do this?
- VBA code to copy a cell to a range
- How to count # of cells formatted.
- Another DVD collection???
- MSGBOX .... then not allowing changes to sheet
- Problem with hidden sheet
- validation drop downs and sumif
- rotate pictures; magic?
- Double Quotes Removal Query
- Or Operator in VBA
- problems with code syntax [i]HELP[/i] please
- Can you do an IF function across a range?
- urgent help needed with combination chart
- List Box when slect do....
- Force Excel into "FIND" mode
- Anyone ever heard of anything like this?
- Excel linked check box -- Export to a CSV file - How
- If reference would be zero, return last number >0
- Can INDIRECT solve this problem ?
- Naming Cells in a List based on row and column headings
- Create A List Based On Random Values
- very long delay in creating toolbars
- Merge Worksheets from Diff Workbooks
- vlookup within a user defined function
- formula for calculating elapsed time
- VBA For Each Cell
- Manual Cell copying, but I got 60,000!
- Is it possible to pull a sheet name into a cell?
- Target.Offset problem
- Help on how split 16 digit number into 4 groups
- Vlookup
- VBA Deleting rows where col AI has particular value
- Can a range be made to update by itself?
- UserForm Code
- Move modified and unmodifed column values to new column
- automatically change reference in a formula
- automatically change reference in a formula
- VBA Code to select top 10 rows after a filter is applied.
- In AppleWorks, it was called "publish and subscribe.&qu
- Send an email message when a cells value is below zero
- Year ago today
- Default list for wildcard value in validation list
- help with tricky graph
- Lookup AND Match?? from a range of cells?
- Adding data to combo box doesn't work from another sheet!
- help with paste linking
- xlDown selection
- Custom Header with a pop up box
- Custom page size
- Copy protection of an excel sheet
- pop-up message box to enter a string
- error with sql open
- Fuction Large, small problem!!
- Roll over button to show picture
- Alittle guidence if possible!
- Syntax for SUMPRODUCT
- Use a case statement or a loop?
- Formula
- Please help with vb code
- Select Range and name
- using if statements to sort by date
- Locking of sheet in Excel 2000
- Type Mismatch
- Assigning Max() to Cell Value
- using if statements to sort by date
- Autofilter and print output to different worksheet using VBA
- VBA Chart Scale
- Matching parts of text
- Change row color based on value of a cell
- Need Formula
- Protect Rows During AutoFilter
- Searching a cell value from part way down a worksheet
- Calculations with Dates and Times
- Object Browser
- vb code help
- Need some macro help please
- Sheet protection password forgoten
- Language Translation: how to access?
- Need active cell contents to be input to another cell
- Change font color in pivot table
- Can anyone help me with this code?
- Email Macro
- Auto close and save
- Using VBA to Delete All Chart Objects ?
- sum of undefined range and ranges
- Formulas beginning with =+
- Multiple Selections from a List Box
- Coding "before:" and "after:" macro synt
- Counting background color matches
- Separating data into rows?
- Why does THIS formula kill my spreadsheet??
- Keyword search
- Disable CommandBars and OnKey Solved, but what about others?
- I am trying to create a csv file...
- "IF" formula help
- How to command to update screen
- Subtotaling in Excel 2003
- Nested If
- Pivot Table Formatting Problem
- Dialog box
- chart problems
- Referring to Multiple Workbooks
- delete row and my controls get squeezed...
- word wrap in list box?
- Help with spreadsheet please!
- paste autofilter results
- excel macro- If Not equal, then
- excel doesn't refresh
- Automatic Page Break
- Pivot Table Question
- Formula help if possible please
- Please help in modifying this simple logic code...........
- Looking for text value of one cell in another cell
- Formula or Vba event code ?
- Bell curve plots
- Quartiles
- Chart Input ranges
- Can anyone explain overflow errors?
- Importing Text File from User Form Button
- LIST CHECKBOX OBJECTS (embeded) AND VALUES to a file
- I received an excel price list, help creating new column
- date calculation issues
- Complicated and Yet Simple Excel Date Sum required
- Challenging calculation
- replacing #N/A error with 0
- Track Mouse Location In a Sheet VBA
- Count number of unique dates in a row
- I need guidance with code
- IF... ELSE statement
- worksheet event question for today() date insertion
- Hyperlink not working
- get column letter - should be an easy one.
- MsgBox Return
- SUMIF For Months
- Matching cells to other cells
- Excluding list choices from ComboBox
- Userform
- Graphing--Legend Box
- Printing Report with unique numbers
- SUM(IF(AND(OR
- With VBA: How do you place an ADDIN within ADDIN collection?
- if and date function
- Sumproduct Row and column
- cycle through sheets
- Concatenate Function
- How do I clear contents with VB?
- case-sensitive sort
- Conditional Formatting by Date
- Use Y and N to input a numerical value.
- load image for 2 seconds
- Return values from an Array If...
- Extending Text Width of "Category (x) Axis Labels
- Macro to make text into formula
- eliminating values with 0
- Dynamic Name field in Getpivotdata
- SUMIF function using a CONCATENATE function
- Need help on my INDEX formula....
- Update Screen Command...
- working with symbols as values
- I think I need a dynamic array?
- Looking for help on an "IF" function
- On Error Goto not going to the error handler code
- macro help
- splitting date from time
- Conditional Formatting Formula...
- Where can i start?
- Control arrays
- Fill a table of values with help from a userform
- Move modified and unmodifed column values to new column
- Need help modifying code (very minor)
- inputbox select range with sheetname
- More then one match to lookup value???
- can someone please tell me what is wrong with this VBA code?
- Help With SUMPRODUCT anomaly
- Creating Tab delimited with paragraphs
vBulletin® v3.8.7, Copyright ©2000-2012, vBulletin Solutions, Inc.