View Full Version : Excel Questions
- Run a macro from a formula
- trying to work out the length of the Hypotenuse....
- jimboy....modify your code?
- Control SAS with Excel
- Formatting based on macros
- VBA help
- Auto copy from one cell into another
- Not quite random numbers
- Macro - insert multiple copies of pages based on list
- Tracking Changes-- Quick Question!!
- CHART - can chart columns be built from text?
- Apllying names of ranges in formulas
- Chip Pearson's timer page
- Need to take a different approach
- Excel formatting
- Pivot Table Help
- forecast formula -
- How to search/compare/copy...
- Using Match/Index to compare multiple sheets and update
- pivot table with 2 date columns
- Pivot Table Re-selecting range
- Remove and Replace
- Using name of calling label in function
- Auto Filter Help
- Using outlook check names facility in an excel workbook
- trying to count the number certain months in a list of dates
- how to combine 2 rows with vba
- User Form Question
- Sum a column of decimals, result as integer.
- Change Comment Indicator Color
- color
- AutoFilter issue with dates
- Page Setup
- Working Gauges
- Formatting
- Compare records from Excel with Access
- TableDestination to include variant name
- pasting to a cell
- Moving data from 1 spread sheet to another using a macro
- Buy and sell formula problems
- Concatenate Function
- Search for a file in a folder & all sub-folders
- Dynamic Ranges in Charts using scroll bar!!
- EXCEL GIVE O REACTION
- Did the User change/Save ?
- Chart Problems!
- using macro to create charts on multiple sheets of workbook
- Merged cells/wrap text/row height
- Adding a Border in a Footer of a Spreadsheet
- Need Some help
- refrencing workbook(s) that when open have diff names
- Timing funtion
- calculate row number, for cell address
- Automatically Enter last save date into a cell
- Getting rid of a macro
- Rows to Repeat On Top
- Removing "#NAME?" with VBA
- DSUM multiple columns
- process recordset
- Excel 97 sheet generated through Access97 code not recalcing
- number vs text
- Quickly enter standard information in several blocks
- Unable to set Series Name in a chart
- Help File
- text with a formula in the same cell
- Linking a footer to a cell.
- Combobox does not trigger worksheet change event???
- Need a formula
- Printing with comments
- GMT time conversion to local time.
- Making text eqaul to todays date
- Deleting cell contents...
- Crystal Ball
- Error message on Find function
- Loading blocks of data (see code attached).
- Data Selection Macro
- Extracting the list of cells in a 'Range' to a string
- assign contact info from address book database
- Workbook_Before "Save As" Event?????
- Excel to Word -- Is this possible?
- Macro's and Validation tables
- This Code is Killin' me-reference to other book contains var
- Summary of data
- Force combobox1_change
- PROMPT VB SCRIPT FOR 'YES' 'NO' ANSWER
- Must be simple....string question...
- Matching data in columns
- SAS and Excel
- Converting Time Values to Numbers
- Saving a tab delimited file using VBA
- Writing to a Text File
- User Defined Events !
- copying a range into an e-mail
- Deleting the TIME portion of a DATE/TIME serial number.
- Macro question on cell addresses
- Help Retrieving Ranked Values
- Access problem
- Multiple Data Sources for a single Pivot Table
- Protection & Text Boxes
- Display sheet on msg board
- add in
- Link to a Sheet in Excel from IE
- Array formula?
- If it does not match, don't send
- Macro help please!
- Stock cutting - part 2
- Anyone know how to make a macro select a variable range?
- Function name as string?
- Multiple Countif/Sum if
- Create a backup of my spreadsheet
- autofill
- What is wrong with this VBA?
- PHANTOM MACRO gives strange problem
- Referencing a Range from within VBA code
- Weighted average (offset)
- User form....Help!!!
- VBA formula help named range in formula
- Returning to a web page from a workbook.
- Counting a list depending upon another factor
- time initiated macro
- Checking filename
- help on additem in excel
- jimboy, nice code again....but....
- Hide value on print
- Import a field from access into a comment in excel
- Mocro: Select column until blank rows and copy
- Web query generates name - how can this be avoided?
- reference on merged cell
- Automatically sort cells by date
- Excel Comments boxes - resize themselves!
- Assigning Macros to command buttons
- Unique values in validation lists
- How to use MS Query in Excel to get external data?
- Analysis Toolpak functions in VBA
- Data Validation Input Msg
- copy paste problem
- Control of drop down cell
- Unprotecting range with macro
- IF AND OR STATEMENTS
- sorry...this is about MS Word....
- Need help with relative addressing
- Function for finding first numeric in a text string
- Range specific syntax
- Line break in a Pop-Up Message Box??
- Excel to recognize large number of Hours? in hh:mm:ss
- Do......Loop until
- Call a Worksheet Function into Code
- Difficulty with incrementing time values
- cell selection not allowed
- Extracting information
- Colour highlight weeks
- is this possible?
- Automatically choosing patterns for bar charts
- Percentage Formatting
- Is this possible (and w/ my more than limited knowlede...)?
- Determine the name of currently open workbooks
- Dumb question - Macro not available?
- averages
- CSV wont save numbers as text
- Track Worksheet Changes
- Problems with continuous refreshing on opening
- IE link to a sheet
- Hyperlinking
- Negative Numbers
- Extract Data from Word
- Find and Format Cells
- Formatting question
- Cancelling GetOpenFilename
- getting coordinates of a mouse click on a UserForm?
- VLOOKUP TO COMPARE COLUMNS
- Why rows won't expand to handle additional text.
- AutoFilter and functions...
- On Error and Resume Statements
- Backed myself into another corner, How do I close a file
- dailog box & Automatic Chat
- Help with a Message Box
- Stumped - Column widths changing on protected worksheet
- Stumped - Column widths changing on protected worksheet
- Send data to ActiveSheet
- autofill question
- Adding every even row/odd row
- Stdev function with criteria
- Macro - getting current sheet's name
- Simple User Ford Question
- NZ Function is Excel
- Select sheets using a variable
- Auto Sum
- Opening files with VBA
- "Capture" entry for use in another sheet
- INDEX & MATCH ON 2 COLUMNS OF DATA
- protecting a worksheet
- sorting & combining data
- Formatting Cells in VBA code
- Looking for reversing text
- compile "A" from many sheets to "b-z" of
- Urgent request. Need clarification.
- Multi select list boxes
- IF/AND Statements
- copy and paste macro
- Data Entry with a Userform
- Can't Run a UserForm
- user input box with VBA filters
- need some vb help pls
- Input Message placement
- Multiple/Duplicate Values
- Find dialog box must be closed in order to update cells
- Nested Formula
- How do I use this vba function to pass code?
- How to manage memory in excel!!
- Dynamic Range
- scroll bar maximum limit!!
- simple macro required
- Linking files
- simple macro required
- Calculating with time
- Pivot Table - Refreshing filter to reflect selected range
- Greatest Date
- Trapping A TextBox Enter&Exit Events In A Class Modul
- Next number in a column
- importing text from a .doc
- DELETE CODE
- Highest Dates
- Sort Problem
- Create a PivotTable from a VBA array
- Looking for a value in a range
- Cell Referencing
- Vlookup
- Using If for Multiple Criteria (um, maybe) please help
- Is it possible to input a User's Login into a Cell
- TextBox and CommandButton
- COUNT A FILTERED COLUMN
- Changing Text colour in a cell, in code
- VB6 - Updating an Excel Worksheet
- Another Colour Question
- link problem, please help
- Page Breaks
- Formula Too Long
- Working in VBA - Getting inputed text information to display
- counting occupied cells
- UserForm with ComboBox
- Automatically executing a macro ?
- How to get rid of this error - XL2002
- Convert To Date Cell
- How to calculate present value (PV)? Help!
- UserForms
- Default format for comments
- PROBLEM WITH WORKBOOK RECOVERED FROM DATA-RECOVERY SOFTWARE
- how do I write this formula?
- How to create {1,1,1,1,1,1,1,1,1,1}
- named range in chart and multiple axes
vBulletin® v3.8.7, Copyright ©2000-2012, vBulletin Solutions, Inc.