View Full Version : Excel Questions
- loop to disable controls
- Automatic optimisation
- Get data from a worksheet based on a variable?
- Unable to set the MinimumScale property of the Axis Class
- Combo Box Question
- Truncating Number
- Name range
- match
- Header Formats
- ActiveX Calendar Control
- Is there a function for this?
- Date Validation
- GIF images
- Randomise lists
- copy and paste fonts
- how to protect or hide your formula
- is there a way
- break up numbers to sort, super tough for me
- Easy one!
- Save in last used directory
- Count cells in one column with multiple criteria
- Use Sum with Array From w/ Multiple Sheets
- index match * match
- How do I quickly find and identify duplicate serial numbers
- re-scaling charts
- Excel 2000 and chart question
- Row Deleting Help Needed
- VBA Branching Based on Hidden Column or Not
- filling data
- sum in a userform
- handling objects (option buttons etc)
- match and align in rows
- Converting Quattro Pro to Excel
- count days in column
- Can you refine the "find"?
- Check Digit Calculation
- labeling buttons
- textbox code
- Insert a two-page Word document into a worksheet
- Can I Color the Worksheet Tabs?
- OK, how do I create the directory?
- move an image dependant upon a key-press
- Date changes
- finding errors
- Single-Keystroke Data Entry
- Pasting Excel data within an email
- Flashing Cells.
- Todays date function in Chart title?
- inserting an animated GIF into forms
- Return the Maximum Value in an Array
- Calendar Control 10.0
- Use VBA to Count Non Blank Cells in a Column
- hide range
- Printing from an excel macro
- Use VBA to Return Maximum Number in a Column
- VBA (Format Times)
- I don't want Workbook_Open to run!
- VBA Code takes very long time to execute
- need to return furthest right value, not formula
- formula bar... grrrrr....
- Active X Control Checkbox
- Automatic Sorting
- vba help
- Skip over debug message in a macro
- Macro to Open certain files
- Running Macro
- distributing spreadsheet, but don't want to allow changes
- Date Based Row Removal
- Formatting Columns
- Vlookup, Hlookup or something else?
- desired range for copy
- desired copy range
- Toolbar restore
- Smart Keys
- Proecting fill/border
- range boxes
- Abbreviation Substitution
- Easy Range Name Question......I think ?
- SaveAs
- STILL NEED HELP ON YTD summing based on date input
- Transposing a table!
- FOR/NEXT
- % Font Red is less then.
- Data Validation With a Twist(s)
- Copying the Conditional Sum Wizard
- relative/absolute reference variance
- Inputbox times five ??
- lookup combined with If?
- How to Prompt to Insert Clip Art
- conditional URL
- Embed month in a cell value, comes from another Date cell
- Checkboxes
- Display last cell containing data
- Movable Toolbars - Nuisance!
- Sort by last 3 figures ??
- Sort by last 3 figures ??
- Toolbar (File) within Spreadsheet
- sum formula reference concerning flexible number of workshee
- Calculating a derivative of a cell w.r.t. another
- vis bas
- Please help
- Modifying Values in an Array
- Windows Media Player Additional Userform Control
- Dynamic Command Bar Buttons
- Count text occurences with multiple conditions
- Macro to Send to outlook with address and subject
- Customising excel built-in objects
- Set ComboBox1 to "" after running a macro
- ActiveWindow.Close
- copy and paste macro
- If function
- Search for an item within an array
- IF Formulas
- Extracting a number from a text string
- Allocation Formulas
- Text to Numbers
- exporting to excel
- Dynamically Setting Read Only property to Excel Workbook
- CHALLENGE
- need help with simple question
- Is This Possible???
- Graphs with PT
- Help with Formula to multiply time by dollars
- Macros problem
- Go to next sheet...
- Desperate for help on grouping/pivot table??
- If statement
- IF OR function
- XL 97 to XL 2000 problem....(SOLVED)
- Passing date value from Excel into Access
- Is there a way around this?
- Help with converting Weekday(cell) to Sun, Mon, etc.
- Copy and paste: faster solution:
- Timer Control
- How to convert 0:30 minutes to the number 30???
- Maintain table entries across multiple sheets
- Macros- Highlight Duplicates
- dividing text, data
- Please Help Create a IF VBA Macro
- macro undo needed
- linking to cell formulas instead of cell values
- Worksheet Function "Match"
- Sorting By Color
- multipage syntax
- How can I create excel worksheets of varying sizes
- Advanced Filter using formulas to achieve criteria... why w
- user forms and graphics
- Copying a FaceID on a userform commandbutton !
- Cell value - open a workbook
- Workbook names in macros
- Combobox/Multiple Column value Problem
- Activate keystrokes when user enters cell
- USING OPTION BUTTON
- listbox multi select(solved)
- Simple Question: Adding Dates
- save and close workbook without the prompts
- Can't get right formula
- Change creation date (property statistics)
- creative formula needed
- calculation with input from textbox
- Can I use 3-D reference range as argument in formulas like C
- Lookup many rows and columns
- Command Button Problem
- Add data in quotation
- Open HTML in Browser
- direct copy
- just formula
- assign macros to button
- asking cells
- Open a limited no of rows and columns?
- is it possible to .....
- Syncronizing sheets from one file to another
- Need help with a Macro
- using variables in multipage object
- Formula, please help
- Excel spreadsheet reference by variable
- Delete some Objects (msoShapeRectangle)
- VLOOKUP TO MULTIPLE SHEETS , IS IT POSSIBLE
- 'SendKeys' activating in the wrong column
- Web Query in Excel 97
- I need a random "quote" generator......
- Creating ListBox
- ordering lists and then sending each categorie to a seperate
- Userform without caption, border, close button (I'm not craz
- Convert Dos File Names
- number format
- Hiding divide by zero errors in worksheet
- Can I use Conditional Formatting for this??
- Filling Excel listbox columns
- Move Right after Enter on selected cells
- database
- Workbook saving twice
- Data validation drop downs not working Why?
- What the???? "Your changes could not be saved....."
- Blank rows
- DSUM
- Coloring Fonts and Cells
- This macro is giving me a headache
- Sizing a Userform - Initialize
- Time intervals
- INDIRECT function across workbooks
- Macros and the "Enter" key
- insert problem
- adding AM and PM values
- determining occurrances in a range of numbers
- Aladin: Subject on Dynamic Ranges
- Data Form
- Print-to-file w/macro
- ASCII file problem
- Nesting
- consolidating 6 woksheets
- Footers
- Anyone help me??
- VLOOKUP and CONCATENATE
- Returning a value in a matrix
- Sort by Fourth & Fifth Digit ??
- SUMIF and Two Criteria
- Continue Lookup for Multiple values
- excel date and time
- xlSheetVisible
- advanced sorting
- Incrementing months in a date field
- Help with a function..
- matching values
- text box scroll bar
- timeline graphs
- Pivot table help needed
- Add sheet/Don't add sheet if cell value=0
- object manipulation..run a macro?
- "Calculate"
- Macro Help! Pop up box on program start
- Double Underscore
- How to Capture Mouse-Over Data from a Series in a Chart
- Calculate elapsed time with milliseconds
- Win 95 Macro won't run in Win 2000
- Column Data to Multiply Column Data
- Column Data to Multiple Column Data
- SORT
- macro help
- macro help
- ListBox Function
- Cant Close Excel
- making sequential dates for calender year
- calculating significance
- me again - woo hoo!
- Changing Save File Warning in VBA
- Web query to pull financial data
- auto insert date and time
- macro critique requested
- AutoFilter and Protection
vBulletin® v3.8.7, Copyright ©2000-2012, vBulletin Solutions, Inc.