View Full Version : Excel Questions
- With ActiveSheet.QueryTables.Add(Connection:=temp, Destinati
- Combobox auto complete
- Range("history").Value = Worksheets(2).Range("db").Value
- Default value for Data validation
- Open workbook If cell =NOW()
- Worst Error Selection from answer
- Conditional Format
- Why 123.45 - rounddwon(123.45,1) 0.05?
- Conditional Format - 2
- conditional average
- conditional average
- userforms for data entry
- Auto Date
- HELP!
- HELP!
- Crumbs in my Excel
- using functions inside a userform?
- Day Increment Problem
- Date dependant data field
- Possible Split ups for a Single amount
- Howto translate active cell to range ?
- Data Validation??!! Urgent pl. but should be easypeasylemon
- text to columns
- I have get into VB hlp for
- Deleting Rows and formula updates
- Array formula on multi sheets range
- converting calendar days into numerical
- Extremely basic excel question (I believe) and any help woul
- Counting cell with formulas
- print non-contiguous ranges
- Need a way to control printing...
- Grocery list
- using excel formulas in userforms
- Changing Links
- Printing problem
- Formula DataValidation: NO millesimal
- Function Variable Descriptions
- large number of data points, line style won't print as dashe
- Copy Range & Paste Relative to active cell??
- Novice: If - If not - therefore and then some....
- Algebraic Difference (aka: Repeatability)
- Quiz
- Text to Columns in VBA
- E-mail Current Worksheet
- Changing the format of a downloaded cell (Solved)
- Date
- open a file using wildcard
- Rename a module in personal.xls
- Record Keeping
- Windows Messenger
- A twist for "Save As"
- Finding a Sum amongst random numbers
- How do I stop this circular code
- merging EXCEL columns
- Conditional Formating
- userform activation
- HOw to make a Time Log
- Are you really sure
- Unhide a specific column ???
- Excel Query
- Last entry in column
- simple for you, not for me
- records
- Urgent Response
- Inserting column and formula via macro
- Automate file save in excel.
- DUMB QUESTION
- sheets
- IS there a 'super' VALUE function that converts text formula
- Naming workbook without Save AS
- Web query getting multiple pages
- formula dependent upon text
- Freeze Panes = Great Pains
- Range defined thru value of cell
- Expert Needed
- IF (DATA BEGINS WITH....)
- functions
- Lookin' for a DATE
- Scenario Summaries
- Range Name and form
- Input Data thru User Form
- Count of # of days between two days excluding Wk ends?
- VB and Excel...Help, please! ASAP!!
- Tip to organize data into it's original data sequence
- Excel Working Workbooks on the Web?
- VBA call that Excel spell checker [dictionary ]
- List Box - Column Head
- List box - column information
- If function with a macro button
- Test for InputBox 'Cancel'
- How to get sum of Debit & Credit columns in correct cell
- check boxes to change pivot table
- auto filling 40 label captions (VBA)
- advanced filter. destination cell formatting overridden
- nested if statements
- double lookups - do I need array formulas here????
- Need help with If,Or,And formula
- Quick and Simple (I am sure)
- Variable to get values from a relative range
- Exporting
- formatting numbers to nearest 100
- Dialog Box control question
- Import data from a book based on conditions
- Probably a dumb question....But...
- check boxes
- password decryption
- Moving custom toolbars from one computer to another
- VLOOKUP Question
- Moving to next task in VBA
- checking dates down a column
- How can I hide....
- Chart Titles
- VBA
- mark the latest date
- inserting a file name to create a sheet reference
- time zones
- Multi-pane freezing
- Deleting Macros
- link problem
- Grid Lines
- Reminder to save file
- Macro To Stop A Macro
- turn off copy from standart toolbar
- Printing Worksheets
- Second Instance of Same Spreadsheet (.xls:2)
- PAGE PROBLEM!!!!
- Replace the end of a string
- Simple Macro Required
- Hide macros from "Run Macros" dialogue box
- Filtering Macros
- COUNT function
- Array Formula - general question
- File date problem
- Excel XP macros to Excel '97
- Pivotal Tables - Update Source Data with VBA
- Adding items to a combobox on userform
- RE: Resize Table
- Pivot table diagram colour
- Filter in Macro converts date to mm/dd/yy
- how to write this function via a macro?
- Indoor Cricket Stat Sheet
- I read help buttttttttttt.............
- Summarising data
- Data Labelling on charts
- random formating
- clear data button
- Excel Keeps reducing number by a factor of 10
- movement within workseheet via macro
- Too many conditions
- call as acriteria true
- Yet another macro question
- Pivot Tables - Update Source Data with VBA (Help!!!!)
- Descriptive numbers
- referencing a formula
- ongoing summary chart?
- Conditional Format
- Deleting Rows in a macro
- Entering / displaying the Squares of numbers
- Selecting All Rows in another worksheet where a condition is
- Excel 2002
- Excel 2002
- Auto refresh - ODBC queries
- Using a drop down menu in a macro
- Help, with summing and updating overal totals.
- Excel Macro on startup
- Moving Cell Content
- Workbook_Open problem with cmdButton not recognized
- division formula
- Camera Tool in Visual Basic
- Why wouldn't data type LONG work? (SOLVED)
- The file date changes even if the Excel-file is not saved
- Custom Formatting Textboxes
- Carrying a variable from vba to access
- Filling a Sheet with data from a filter.
- COUNTIF with two Variables?
- I don't want to see what the macro is doing
- Combo Box - warning message
- Format as cents
- Pop Up Message upon opening a worksheet
- Activating a closed Excel File from a public server
- Automatic Page Breaks
- Clearing FALSE from many cells
- problem with scale in excel charts
- Any better ideas than below on varying a Sheet Name in a for
- problem with scale in excel charts
- Any better ideas than below on varying a Sheet Name in a for
- countif and averageif?
- wrap text in merged cells in protected document
- using cell values in ActiveCell.Offset()
- Calculating a persons age
- Mulit-select filter?
- When opening workbook, gridlines visible in listboxes (later
- average of "n/a" or number 0
- Conditional Format on '0/0/000
- Conditional Format on '0/0/0000
- Hide Numbers In A Cell
- Reformat personal names in a database
- is a sheet selected?
- Transform Rows into columns
- UserForm Textbox Enabled but Readout Only (user cannot cange
- "And" Formula
- OR programming
- Conditional Format problem
- Delete part of Cell???
- Concatenate Not working please help
- Rows have numbers instead of letters
- VBA - reading data from "names" into an variant
- red
- Updating graphs
- Saveas different in Macro ?
- Combobox on Userform
- Need help understanding this worksheet
- formula for golf result
- Combining five cells into one cell
- macro help needed
- How display series-name on chart?
- Problems with Conversion from .xls to .csv
- excel VB code Private Sub Worksheet_Change help
- How to determine if Internet Explorer is the TopMost window
- How To Copy Range From Pivot Table?
- Add begin/end characters to all values in a column
- Sorting a sheet with other worksheets linked to it...
- Adding a new row and finding the total
- Default VBA InputBox and Check Boxes
- Multiple Reference VLookup????
- Removing Rows in a Range
- Split Cell Content Apart
- Expanded Vlookup?
- How do you format a cell without selecting it?
- Compensation Question
- Only One Line Editable?
- Importing a dynamic .GIF image...
- prevent run from another pc
- problem with array functions
- Problem with export as .csv in excel from an embedded object
- TEXT( )
- Using a macro to open files from a list of file contained in
- Why wasnt row deleted.
- Re-link to newly inserted sheet
- conditional formatting
- Hyperlinking values in a combobox with values on the same sh
- Cant find personal.xls ???
- Allocating payments to invoices
- SOLVED - get network user id.
- Error when using VBA function to unprotect sheet
- VB objects and code for MS Excel 5.0
- Deleting Rows with certain Criteria
- Please, a macro to search a database?
- Comparing Text with result Text from other column
- Comparing Text with result Text from other column
vBulletin® v3.8.7, Copyright ©2000-2012, vBulletin Solutions, Inc.