View Full Version : Excel Questions
- Error 9 when trying to select worksheet
- Bulk rows to delete based upon criteria
- Data Validation - Lists
- Automate cell cut/copy and paste
- multipe sets of radio buttons on one page
- Removing a CommandButton before saving the workbook.
- User form label populate from spreadsheet
- A #VALUE! return?
- Dynamic Named Range Challenge
- How do I get text to auto-fit a text box (not a cell)?
- Want Web Query linked to a specific cell
- error: form already diplayed, can't show modally
- Three Difficult Questions.. (For me at least)
- More than 1 Worksheet Calculate Subroutine???
- Disable Copy and Insert Macros still work ??
- another unwanted zero value
- Going Crazy over Autofill FOrmulas
- centred moving average
- help on find formula
- ROUNDING UP
- UNABLE TO ENTER NUMBERS ON A SHEET
- Copying a list of dates to another spreadsheet
- Email issue
- Fleet management program
- data cleanup from program
- clear form button problem, worksheet_change error interrupt
- Commissions - 5%, 4%, 3%, 2%, 1% of $5M
- Dynamic pivot table help!
- calling a macro based on the the last 4 chars of a string
- Having trouble with IRR formula
- clearing part of a sheet when closing or opening
- Cross in the top right hand corner
- SaveAs prn macro shortens time cells - please help
- Question about dates
- set password to open one of worksheets
- Runtime error 1004 on filesearch
- COUNTIF
- document not saved
- Print file to multiple printers
- linking to an outlook email message in excel cell
- Hide columns based on cell values
- Formula needed to transfer from sheet 1 to sheet 2
- Open Worksheet Query
- from Excel to Power point
- a very basic question
- updating cell values with user inputs (worksheet_change)
- CONNECTING DATA IN DIFFERENT SHEETS
- Graphs
- Solver & Crystal Ball
- cut middle of text?
- Protecting forumlas
- Recognising whole numbers
- help with data manipulation
- Question on Referencing Names - Example Attached
- If...or...then
- Ignore Duplicate Rows
- Find Loop
- Textbox Date Value
- SUBTOTAL
- Use Only Macro Once
- Need to Force user entry...
- Whats wrong with this close_event code
- Code to scan, delete and highlight
- Excel 97
- INDIRECT
- The IF worksheet function
- SQL HELP
- Define and select range, relative to cel, HOWTO?
- eXCEL FUNCTIONS WITHIN FUNCTIONS
- One step convert xls to csv please?
- Count Between
- find/replace within sheet name
- Probability Help - Please
- Issue of Time taken to Calculate!
- Inserting a new row with a formula not a macro
- Form question
- lookup if statement... please help..maybe use of arrays also
- Can cells have a tab index value?
- Fixed Width Cells
- macros hidden but still viewable in XL menu
- View items already added to a Listbox
- copy, pastespecial and transpose with VB, HOWTO?
- Possible for userform to be always on top?
- Specifying chart colors in data
- using ADO without ADO libraries/references activated
- Hiding / Unhiding rows on a protected sheet
- Registration Generator
- formula question
- Update Power Point from Excel
- Hyperlinks
- Best Way to Update Code
- Using ActiveX scrollbar on sheet, HOWTO?
- Deleting multiple columns in a spreadsheet
- Interesting Topic
- graphs
- Changing Named Ranges in Multiple Vlookup Formulas
- Fun with Overlapping Selections
- Need A formula - If value is contained in the defined range
- File Properties
- Subtracting dates in a custom date format & autoupdating
- switch value of cells based on criteria
- excel vs PowerPoint
- extracting the address of a point on a line graph?
- Trying to match cell rows for differences and disp a word
- Adjust Line Space in Text Box
- can I make a sheet wider than 256 cols?
- can I make a sheet wider than 256 cols?
- Complex Logic question - chartfield balancing
- Automate userform
- Countif & Multiple Criteria
- Delete Character from Text String
- Formula dependant on worksheet name
- Copy Excel data to web page
- Option Buttons Cell link
- VBA code problem trying to run multiple subs
- email alert
- Merging data from 2 different sheets
- Data Validation isn't working - where am I going wrong?
- recommendations for connecting to a database
- Help With concatenation / text formulas
- Removing unused names
- Counting cells
- Using find and returning a cell value
- Need Help with formula.
- Macro Help Please
- Comparing sheets
- Data Skipping every other row
- General error ODBC
- Update cell info from row using Vlookup
- SUMIF with multiple conditions
- Splitting date/time
- Function visible only in workbook
- pivot table refresh
- Export data from Excel into Access
- Compare two columns in two worksheets/move to new worksheet
- Splitting info. from 1 column into 2 columns
- Move Pointer To The Right
- Numbers entered in cells are divided by 100
- Conditional Formula
- Inserting rows and relocating cells as needed
- How do I tell VBA to select a range based variable data?
- Help identifying sheet names in another (unopened) workbook
- Another Lookup Question
- Can't Populate Ranges in User Defined Type
- Trouble with countif - maybe it isn't the right solution
- INDIRECT formulas not updating.
- formatting a range of cells
- VBA Function returning multiple variables
- could be simple question, new to excel...
- Cent Sign
- Linked cells
- IsNumber in a userdefined function
- find and psat in the form
- txt to xls
- Using solver to analyze a spreadsheet row by row.
- NEED HELP
- align and sort coulmn b and c
- Unique visits
- Convert to Hours: Minutes
- share macros
- Pbase / Dynamic Range
- Sorting a Date Column
- using VB to change cell colors
- Need code to make page scroll up
- Can someone look at my file and get me started? Send Button
- Combining INDEX and MATCH formula, HOWTO?
- Macro Column Width Help
- How to calculate work hour daily ?
- Excel Interaction with Access
- verify hyperlinks
- Full array to array comparison from a formula?
- Using formulas to calculate league standings
- zipping a excel workbook with a macro
- select range method not working
- If a column contains
- Changing/Editing x-axis labels
- need help please
- Using User-made Spreadsheet as an Application
- Too many variables? Please help.
- Change Excel dates to true dates
- Pivote Tables & Separators - Kinda Complicated
- formula for separating text
- Automation Advice
- Running total stopping @ a $$ threshold
- .
- coverting numbers into %
- Make VLOOKUP read the next highest
- difficulty with sum function and decimals
- Combo Box is moving without my permission
- Make copy of one sheet and update formulas on another sheet
- Newbie macro question
- Newbie macro question
- copy to paste special code
- Trying to copy a Form from one workbook to another
- VBA code Copy and Paste on open
- [b]Compile error: Out of memory[/b]
- 2 condtions
- Excel to Text is adding a "
- Maybe a simple question, but I'm stuck
- Cell Change
- how to increment a date by 2 and 1 months depending on month
- Auto populate a cell if another cell contains data?
- Rank from a (not-so) random time (hh:mm:ss) list
- Envelope Mailing Address
- Another sorting method?
- Conditional Ranking
- Spreadsheet control in userform
- Limiting Text boxes in a form
- Help with "dim"
- reading a file name from a worksheet into a macro
- Quick way to remove blank space before text?
- Formula(s) required to calculate sheet with many variables
- Excel Macro: Problem With Evaluate
- Data Validation Question
- Not sure of the technical name for what I want to do!
- frustrated over zero values ARGGGGGG!
- a way to delete all text string between parentheses?
- Paste Special Excel graphs issues
- Completely Baffled by Excel Database
- Look up interpolated value in a table.
- Rank Formula
- Selecting column by popup screen
- Forms using VB in Excel HELP!!!!!
- Excel Expectations
- Change formulae from Relative to Absolute Reference
- ?Worksheet opening problems between 97 and 2000
- SUM with multiple conditions and Summing multiple colums
- Multi IF function
- Formulas - vlookup
- Prevent copying over Validations
- technique to hide part of sheet, HOWTO?
- Help with checking worksheet protection in VBA
- Calculate percentage of Y's
- Simplify array formula
- sumif help please
- Need help....
- Date Calculation query
- Button to fit cell size exactly
- Custom Number Format
- display time in secs
- page setup - print to one page
- Cutting a section of region
- Easy Formula Solution?
- Mail merge to Word
- looping through option button control
- auto email on opening workbook
- Add-In ( Close WorkBook without save ) ??
- loading auto_open when loading third party
- Can excel search multiple sheets to return a value?
- Lookup based on a logical function
vBulletin® v3.8.7, Copyright ©2000-2012, vBulletin Solutions, Inc.