View Full Version : Excel Questions
- Auto Date Time fill
- deliberate crash or exit w/out save
- Macro worksheet_Change query
- VB...How can time help?
- Compound interest
- Delete text box macro
- Address Formula
- I Need a simple loop...
- VB Save Button (to Desktop)
- Need Help!!!
- renge syntex problem
- relative reference in VBA
- increment question
- NT Security Problems (I think)
- new security
- Shortcut Problem
- Auto-Send, mailto:
- More efficient code
- sheet activate problem
- Calling Megnin - Repost
- faceIds.
- seems simple...is it?
- for next help .*~*. SOLVED .*~*.
- display one record based on value of another
- Safe to delete empty modules?
- macro help needed
- Columns
- number data entry & formatting
- VBA code help.
- prompt required
- is it a lookup
- Contruction of the date
- VBA, selecting range
- Sending Email attaching a Zip file
- Pivot Table and Dynamic Column Headings
- Text box within a chart
- summing up the column in vba
- Names
- Audio
- Difference between Set and without Set
- textbox formating SOLVED
- Import all modules
- Formula to override a conditional format
- Web Query overwriting
- Digital Signature
- Function Category (Easy problem i guess)
- A Function to Sort
- Data>Form element
- i need to know this..
- Excel 2002 - Email Window open
- Check if file exists
- Can I do this?
- moving superscript values with "=" and "&"
- Automatically colouring cells
- Pick from list Macro
- Reference Workbook
- Assiging variables in a loop
- resetting the sheet counter
- Can't print some messages on the board
- Conditional Format
- Inserting new data monthly
- subtotals
- Creating an array
- deleting content from cell
- Adding and Subtracting
- WHY USER DEFINED FUNCTION ACT AS WORKBOOK LINK?
- "Protect" or "password" or "hide" VBA code
- format
- size of column headers ie A, B, C etc and row numbers 1,2,
- compute value automatically
- Moving to a Cell
- Formula Help Required
- Someone do me a non Excel favor? :)
- DBF Files
- How to SUM data from same cell/worksheet of 12 workbooks? (I
- Displaying excel 2000 spreadsheet in web page
- save as window question
- how do i set...
- repetative macro
- Help on this simple formula
- Addition for duplicate entries (different than other posts)
- Macro won't run
- vba solution to sum up the figures after the used range in f
- Class Modules
- SUMPRODUCT- is the prolem
- summing up the column in vba
- This one is just absurd
- Insert [filename] in any cell
- textbox restriction SOLVED THANKS GUYS
- Tweaking pivot table made from OLAP cube
- How do I capture users input and copy it to its appropriate
- progress bar for the macro which doesn't contain loop
- if/then loop failure
- Cell not overwritten in query
- Hyperlink in Powerpoint slide in Excel
- Compare sheets in workbooks
- advanced filter - transpose result question
- Recommended RAM for Excel in Windows 2000
- Web Query command and versions
- Protect a worksheet name
- insert line
- Unprotecting a File
- copying selected worksheets (values only, no formulas) to a
- linked cells in excel worksheets
- entering a formula without typing = first.
- Copy and paste
- lookup functions
- formatting link
- Formula Hiding
- Sumif question
- auto save without prompt
- yes/no field in excel and access ??
- Lookup Function
- Parameter Query for Pivot tables
- To complicated for Me/Please Help
- excel problem, prime numbers
- How to use SUM DISTINCT function in Pivot Table
- slow macro
- Undoing last action
- Changing the Date Format within a macro
- VB - Convert concatenated string alpha characters to numeric
- INDIRECT function... can somebody help me out?
- Named ranges: copying contents to another location
- convert number to text
- Complete another set of input if cell is not equal to zero
- quick vba sort function required please
- Exporting data of worksheet
- Looping through a combobox
- Remove Leading Zero (THIS POST IS NOW CLOSED OUT)
- compare data in multiple rows
- Adding a Range to ListBox on Userform?
- A macro to set print area over a changing range
- invisible hyperlink in "empty" spreadsheet
- REPLACE FUNCTION
- Formulas won't work
- Formulas with no input Params
- macro to open file comma delimited
- Filtering data with vba
- chart size
- Excel 2002 will not load excel 97 file
- cell validation & action
- VLOOKUP - how to return next LARGEST value
- changing axis scale automatically
- Spreadsheet EXAMPLE NEEDED please
- Help needed with file opening macro
- Variable Print Area
- Conditional Formatting ?
- Conditional Formatting ?
- Custom Autofilter Issue
- duplicate
- Converting an ASCII number back into letters?
- "IF" Formula for a Text answer
- Bizarre excel 2000 problem
- copying array into excel through VBA Code
- Dealing with External Workbook Links
- control columns
- Displaying a Chart on UserForm - pesky wait dialog
- Accessing Excel via Web
- Removing unwamted Carriage Returns in Cell
- vlookup
- Preventing automatic re-referencing of cells
- need help with a search and delete Macro
- Custome Help Text
- extracting specific data
- protect macro from being debugged OR prompt for empty floppy
- Column Widths
- VBA Code Problem
- More than 1 web query in a sheet
- linked pivot tables
- input date
- separating first name from last name to make two fields out
- 2 questions for the price of 1
- GRAPHS: MULTIPLE DATA ON SAME GRID
- [Splitting cells] How to separate text / URL?
- Arrays
- return the last value in a column
- Pie Graph
- CHART - build 10 charts from one table and then select the c
- MATCH function
- Cell Layout, Split format possible?
- Overrule Excel command
- Is there a way
- Changed values in Named Range won't calculate
- autocomplete in a textbox using vba
- Deleting Rows & Macros
- splitting a column full of names
- FF-Translator
- Speaking of SUMPRODUCT ...
- Need macro to replace numbers in a column
- Sort By....
- search a table, return a specific row. colo's view attache
- Validation length
- parsing a string field
- How to create a scatter plot
- cut & paste - weird!
- inserting filename into cell as workbook opens
- Hide "#Number!"
- Dye a cell programatically?
- Sheet protection versus changing text color
- Quarterly Debt Amortization
- How would you Auto Propagate an invoice with selected invent
- Range Slow Down
- ScrollBar in Excel97
- Strange control movement behavior
- Specifying a cell to accept imported data
- general question on code ("A1") versus [A1]
- UserForm in VBA
- Macro That Hides Rows
- Macros and Charts
- compute depreciation
- Illegal Operation when closing Excel 2000
- New too VBA development and need some help
- Percentage of Total & Adding Time.
- Email range only
- Program Error on Excel97, not on ExcelXP
- rows to columns
- textfile to variable .*~*. Solved .*~*.
- Validation problem with range on other worksheet
- count model numbers that contain certain letters but not oth
- Need macro to replace numbers with -1
- syntax of multiple "if's"
- custom time format
- Formatting Days
- Need to lock cells after user input.
- Changing Background (find/replace)
- Calculating "set" values
- Count Dates in a Range
- File Open Error
- Help with formula A2:A&"Inventory!C2"
- Include a button in an ordered process on a "form"
- hhmmm, dumb question on locking / disabling form button
- Probably simple--Why won't this work?
- code for opening an existing excel file.
- Macro urgently needed !
- MATCH AND OFFSET FORMULA
- msgbox with multiple lines
- SEARCH DIGITS
- Create a new directory......
- Message boxes!
- getting and showing data
- database application
- HELP: removing extra quotes when saving as text file.
- text box information
- Creating custom menus and Excel.xlb
- Accessing a Cell in another file dynamically.
- User Forms and Auto Reconciliation Problem
- The Lookup function
- Passwording 1000+ files in one go ?
- macro Save As
- if then
vBulletin® v3.8.7, Copyright ©2000-2012, vBulletin Solutions, Inc.