- count cells with names, but not filled with names or blank
- Delimiters
- YesNo Message Box needed before save.
- Analysis Toolpack
- Entire row delete causes excel to crash
- Smarter data transfer
- Pull macro value from a list
- Drag and dropn in a list box in VBA. PLease help
- ::Anyone Willing To Let Me Pick Their Brain::
- Dynamic Multi Sheets
- Combining text and cell contents to create a Name reference
- vlookups with multiple criteria
- Splitting Character String
- Complicated Transpose (help needed!)
- calculating multiple totals within column
- Auto advance
- List in 2003
- SumByColor Font and Sumif
- Insert a Row and Merge
- Importing Large CSV
- data validation question
- Range Selection Problem
- Change Excel Tables to Pivot Table Lists
- Conditional Lookup Function
- OFFSET & external workbook
- Link to another file to update data
- macro that calculates average
- Vlookup Date Range
- advanced conditional formatting
- .offset and .Goto failing in VBA
- scatterplot with x-axis text, y axis vertical values
- VBA-Find Date on another Workbook using current Active Cell
- printing data validation crcles on a .xls sheet
- drag drop in Tree view control. is that possible in VBA?
- Macro importing/exporting
- Syntax error on connection string w/array element variable
- Cell value
- Auto Backup with Date
- Making Buttons Visible / Invisible
- Partcial Match File Name and Copy Worksheet
- open excel userform from word
- Matching text in 2 lists and copying from a 3rd into a 4th
- show relevant data(using validation)-Tough question
- Macro to create a month calendar with weekends
- Help with VBA code that adds rows and formulas
- data validation
- convert big5 or shift-jis to utf8?
- Can we change "All" to other name in Pivot Table ?
- Excel method to send the active workbook via email
- linked cell property
- Using a userfrom in another workbook
- Sheet loop...sorta..
- Can you point VLOOKUP to a file upon the value of a cell?
- If Statement Formula will not show blank cell if blank.
- Solver results -how to get it in VBA
- How to make excel look like a stand alone...
- Hidden VBA code - how do i unhide it?
- Looping through workbooks
- help please - rows keep dropping out of filtered list
- Using VBA to Paste from Excel to PowerPoint or Word
- Setting Row Heights depending on number of lines in a cell
- Change to range formula
- Last Record for each transaction.
- returning last entry from an incomplete series
- check box
- Way around a circular reference
- Data Tables
- Excel "Sorting"
- How would this formula be entered?
- Display % on userforms and not decimals
- Hyperlink automation copy paste
- whats a good formular on how to make a dta base?
- Using sheet to query import from AS400
- autorun macro
- com add-in, the command button doesn't show up?
- Print contents of listbox in a form
- hii... commandbar problem
- Excel font changes
- Fun with data validation
- Need help with a lookup
- Hi - Percentage question
- sorting/filtering directly in a pivot table..
- SIMPLE QUESTION!!
- Insert new columns between existing Columns.
- Edit Directly in Cell
- Need help with drop down boxes
- Trying to write an If Statement
- Serious decimal weirdness
- greying out excel macros
- How to make a "count function" in the excel applic
- Deleting single entries and leaving double entries
- Opening CSV Files
- ranking
- macro to rename bunch of excel files
- Macro won't run (Run-time error '1004')
- Macro to delete a file prompted for
- Multiples other than decimal
- Problem with hiding Columns
- To Transpose or not to transpose, that is the question
- Name Ranges
- Is there a 'NextMonth' function?
- Sorting data with formulae only
- Difference between two dates
- Macro to select print checkbox
- Copy and Paste
- Excel to Outlook add to distrubution list using VB
- Automatic application of =if(iserror(E,Alternative,E)
- get text fomatting from a referenced cell
- Custom menubar - want to use built-in commands
- MsgBox Reminder
- Compare 2 lists of dates and count instances of earlier date
- Adding Values in excel using without hardcoding the cellID.
- copying names
- stop proceedure if file not found
- Inserting empty cells in a continuous list
- Run-time error '1004'
- "hacking" google calculator
- Data validation based on contents of another cell
- Excel 97
- Inserting missing rows in 2 min time frame and copy data
- User Defined Function for all Workbooks
- delete if equal to
- merging cells from the border
- Excel crashing while in IE Window (When pressing Back)
- Need help with display Currency Format as Text value
- =MIN()...excepts 0's
- A Challange
- Name Fields
- How can I chart a formula
- import data from another sheet w/ macro
- Object Required Problem
- Transfer Range Values that are Drawn From Tables
- Multi variable matrix formula
- Problem with IF statement
- Cannot open corrupted Excel workbook - what is the cause?
- MS Excel Data Base Query using VB Code
- ISNUMBER equal to value
- Conditional Formatting
- A little bit of VB help
- past values and & Formats
- Comparing two dates to determine number of days between
- creating a Word document from Excel
- Special If command
- Filtering of dates
- Help with worksheet reference in formula
- Unbearably easy VBA problem
- Distributions on Subtotals in Pivot Table
- Cell and Row Deletion by Checking for Duplicates
- how to find a partial word in range?
- Userform driving me crazy
- Blanks cells across multiple cells
- Getting Same Cell Info From Multiple Worksheets
- Split screen tabs
- Counting visible rows
- Assistance Needed To Amend Code
- Deleting a cell with duplicate values...
- delete if start with ....
- Remove Spaces in a textbox
- MTD Total minus Yesterday's Sales
- Protecting just cells
- Chart question in Excel 2002
- Search for flename in directory
- can you set a cel to 1st of month based on date in oth cell?
- help w/Macro for message box when someones to print page
- Rolling 12-month average - rows change every month
- Conditional Formatting Question
- activesheet.unprotect not working from VBA
- Count if or CountA????
- Autofill is not working
- How to create and run a basic macro
- Conditional Formatting
- Subscript Out of Range Error
- macro to add specific color shaded cells only
- Delete text, keep number
- Copying lines to sheet in same workbook
- Validation with exceptions
- Grouping Pages in Pivot Table
- what is the single quote at begining of cells?
- Vlookup returning worksheet name
- MEGA Problem Formula
- Count unique entries in an autofiltered column
- Macro - Can you hide the code?
- help with copying rows via VBA
- Data entry & its storage to other book
- Flagging Autofiltered Columns
- Macro on Start-Up
- Compare 2 lists and merge
- Disabling controls on form
- Excel duplicating workbooks
- Sum in comments
- setting a default value in a cell
- Cell Format
- Sum of numbers in specific colored cells
- Sorting a sheet upon a workbook opening
- Cell Conditioning
- If row populated than cell to cell comparison
- copying pivot table under another pivot table with VBA
- weekly sums from day worksheets
- search multiple data in any position
- Table crashes in Excel, but not in HTML
- Help - Hidden Rows (or subrows?)
- Identify duplicate info
- Copy data from master worksheet into corresponding worksheet
- UserForm to be used with multiple sheets
- how can you create a new workbook and name using a macro?
- Problems with SUM function.
- Can you hide VBA code from users?
- Automatic Refresh of ODBC Data
- I need a password to protect to open a sheet in a Workbook
- Exciting problem. Should be easy to solve.
- how can you create a new workbook and name using a macro?
- export object
- likely an easy question... VBA
- Trying to populate an order form
- Datestamp for Data Entry
- Filter without hiding
- password protected document
- Very SIMPLE question AS i'm NEW - Dynamic CELL
- How can I update macros for several workbooks?
- Help with ADO Excel -> Access
- Probably an easy question but...
- Tryin to make a macro to color code times
- create path
- Can I Count dates without repeating?
- How To Make Chart Object Free from Cell References ?
- How do you keep some of the data hidden in a pivot table?
- Using VBA I/O code to Open, amend and save a file
- Vlookup Max Index
- Summing data in multiple worksheets based on code in 1st row
- How can I sort a DYNAMIC RANGE with a MACRO?
- Transfering values from one column to another
- Functions in all workbooks
- Change field setting for all columns in a pivot table
- Transferring data to other sheets
- rotate through text files
- Spread sheet security
- Assigning text to a range....
- changing format for upload to data table
- Need help identifying common data
- match & sort help
- Listing and exporting VBA modules
- Database reporting software similar to nVision (Peoplesoft)
- Copy/import word tables from multiple files into excel
- VBA Backup Code
- VBA Cell Formula
- Excel 2003 behaving strangely
- password protection of workbook
- Number formatting of text boxes
- How can I find the Dbase my Pivot Table is linked to?
- how to fix this code???