Windows Secrets
Windows Secrets Lounge
Data Filtering & Printing (any)
Excel Macro (XP)
Data Validation (2003)
name sheet (Excel 2000 (9.0.2720))
Excel VBA Time Calculation (Excel 2002 SP2)
show list of wbook into dir (2000 sr 1)
Counting Multiple Criteria (2000)
Carrying data between worksheets (Excel 2003)
Extract Unique and Sum (Excel 2003)
Switchboard (v2000)
Excel 2003: Not prompting to close (2003)
Insert current date (static) when file is modified (2003)
Mac/PC date problem (Excel 2000-2004)
Find a string (2000)
Open Word Doc with Links (2000 sp3)
Macro for automatically naming ranges (Excel 2003 )
Formatting a custom header (Excel 2003)
'Never say Die' macro(s) (2000 sp-3/ 98SE)
copy and add line ... (2000 sr 1)
Excel Objects In Word (2003 SP-1)
Extract Data (Excel 2002)
how can i automate this? (2003)
cannot copy sheets (2000 9.0.4402 SR-1)
Pivot Table Calculation (XP, 2003)
Formatting the date in a footer (Excel 2003)
How to draw a line on a form (2002, XP Pro SR2)
Plot a circle/spiral (2000)
import txt into table (2000)
Pivot Table (2000)
Formatting graph area (2000)
COUNTIF (2002)
margins do not fit page size (excel 200)
Pivot table problem (2000)
Make Cell Addresses dynamic with hyperlinks in VBA (Excel 2000>)
indirect (2003)
Bolded text on a msgbox! (Excel 2000>)
Conditions (excel 2003)
Calculate microseconds (2000)
IF any of the statments are true then (excel 2003)
Blinking Font Format (XP/SP2; OXP/SP3)
Copy/Paste error (2003)
Check cells for valid (Excel 2003)
delete dupes in orizzontal (2000 sr 1)
Split screens (Office 2000)
Count rows in multiple selection! (Excel 2000 >)
Solver/XNPV (2002)
MultiCalc Function (Excel 2000 >)
MAC AND PC (Excel 2003)
Is WorksheetFunction really necessary??? (Excel 2000 >)
suggestion... (2000 sr 1)
Catastrophic Failure (XP; SP3)
call my macro or... (2000 r s1)
Pull in amounts from one worksheet to another (XP & 2003)
Peoples names - one column to two columns (Excel 2003 SP1)
Named Ranges II (2003 SP1)
Consecutive 3-Character code (Excel 2000 >)
Floating Toolbar (2000 sp3)
Generating Permutations (Excel 2000>)
adding a menu bar item (2003)
Creating a transparent chart series (Excel 2000>)
Error deleting pivotitems (2000 2002 2003)
Separating duplicate records. (XP & 2003)
Insertion of date into cell (2000)
Macros within excel (v11.1.1 for Mac)
Using a tab's name in a calculation (Excel 2002 SP3)
Special Paste (XP SR!)
controll loop.. (2000 sr 1)
Finished with a form (2003)
Time entries in 15 minute increments (Excel 2000)
Form button not working (2002 SP3)
What is () (Excel2003)
Removing 0 when referrer cell is empty (2002 SP3)
Conditional Formatting in List (Excel 2003)
Excel Styles - Why Use them? (XP/2003)
few items for class score sheet (2003)
error msg 'cannot complete task' (Excel 2003)
Radar Charts-resources (97-->)
Adding hours and seconds (Excel 2000)
Combo Box with Titles (Excel XP)
doCalcuating tax year (2003)
Interactive Chart (2003)
Pasting data in other tables (Excel 2003)
WHO!!!!!!!! Where is my command and list command? (2000 r s1)
Auto Filter Same info multiple columns (Excel 2002)
Sorting a sheet with multiple heading rows (Excel XP)
Application Quit; Server Side (XP; SP3)
Order column based CTR (2000 sr 1)
Data Cleanup (XP/2003)
Two condition on REPLaCE (2000 sr 1)
Importing dropdown box into EXcel (2000)
Counting based on 2 conditions and in a range (2003)
redim of an array (2003)
Compile error in hidden module ? (Excel 2002)
GET RID OF #DIV/0 (XP & 2003)
LOOKUP formula (Excel)
Check for total digit count (2000 sp3)
Formula in UserForms (2003)
Paste Lock problem (2002)
Creating a link to a specific message in Outlook (Excel 2003)
trapping cell (2000 sr 1)
Scan into all line of txt file... (2000 sr 1)
Mailto: Query (Excel 2002)
Workday question again!! (2003)
very slow calculation (Excel 2003)
Choose a target cell in a table (XP & 2003)
Intersect Target (XP; SP3)
Passing Variable i (XP; SP3)
the offset function (Excel 2003)
Format Plot Area (Excel 2002)
search and replace with formatting (Excel 2003)
Method to split delimited value like this: A;B;C (2003)
Organising chart labels (WinXP, XL2003)
Iinsert value into column L if... (2000 sr 1)
Sharing violation during save (Excel 2002)
Show Month Name (Excel 2000 >)
Template Wizard add-in tmplwiz.exe (Excel 2002)
? function to count unique similar to CountA( )? (Excel 2003)
formula help (office XP)
search for a value using a macro (xcel 2003)
Horizontal bar chart data labels (Office 2003)
Automatically copy cond formatting (2000 sp3)
Formula Problem (Excel 2002)
Excel formula query (2003)
WHILE NOT... (2000 sr 1)
Control toolbox grayed out (XP)
IF Problem (Excel 2002)
#N/A's in cells (Excel 2000)
PasteSpecial xlPasteValues (Excel 2000 SR1)
Pivot Table Problem (Excel 2002)
IF formula (XP)
vba loses a range on data (excelxp)
Modeless Message box (Excel 2000)
run macro on file | open (xl2ksp3)
Conditional format of date (XP)
Toolbar Icon via VBA (2000 sp3)
Skipping oCell (XP: SP3)
Sheet x of y (WIN XP/Access 97)
Unsaved Pivot Table Crashes (Excel 2003)
Lottery Checker (E2003)
Formula help please (Office XP)
Cycling sheest... (2000 sr 1)
Apply Autofilter on multiple sheets (Excel 2002)
Extract number.... (2000 sr 1)
Can't see all rows (Win xp + Excel 2000)
Moving Comments (2000)
Convert EST to PST in formula (Excel - Office XP)
Notify-Reverse Engineering (XP:SP3)
Window freeze & split (xp & 2003)
Bar Chart Labels (Office 2003)
Why the macro not esclude the sheet... (2000 sr 1)
List Updated Workbooks Between Dates (Offive 2003)
why overlow... (2000 sr 1)
Code Crashes Excel (XL2002 SP1)
Condition very strong... (2000 sr 1)
Compounding Interest (daily) (2000)
selectively add from a range (Excel 2003)
Print Macros (Excel 2000)
multi-select Forms listbox (Excel 2003)
Function or Macro for Adding Non-Adj. Cells (XP (2002))
ActiveWorkbook.SendMail (Excel 2003 VBA)
VBA code block inserts! (Excel XP)
Error run time.. (2000 sr 1)
XY Graph labels (2003)
pivot tables (XP)
Excel VBA modules still open (ExcelXP SP3)
Monthly balances (Excel 2002)
help for the new one (Excel 2000)
Active Cell Offset (2003)
Custom Function to search for text (2003)
Formatting (2002)
Filename With Variable (XP; SP3)
Execute GoTo Label more than once!! (Excel 2000)
inset name of the sheets into othaer sheet (2000 sr 1)
calculating date and time (2000)
Printing problems (2000/XP)
Reference Activecell in class module (2000 sp-3/ 98SE/ VB6)
convert .wk4 to Excel (Win XP Excel 2003)
multi tasked if statement (excel 00)
Excel Automation of PowerPoint (2000 sp3)
Undo in VBA code (2000,xp,2003)
Why Value returns 1 (Excel 2003)
Disable Marcos (Office XP)
Scrolling a Userform (XP 2003)
1004 runtime error (2000 sp-3/ 98SE)
Getting Workbook Names from a consolidation (Excel)
Dynamic Autofiltering?? (2000 SP3)
Excel 911 Replace mystery (Excel2000/ExcelXP)
Chart Data Labels (2003)
Help with Formula (e)
Another Approach to Vlookup? (excel 2000)
Indexing of data (2000 sp3)
Faking a Gantt chart (Excel XP)
Perhaps my post is a stupid question.... (2000 sr 1)
Tabbing (E2003)
filling fields (Office 2003)
Populate a range from a single cell (Excel 2002)
Custom Form buttons (2002, XP Pro SR2)
Count and concantenate (XP)
transfering data value from 2 Wbook... (2000 r s1)
Help on Formula (Excel 2003)
Customizing the built-in data form (XP)
Round up if (2003)
Size of charts when linked to Word (2003)
Locked cells in Excel (Excel 2002)
financial functions (2003)
vb formatting cell (200/2003)
VB to add worksheet to end of workbook (2000/2003)
Data Sorting Problem (Excel 2000)
If statement (2000/2003)
Conditional Formating (97)
Advance Filter & Copy (Excel 2000)
Multi Selection Lists (Excel 2003)
Work out date from hours (Excel 2000 >)
IF Problem (Excel 2002)
MEDIANIF Function??? (Excel 2003 SP1)
list which can be added to (excel 2000)
filter by length of cell contents (2000)
sort by last 4 digits in field (2000)
Close All Event??? (Excel 2003)
axis labels (2003)
Hans remember my old prob to order sheets? (2000 sr 1)
Hiding columns if condition is not met (Excel)
Use sheet name (WinNT4, XL97)
copy also into LISTA shett (2000 sr 1)
Devide record in sheet based first letter (2000 sr 1)
formatting for percentage (2000/2003)
Workbook Delete After Expiration (Office XP)
showdata (2002 sp3)
Saving from a Macro (2003 SP1)
Waiting for another OLE action to complete? (Excel 2000, Access 97)
Excel time (2002)
Convert XLA to XLS (2003/SP1)
Protect Individual wksheet (Excel 2002)
Pivot Table Number formats (2002 sp3)
protecting spreadsheet (2000/2003)
Excel Presentation (Xl 97 and >)
Hold one cell constant in formula (2003)
XIRR and stock/mutual fund purchases (Probably all
Open workbook from VB (XP 2003)
Rid of Notification (Office XP)
expected expression error (Excel 2003)
SOLVED--SUMIF blind to value calculated using IF()
Copy customer data (XP)
Running File | Send To (Excel 2002)
Force Data to certain Format (2000 Sp3)
Gantt chart? (Excel 2003)
Limitation In VLookUp (Office XP)
Reading A CSV File (XP:SP3)
Eliminate Error Messages (Excel 2003)
Calculate on Status Bar (Excel XP)
Comment - How to write a macro to move & size cell (XP)
Takes time to open a sheet (2002/2003)
Remove/List Duplicates from SAP list (Excel 2000 >)
rows & columns / square (XL 2003)
VBS Code - Create Txt file (Excel 2002)
What if statement on two sheets (VBA Excel 2000)
Excel IF Function (2000)
selecting from a list and filling out the rest (excel)
link excel to outlook (excel2000)
Tracking changes in excel file (excel 2000/2003)
making a form (excel 2000)
Capture No from a range (Excel 2002)
Identify Upper Case Entries (2002)
Automatically copying into multiple worksheets (Excel 2003)
Adding sheets (Excel 2003)
Undo after saving (2002 SP3)
Slow Macro (Excel 2002)
filtering data every 5 secs (excel)
Cell Formatting (XP)
Delimited Text File (Office XP)
Excel mis-reporting Macro Security Level? (2003 SP1)
Excel questions (2003)
Excel file it takes long time to open it (2000/200
nON BLANK VALIDATION! (Excel 2000 >)
Export to Text (Office XP)
Summing calculations (Excel 2000)
Vlookup with ComboBox (2003)
Complex Formula--need help! (Excel)
Green bar paper (Excel 2002)
Formula Help (2000)
Deletion of Range Names (XP)
Recalc is not working with validation! (Excel 2000>)
COUNT/SUM (IF) (MS-2003)
Excel Currency Conversion Template (Excel 2000)
Row Conditional Formatting (2002)
Changing size of Checkbox (excel 2003)
VLookup with text as references (XP & 2003)
Random row in sheet! (XL2003)
AutoFilter (Excel 2003)
Last cell (2003)
Rounding to nearest .125 (Excel 2003)
find matching values in two lists (xl2kspsomething
Unable to access hidden shapes (2000 sp-3/ 98SE)
charts (excel2003)
Divide into three (excel 2003)
Excel - Fill? (Excel 2002)
Lost Bullet (Excel 2003 sp2) (508210) was moved to the Word board
Formatting Pivot Tables (Excel XP)
Multiple Find & Replace (XP 2003)
Excel Program Error (2000 sp3)
Partial Derivatives (Excel 2003)
outlining in a cell (excel 2000)
UsedRange Scrollbar (2000 sp3)
Custom Button Recommendation (XP; SR3)
Convert Positive to Negative and Vice Versa (2003)
cannot open excel 2002 file from windows explorer (excel 2002)
SUM based on MAX condition (2000)
VLookUp (Office XP)
Setting Range? (Excel 2003)
Auto Resizing Comments (2003)
Showing Numbers in English Words (2003)
Active Printer (2002/SP2)
Help with IF statement (2000 sp3)
Pivot Table Assistance (XP: SP3)
Chart type vs Y-axis definition (2003 xp prof.)
reference between sheets same workbook (W2K SP4 & Office 2003)
Disable the Debug button? (Excel 2000 >)
Conversion Functions (Excel 2000 >)
Workdays Discrepancy (Excel 2003, SP1)
Format Cell Color based on value (2000 sp3)
Time Calculation (Excel 2003)
Excel object embedded in html (11.0) (507045) was moved to the Web Design, Coding and Scripting board
Format (Excel 2000)
Formula too long (Excel 97 on XP Pro)
Max No Users Shared Workbook (2003)
Copy Marco (Office XP)
Code to Hide Error Formulas (Excel 2000>)
Default Settings (Excel 2003)
Simple Macro (2003 (11.6355.6408) SP1)
Concatenate (Excel 2000)
Sending attached file (2003)
Templates Wizard? (2003)
Find&Replace in Comments (Excel 2003)
NETWORKTIME??? (Excel 2000>)
Refresh Charts (2003 SP1)
Can't close Excel (Office XP for Students and Teachers)
XIRR (Excel 2003)
Modified file not available with AutoRecover (Exce
Exported numbers formatted wrong (2003)
Excel Filters (Excel 2003)
Excel Macros (Excel 2003 SP1)
Format Percent (2003)
Seperate Data again (Excel 2002)
Find value based on column/row intersect (Lookup?) (2002)
spell check & CAPS (XP)
Formula doesn't copy (XP)
Error Message (97)
Gridline not printing (Excel 2002)
Links to SubTotals (Office XP)
Worksheet to workbook VBA (Office XP)
Help with Formula (2000 sp3)
COUNTIF Problem (2000)
controll read write error on floppy disk... (2000 sr 1)
changing format problem (Excel 2000)
Why not is delete the first line (2000 sr 1)
Inconsistent scrollarea results (2000)
Variable range name in a function (Excel 2003)
Subtotals (Excel 2000)
If / Then Formula (97)
Lookup function help (Excel 2003)
Sort the entire region (2002 SP3)
Closing one workbook closes all (Excel 2000)
Pivot Table (2000)
Text prints outside margin (2003)
Too Many If statements. (microsoft XP)
Extarct line from all sheets... (2000 sr 1)
Text to two columns (2000)
Concatenate a range (Excel 2002)
formulas not updating (2002)
Save as fixed width text file (Excel 2002)
Change cell Colour (97-->)
peraphs i am a stupid! alwauys on format number... (2000 sr 1)
Graphing Zero Values (Excel 2003)
running totals (Excel 2000)
Frequency of text entries (Excel 2003)
Default Pivot Chart (2003 XP)
Date File Modified (2002)
Calculate CIN (2000 sr 1)
Euro signs (XP)
VB Text Argument as VB Instruction (Excel 2003)
Reading Text Files (XP: SP3)
Passing a variable to another workbook (2000)
UserForm screen updating (2000)
A Better Way (XP; SP3)
Difficult to import some Variable (2000 r s1)
VBA Problem Re: Printing (2003)
Function Troubles (Excel)
Separating Text in a cell (Excel XP)
Excel and ODBC (Excel 2002)
Validating test questions (Excel 2003)
File Used By (2000) (504263) was moved to the Windows 2000 board
devide data from changed var... (2000 sr 1)
How to remove dashes, periods, etc. (Y2K)
Excel Formula (97)
Large Excel Spreadsheet (Excel 2000)
Parameter Type (2000 SP3)
Sharing macros (Office XP SP3)
Conditional Format ? (Excel 2002)
Square root in formula (XP)
Counting total numbers (Excel 2003)
Can't find tilde (Excel 97)
Excel with mailto (XP)
Help with Button Codes (2000)
What are the Odds (XP; SP3)
Line Weight (2003)
Delete if cell is empty (2002)
equation with text (exel 2003)
Match Text (Office XP)
CSV Date import (Office 2000)
Macros and Toolbars (XL2003 SP1)
Red Asterisk (2000 9.0.6926 SP-3)
Show a zero at the beginning of a number (2003)
HTML Text boxes (2003)
Indirect Function & Relative Cell Refs -Copy/Paste (2000/2002/2003)
Library File (Excel 2003 SP1)
Toggle between Multiple buttons (xp)
Create sheet in base of month... (2000 sr 1)
Convert date-of-birth to age (Excel 2003)
Format number (2000 sr 1)
Can't Find 'networkdays' on ATPVBAEN.XLA (XP; SP3)
Mail Envelope (XP; SP3)
Move to next Column (Exel 2000)
External Links (XP: SP3)
average a range (2002 xp)
Dates (Excel 2003)
Get External Data glitch (XL2k sp3)
Remove space after # (Excel 2003)
System Names Conflict (2000 sp-3/ 98SE)
Formula File Reference too long (Excel 2003)
Personal file (Excel 2000)
Excel Using Outlook Template (XP: SP3)
Compare names to make numerical entry (MS Excel 2000 SP3)
Pop-up Calendar (2k)
Cascading cells context menu (2000 sp-3/ 98SE)
Page break (XP)
Hlookup (Excel 2000)
Where's my result? (2003)
Macro to Round variable (Excel 97 SR2)
data location in lists (2000 sp3)
hire shop example (office2003)
Save Flle Problem (Excel 2002)
FILE > SAVE AS causes data to delete (Excel 97)
Impressed with Excel (XP)
Multi-column lookup (Excel 2003 SP1)
Rounding off to the nearest Tenth (Excel 2002)
Custom Date/Time Format ? (2000)
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)