Windows Secrets
Windows Secrets Lounge
Interactive calendar using an array formula (2003)
Help with IF statement (2000 sp3)
Pivot Table (2000)
Rows Unhide (Excel 2003 SP1)
Copy code progammatically (Excel 2000)
Copy/paste subtotals - not details (2003)
Tracking Changes w Strikethrough? (2003)
case is... (2000 sr 1)
summing values using vlookup (2002 xp)
New line in cells (Office 2003)
Macro to load function in cell (2000/XP/2003)
Creating variable link formula (2003)
Sort Data (office xp)
Countif (2003)
Hide Columns (Excel 97 SR2)
Variable Sizes (Excel 2003)
Don't Update/ #N/A (Excel 2003 SP-1)
Conditional Format refers to InCell W/S Funcion (Excel 2002)
Remove Macros (Excel 2000)
Sending a worksheet in an email body (MS Office 2k)
Filtering/searching multiple workbooks/sheets (2002)
deleting 0's (Excel 2003)
Corrupted workbook (2002, XP Pro)
Need Help with Code Logic (2003/SP1)
VBA Match Function (XP; SP3)
Reduce the size of an XLS file (Excel XP)
Default to last file location? (XP/Office 2003/DOCS 4.0)
No macros?! (2003)
Insert File name in cell (Excel 2002)
Seperate Data (Excel 2002)
index match min & max (excel 2003)
index match min & max (excel2003)
Convert Text to Date (Excel2002)
Password cracking (xp, 2003)
Forecasting or Budgeting Data Input Tool (Excel 2003)
using the * as a wildcard? (excel)
More Auto Date Frustration (Excel 2000 9.0.3821 SR
YTD Variance Formula (Excel 2003)
If statement within macro? (Excel 2000)
Can You Prevent A Workbook Closing? (Excel 2000)
Code Interacting on Memory (XP' SP3)
File not saved (Office 2000)
Links to Other Spreadsheets (Excel 2000)
Producing macro to retrieve data from Access (2000)
Excel neglecting shortcuts (2003)
Tracking a running total (2002)
MsgBox Centering (XP: SP3)
Smart Tags Missing (XL2003 )
TEXT IN CELL MANIPULATION (excel xp or 2003)
Cells look empty but are not (XP)
Camera feature with page breaks (Excel 2002)
Toggle Caps, TitleCase, LowerCase... (Excel 2002 SP3)
Change Text to Hyperlink (Excel 2002 (XP))
Find repeated data and remove (excel)
webpage info into Excel.... (2000 sr 1)
Sort Limit (Excel 2000)
Missing:SOLVER (XL2002 SP1)
Time-limit use of a workbook (2000 on)
Excel counting formula needed. (2000)
Label Centering (XP)
Enter character (Excel 2000)
Accessing a select statement from a cell (Excel 20
How do I insert a footnote? (2002)
Find() from the right (XP)
Auto-format as You Type (XP)
Now You See Them Now You Don't (XP:SP)
Combined AND and OR statement (Excel XP)
VBA formating borders (Excel 2000)
NAME Error (2003)
Create list of all macros in personal workbook (Excel 2000 SR1)
control buttons (excel 2000)
Sending mail with/without attachments (2000)
Find most popular item (2003)
Comparing conditional 2 cells and color (excel 2003)
Import Large Files (Excel 2002)
Structure long daily chart of meds and test result (Office 2003)
Extract cells from a workbook (excel)
How to add IS Error in formula (2000 sp3)
Month in header (WIN XP/Excel2003)
CalculationAutomatic Fails (XP; SR3)
special graph and charts (2003)
Insert Column (Office XP)
Getting when file was created! (Excel 2000 >)
ChartSpace Control (XL 2000)
Printing/Exporting Comments only (2003)
Macro or VB (Excel 2003)
Calculating interest and balance owing on debt (Ex
build a string from single cells (Excel)
Embedded Charts (XL2002-SP1)
Protect Sheet but enable Autofilter (Excel 2002)
Unprotect Workbook (Excel 2002)
Remove all VBA (Excel 2002)
Run Macro from Toolbar (Excel 97)
Pivot Table Sorts (2000 sp3)
dynamic range names don't appear in 'Names' box (x
Formula for Return on Investment (2003)
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)