Windows Secrets
Windows Secrets Lounge
Textbox (Office XP)
worksheet unprotect (office2002 widowsxp)
Create Library (Office XP)
Export to Template,Print and Email (Office XP)
Change color (Office XP
Extract from list and count (Excel 2003)
Formula Evaluator (2000)
Autofilter, custom filter (Win XP Excel 2003)
Six of the best (Excel 2000 SP3)
Userform cell referenceing (Windows XP: Office 200
Change Format (Excel XL)
sprintf? (Excel VBA v6.3)
Deselect comment text box (2003)
Macro (Excel 2000)
Consolidating ... (WinNT4, XL97)
Post 489383 (Excel XP)
Put date in cell! (WinNT4, XL97)
Clicked cell is in 'this range' ... (WinNT4, XL97)
Uppercase text (2003)
pick values of graph that meet condition (excel)
Worksheet Names (97 SR2)
Circular reference? (Excel 2000)
Count Formula (2002)
Page Breaking Macro (2000)
Great Hans a question on your old code... (2000 sr 1)
Formula Problem (Excel 2002)
Beginner (2002)
Cumulative values in Pivot Table (2003)
Recalculation not working (2003)
Missing links (Excel 2000)
Grouping radio buttons on a worksheet (2003)
TaskBar Icons (Excel XP)
Excel VBA (Excel 2003)
sure the process finished... (2000 sr 1)
Scenario vs Goal Seek (2003)
Link to a value in a text string (2000)
File in use error (Excel 2003)
finding merged cells (2003)
if existis value stop macro.... (2000 sr 1)
New article: Defined Names In Excel (97, 2000,xp,2003)
Sheet Tab Name (Excel 2003)
SUMIF Date Range (2003)
Print code of only 1 module (Excel 2003 SP1)
accccc .......format number (2000 sr 1)
Adjust roll height to 'At Least' a certain size (Excel 97)
Save Single Worsheet Macro (Excel 2002)
Changing Cell Color with Formula (2000)
Page Break Preview Borders (Excel 2003)
vba excel query (any)
Vlookup.... (2000 sr 1)
Date/Time Calc (2003)
unzip file .... (2000 sr 1)
Seemingly simple question about protecting files (Excel 2000)
UserForm (2002)
Excel converted from Lotus issues (Excel 2002 SP3)
code execution error (excel)
no minimise, maximise buttons (2000)
Excel and Powerpoint (2003)
Create Forms (Office XP)
tiling the screen (2003)
Can't disable the gridlines (Excel 2002)
Download program's forms does not appear and run (Excel 2000)
Conditional Sum (Excel 2000-2004)
Excel VBA (Excel XP)
Auto Insert and Column delete (Office XP )
SeriesCollection fail (Excel 2000)
Auto Insert and Excel Addins (Office XP)
Validating last cell in varying length columns (Excel 2K, Win 2K)
Category reversing for stacked chart (2003)
COUNTIF (EXCEL2000)
converting number to time (excel)
expanding worksheet size (excel 2000)
Custom Toolbar(s) (2000+)
VBA FOR EXCEL (XP)
get rid of #DIV/0! (excel xp)
Auto Filter (any)
Rename tab to specific cell value (Excel 2003 SP1)
Online help connects to Web (Excel 2003 SP1)
Setting printer to duplex (2000/SR2)
STATISTICAL GRAPHING (EXCEL XP)
Multi vlookup on 3 sheets (2000 sr 1)
Adding Boarders to a Print Area (2003)
Reset to Default Printer (2000/SR2)
Toolbar problem in VBE (Excel 2000)
Pivot Tables Not Refreshing (2003)
Dynamically createing text boxes in Userforms (Excel 2000)
Count Distinct (XP)
Comparing cell data (2003)
formula help (2003 SP1)
List Worksheet names (2000)
Date Formats (2002/2003)
copy cut and move folder (excel)
Microsoft Query (Office XP SP3)
un-hiding modules (Office 2003)
Macro needed for new sheet (2002+)
Rounding down (2003)
Add to IF formula (Excel 2002)
Defining a Chart Object in Class Module (Excel 2003)
Search (XL)
Open Workbook as Read-Only using VBA (Excel 2000>)
Top 3 Formula Help (Excel 97)
Add Tab Name to Cell(s) (2000 sp3)
Rolling copy? (2003)
ASAP Utilities Update (97+)
CAN NOT FIND FILE (Excel 2000)
Select All (Control - A) in Excel (Excel 2003 SP1)
Using AutoCad data (2003)
Set Scroll Area Problem (Excel 2002)
Strange Arabic(?) format (2002)
excel: some conditions (office xp)
spread sheet values show up on a monthly calendar (office 2003)
Display Auto filter list (Office 2000)
Comment error (Excel 2000)
CELL DATA IN TABLE (EXCEL XP)
Using a Tablet PC (Excel 2003)
sorting (2003)
Managing external links (2000 / XP)
Pivot Table Format (Excel 2003)
Hide Row Macro (Excel 2003)
Column headings (2003)
sum: sum only profit/loss (office xp)
Excel Tabs (Office 2003)
Change worksheet by timer (Excel 2002/3)
Force data enrty before close (2003)
Time Tracking Spreadsheet (2003)
Formula help (2003)
add 2002-2004 to bar chart (xls)
Insert cell fouls formula (2003 (11.56.12.5606))
Folder Files (XP)
Sheet tab names (any version)
Cell References (2003)
Hyperlinks (Office 2003)
switching through workbooks when extracting cells (xcel 00)
Accessing VB variables in another workbook (2003, SP1)
Full File path (2003)
Permanently scrap a dialog box with a check-box! (Excel 2000 >)
date/Time Nulls (97-->)
Refer to Sheet Tab Name (2003)
Autofit Filtered Data (Excel 2000 >)
IF statement for non-zero data (Excel 2003)
Assigning macros (Excel XP)
dates (2003)
Saving to DVD (Excel2003)
Print text on page 2 when columns are repeated (2002 SP3)
AutoSum (2000)
Hide Queries (Excel 2002)
macro automation error and paste value (excel)
data labels truncated (Excel 2003 SP1)
Custom Icon Pics (Excel 2002)
Function to inverse negative values! (Excel 2000 >)
Microsoft Excel Printing problem (XP)
shared workbook irritation (xl2ksr1)
auto complete (Excel XP-SP2)
conditional format with vlookup (xp)
Print what I see! (XL 2000)
Need help with a formula (Excel 2000)
BUTTON IMAGE (EXCEL 2000)
Extract Data from Closed workbook (Excel 2000)
Widen (#####) columns with code (Excel 2000 >)
Files not locked when in use (Office 2002 SP3)
Struggling with parenthasis (Excel 2002)
User Select Question (Excel 2002)
Workbook held in XPStart (Office 2003)
Automatically Adjust Row Height (2000)
Conditional Selection (Excel 2000 >)
format excel column (ExcelXP)
Dynamic Print Range (2003)
Pasting values only from mulitple worksheets (2000)
Browser Display Problem (2003 SP1)
Identify first worksheet in workbook (Excel 2003)
Insert Row & Copy Formula (Excel 97)
Comment - Textbox value (Excel 2000)
Days in Month Function (Excel 2000>)
Open multiple files with GetOpenFileName (Excel2000>)
Another ISERROR ? (Excel 2002)
Data Type Function (Excel 2000)
Styles and Emailing WBooks (Excel 2000 >)
Macro storage location (Excel 2003)
Quietly close Application.Inputbox (Excel 2000>)
vLookup in VBA (2003 SP1)
count records in filtered list (xl2k)
Conditional Formatting? (ExcelXP)
formula: look and choose (office xp)
calculate area inside shape (Excel 2003)
Distributing Linked Files (2000 and up)
green triangle (2002-2003)
Handling events for many controls (97, 2000,xp,2003)
Conditional Sum (Excel 2002)
ISERROR Problem (Excel 2002)
macro reqd (Excel 2000)
formula help (Office XP)
Calling a Sub with OnKey and sending an array (Excel 2003)
Compare list to Column (2000 sp3)
Bracket (2002)
Formula Help (Excel 97)
Multi sheet Import Code (2000 sp3)
VBA Advanced filter (Excel XP)
modify and explain (2000 sr 1)
Upgrade 97 to XP Problem (Office XP)
error trapping (2003)
Change Case to Mixed (Excel 2003)
Sum with Criteria (2K3)
VBA DAte formats (Xl 2003)
Weird XL startup problem (WinNT4, XL97)
CountIf with two criteria doesn't count (97/XP)
If / Then Formula (Excel 97)
Autofilter Limitations (2000)
finding and copy info (xp)
Text Editing (2002)
Moving between worksheets (Excel 2000)
Paste into Empty Row (Excel 2003)
ClearSeeminglyEmpty Revisited (Excel XP-SP3)
isblank (2003)
If Criteria (2000)
Change default file name? (Office XP)
Sumproduct with multiple criteria (2003)
Random Num - Lookup query (Excel 2003)
Generate Gross Sales Value (Excel 2002)
Solver Runs from Code, but not from UI (XL2003)
IF(ISERROR (Excel 2003)
Macro to run on closure (2002)
IF ISBLANK formula (Excel 2003)
No more automatic reference formatting? (excel 2002)
Inserting Certain Operations (2000)
ComboBox Data Text (XP; SR3)
Don't print the shading in the cell (XP)
Langton's Ant (97-->)
Conditional Formats (XL2003)
fill Series (2000)
Sumif (2000)
Linking to DLL's through Excel (Excel 2000)
Average (2000)
chart updates (2000)
Document Not Saved (2000)
Hiding the Visual Basic Editor (Excel 2003)
Excel Interacting With Access (XP; SP3)
Reversible Sorting (2003 Sp1)
Patterns (2003 SP1)
sort data to follow a condition? (excel)
Reformatted Hard Drive (2000)
Save Range as Webpage (2003 SP1)
Code for Change Case (Excel 2000)
wildcards? (excel)
Networkdays not working (2000)
Use cell value as sheet name (2003)
Find (XP)
Dates Being Entered as 06/27 have equal sign added (Excel 2000)
TOOL TIP (Excel 2000)
Use cell value as filename (2003)
import from web (2000 rs 1)
Limit on text in cell (2002)
Fiscal year function (Excel2003)
Dynamic Print Area (2003 SP1)
Duplex printing multiple tabs (Excel 2003)
Formula but if no vaslue print a 0 (excel)
Printer Settings (Excel 2000 SP3)
Concatenation (2003)
Sumif Criteria (2003)
Shift All Characters in a cell to capitals (Xel)
Add data labels to XY scatter chart (XP/SP3)
move data into row format (excel)
Loading/Unloading COM addins from code (Excel 2000/SR1)
Trigger Code By Cell Input (XP: SP3)
Can't find PT formula menu (Excel2003)
<> (2003)
Active Cell Color Code (Excel 2000)
EOMonth Calculation (XP;SP3)
VBA error opening Excel (Excel 2003)
Forcing a TAB after entry of one character (XL 2K >)
Colored fonts in footnotes (2002)
Excel Pivot Table using Acess table as data source (2000)
controll blank cells (2000 sr 1)
Mail merge within MS Excel 2000 (9.0.6926 SP-3)
Access Calendar (Excel 2000)
VLookup or any Working Formula (Excel 2000)
Unable to load cached records Pivot Table (Excel 2000 or 2003)
Save As shortcuts (Office 2002 SP3)
Changing default behaviour of 'Edit|Find' (2003 SP1)
ISERROR ?? (Excel 2002)
Range specification (2003)
sumif a particular format is present (2000)
Add total mfor each index changement.... (2000 sr 1)
Custom footer (Excel 2000 SR-1)
Lists and Pivots (Excel 2003)
Adding Times (Office 2000)
Selecting Duplicates and Inverting the Selection! (Excel 2000 >)
Replicate name if... (2000 sr 1)
Sort numbers across multiple columns! (Excel 2000>)
Make Initials from Name Column (Excel 2000 >)
List Active Hyperlinks in a Directory! (Excel2000>)
Create list of Find Values (Excel 2000>)
Concatenate v & (Excel 2003)
reverse cell order lowest to high (excel)
Finding a users Program Files (2000)
Dynamic Ranges /Sorting (XL2003)
BUTTONS (2002)
DAO Error with dynamic range (2000 sp-3/ 98SE)
Sorting algorithms (2002)
Bar-line chart with two lines (Excel 2002)
Counting the number of days in a range of dates (2000/2003)
Help with Find formula (Excel 97 SR2)
Count if (97-->)
how to extract data from different workbooks (excel)
formulas on 'related' sheets (2002)
find (xp)
Textbox value inputting into wrong cell (Excel 2000)
pick less then value (excel)
Setup default custom footer for existing workbooks (XP / 2003)
Pivot table from external data source (2003)
Auto Update Graph (Excel 2002)
Protecting Master Worksheet (2000 and 2003)
moving info (xp)
AutoFill without Dragging (Excel 97)
Free Excel 2003 Quick Reference Guide (2003)
Y values in XY Scatter Chart? (2000/sp3)
Special Sum formula needed (Excel 2003)
Change Default Chart Colours (XP 2003)
Page field in pivot table (2003)
PRINT AS WORD DOC (Excel 2000)
SET OBJECT (Excel 2000)
Autofilter by cell format (97-->)
More than vlookup... (Excel 2003)
How to insert tabs into a cell (2002, XP Pro)
pull cell data from a import text file (excel)
adding automatic Formula if condition is true (excel)
Proliferation of msforms.exd (Office 2002 SP3)
How do I find the cell address of the 2nd largest
highlight a line with a interval (excel)
SUMIF With RangeNames (XP; SR3)
Pivot Table Zero Values (XP; SR3)
Variable Disappears (XP; SR3)
Event problems with Multipage (Excel 2000 sp3)
Importing Union Query from Access (2003)
Formatting Column Widths (Office 03/win2k)
Average Last # Entries (2000)
How Many Months (Excel 2002)
Replacing text in a cell with more than 1024 chara (97, 2000,xp,2003)
concatenate with format (2000 sr 1)
Net Present Value Calculation (2002)
selecting a multi range of columns and rows (excel)
3D formula (2003)
Can VBA read a chart? (Excel 97 SR2)
Listbox Multiselect (Excel 2000)
cell to return value in last cell in a column (2003)
button for macros (excel)
Macros (Excel)
Goal seek displays 2 results! (Excel 2002)
Creating a clock using pie charts (Any)
link data sheet to data sheet (Office 2000/2003)
Excel Average Formula Needed (Excel 2002)
Help with macro (Excel 2003)
Security (Excel 2000)
Progamatically add text to custom button (2k with windows 2k)
CONSISTENT COVERSION OF A CELL (EXCEL)
Survey Results Formulas (Excel 97)
Filename/Path Suppression (XP; SP3)
Validate for blank? (Excel 2000 >)
Object Error (Excel 2000)
Auto create with similar names! (Excel 2000>)
Sumif multi-conditions in same column (Excel 2000>)
Crazy file size behaviour (XP)
Sort based upon cell color (2000 sp3)
file size explosion (2k with 2k)
Macros assigned to toolbar buttons (2k with windows 2k)
Refresh all pivot tables at once macro (Excel 2003/2000)
average compond interest calculation (2000 SP3)
web query (xp)
daily to semi-monthly (2002 xp)
Convert text to rows (Office 2000/2003)
Expand RowHeight for merged cells (Excel 2002)
Combined point & bar chart (Excel 2000)
Data Validation Format (Excel 2002)
SUMIF (XP)
Format Cell, Special (2002)
VLOOKUP (2003)
Excel Search & Copy Macro (XLS2k SP3)
Last day of Month (2002)
Code Doesn't Find Blanks (Excel XP-SP3)
Size of Combo Box (Excel 2003)
Square Grid (any)
Chart color coding (2003)
Parent Directory (2000)
Find and delete duplicates (2003)
Copy files to fold if value is true (excel)
Chart Axis Custom Format (XL 97)
Generate report from lookup table (Excel XP)
Cell References (2002)
Conditional Format ? (Excel 2002)
Range refers to wrong worksheet (2000 sr 1)
Delete names - update references (2000)
count a last cell (2000 sr 1)
value not found in VlookUp (2000 sr 1)
Long macro run-time (Excel 2000)
Convert number to month (2003 SP1)
Add Character to Cell (2000 sp3)
SUMIF Help (Excel 2000)
Protection and the ability to Tab (Excel XP, SP1)
Document Properties (XP; SP3)
skip worksheet on looping (excel)
Indirect Formula (Excel XP)
Delete rows (Excel 2000)
error handler (excel 2000)
Can't Import Excel File (2002) (481009) was moved to the Access board
sheet control (2002)
Covert hours to days (XP)
Prevent Format changes between Appl's. (Excel 2002)
Format NOW (2000 sr 1)
Userform connected dropdowns (WinNT/XL97)
Assistance with Formulate Macro (Excel 2002)
Find a Percenage (Excel 2002)
Formula / Macro (2000)
Application wont release (Excel 2k Sr1)
Showing a picture from a list of pictures (97, 2000,xp,2003)
add unhide worksheets to workbook (excel)
Transpose column (2000)
Copy, sort, with hidden rows (XP)
Count if date (Excel 97-->)
Select case help (Excel 2000)
Write in a txt in a specify position (2000 sr 1)
Specify range within current region (WinNT/XL97)
charts upon Pivot Tables (Excel 2002)
Email from within Excel (Excel 2002 SP3)
#Div/0! (Excel 2003)
getpivotdata function (Excel 2002/XP)
Worksheet change (Excel 2000)
Stop Rand() Recalc on F9 (Excel 2000)
Pivot Tbles (2000)
form isn't unloading (Excel 2000)
syntax pls (97+)
Add-in Functions Scope! (Excel 2002)
Open PPT Show with Excel VBA (Excel 2002)
Extract by date (2003)
use macro in another worksheet (Excel 2000)
Begining of month formula (Excel 2003)
Sorting Validation dropdown lists (XP)
Vlookup using =Max() (Excel 2003)
Returning sheet names (2000 sp-3/ 98SE)
Showing more than one document open (97)
Message box entry and cells with a formula (Excel XP)
Totaling a Column of X's (Excel 2000)
Setting Relative Reference to Access (Excel 2K, Win2K Pro)
ShowModal (Excel 2000)
Find a line in import and copy in other sheet.. (2000 sr 1)
A stats question (Any)
Sort in memory (Excel 2000)
Very difficult to replece a value... (2000 sr 1)
Extract Text (XP)
summing by date (Excel 2003)
Why not summ? (2000 sr 1)
Graphing Time Series (2000)
Eliminate Zeros (XL XP)
Paste Vertical Columns to Horizontal Rows (Excel 2003)
Inventory system (2002)
Sorting boy/girl (Excel 2002 SP3)
paste into 'save as' dialog box (2000 / 2003)
AVERAGE(IF Formula (Excel 2000)
Automatic printing question (Excel XP)
Make a date! (Excel 2002)
Return function to range (Excel 2000)
Additional IF statement for formula in use (Excel 2000)
Input Box (MS Excel 2000)
SumIf with multiple criteria (XP)
colors of quarters (2003)
Why 2 clicks to run macro (2000)
Vlookup or match (Excel 2000)
Counting Unique Items in Range (Excel 2003)
Restore standard toolbar (Excel 2000)
Open Dialog Box (2003)
Cells context menu (VBA) (2000 sp-3/ 98SE)
fill in some column according to the information i (excel 2000)
Reading & Writing Cell Values (2003)
Combined IF and OR (Excel 2000-2004)
Class Module help (Excel 2000)
pivot data copy data (Excel 2000)
Delete Names Excel 97 (Excel 97)
PrintArea Problems (Excel 2000)
Who is the best instruction? (2000 sr 1)
Row increment (VBA) (2003)
Help with NPV (Excel 2002)
Round to 3 digits (Excel 2002)
4 digit PIN creation (97-->)
Transpose in VBA problem (Excel 2002)
Multiple X-Axis labels! (Excel 2002)
Mail excel file on close (Excel 00)
Common Dialog Control (Excel 2002)
FileDialog (XP)
Formula for Counting (Excel 97)
Charts (Excel 2000)
Filter numbers as text (2002 SP3)
Print Screen in VBA (Excel 2002)
Dynamic range within named range (2000 sp-3/ 98SE)
Formula assistance please (Excel 2000)
Delete worksheet quietly? ie without prompt (WinNT/XL97)
Dynamic Worksheet Tab Names (XP)
file renaming with excel vba
A bit of light relief (Excel 2003)
Show only one VBA Object (Excel 2003)
Creating Charts from Excel Data (2000)
Importing to excel when file is too large (2000 sp3)
Styles al la Word (XL XP)