J-Walk & Associates, Inc.

General

• Clearing The Text To Columns Parameters
• Making An Exact Copy Of A Range Of Formulas, Take 2
• Create A Drop-Down List Of Possible Input Values
• Excel 2007 Upgrade FAQ: Charts And Graphics
• Excel 2007 Upgrade FAQ: Formatting And Printing
• Excel 2007 Upgrade FAQ: General
• Excel 2007 Upgrade FAQ: User Interface
• Using Custom Number Formats
• Navigating Excel’s Sheets
• Override Excel’s Text Import Wizard
• Sharing Autocorrect Shortcuts
• Making A Worksheet Very Hidden
• Importing A Text File Into A Worksheet
• Using A Workspace File
• Protecting Cells, Sheets, Workbooks, And Files
• Resize Excel’s Sheet Tabs
• Changing The Number Of Sheets In A New Workbook
• Close All Workbooks Quickly
• Restrict Cursor Movement To Unprotected Cells
• Change The Color Of Worksheet Tabs
• Making An Exact Copy Of A Range Of Formulas
• Creating A Database Table From A Summary Table
• Solving Common Setup Problems
• Getting A List Of File Names
• CommandBar Calculator
• Spreadsheet Protection FAQ
• Extended Date Functions

Formatting

• Quantifying Color Choices
• Excel 2007 Upgrade FAQ: Formatting And Printing
• Comparing Two Lists With Conditional Formatting
• Alternate Row Shading Using Conditional Formatting
• Duplicate Repeated Entries In A List
• Removing Or Avoiding Automatic Hyperlinks
• Working With Fractions
• Using Conditional Formatting
• Fix Incorrect Decimal Places During Data Entry
• Display Text In Multiple Lines
• Changing The Default Cell Comment Formatting
• Change The Formatting Of Your Subtotal Rows

Formulas

• Formulas To Perform Day Of Month Calculations
• Making An Exact Copy Of A Range Of Formulas, Take 2
• Calculating Easter
• Converting Unix Timestamps
• Naming Techniques
• Creating A List Of Formulas
• Cell Counting Techniques
• Summing And Counting Using Multiple Criteria
• Chart Trendline Formulas
• Making An Exact Copy Of A Range Of Formulas
• Comparing Two Lists With Conditional Formatting
• Locate Phantom Links In A Workbook
• Dealing With Negative Time Values
• Converting Non-numbers To Actual Values
• Compare Ranges By Using An Array Formula
• Calculate The Number Of Days In A Month
• Identify Formulas By Using Conditional Formatting
• Displaying Autofilter Criteria
• Calculating A Conditional Average
• Display Text And A Value In One Cell
• Automatic List Numbering
• Calculate The Day Of The Year And Days Remaining
• Rounding To “n” Significant Digits
• Working With Pre-1900 Dates
• Using Data Validation To Check For Repeated Values
• Sum The Largest Values In A Range
• Count Autofiltered Rows
• Perform Two-Way Table Lookups
• Referencing A Sheet Indirectly
• Delete All Input Cells, But Keep The Formulas
• Round Values To The Nearest Fraction
• Avoid Error Displays In Formulas
• Change Cell Values Using Paste Special
• Hiding Your Formulas
• Counting Distinct Entries In A Range
• Force A Global Recalculation
• Summing Times That Exceed 24 Hours
• Transforming Data With Formulas
• Creating A “Megaformula”
• Alternatives To Nested IF Functions
• A Formula To Calculate A Ratio

Charts & Graphics

• Saving A Range As A Graphic File
• A Quick And Dirty Slideshow Macro
• Excel 2007 Upgrade FAQ: Charts And Graphics
• Pasting An Image To A UserForm Control
• Interactive Chart With No Macros
• Creating A Splash Screen For An Excel Workbook
• Creating A Clickable Image Map
• A Class Module To Manipulate A Chart Series
• Chart Trendline Formulas
• Removing Lines From A Surface Chart
• Update Charts Automatically When You Enter New Data
• Creating A Non-Graphic Chart Directly In A Range
• Creating A Linked Picture Of A Range
• Creating A Thermometer Style Chart
• Displaying A value in an AutoShape
• Handle Missing Data In A Line Chart
• Format Cells To Display In Thousands
• Unlink A Chart Series From Its Data Range
• Display Multiple Charts On A Single Chart Sheet
• Layouts For Column Charts
• Saving A Chart As A GIF FIle
• Rotating Text With An AutoShape
• Creating A Transparent Chart Series
• Creating Combination Charts
• Animated Hypocycloid Charts

Printing

• Excel 2007 Upgrade FAQ: Formatting And Printing
• Determining The Number Of Printed Pages
• Mail Merge - Without Word
• Displaying A Menu Of Worksheets To Print
• Copy Page Setup Settings To Other Sheets
• Printing Just A Portion Of Your Worksheet
• Avoid Printing Specific Rows

General VBA

• Clearing The Text To Columns Parameters
• A Macro To Count Word Frequencies
• Saving A Range As A Graphic File
• A Quick And Dirty Slideshow Macro
• Maximize Excel Across All Monitors
• Understanding The IsDate Function
• Excel 2007 Upgrade FAQ: Macros
• Controlling User Scrolling
• Creating A List Of Formulas
• Selecting All Unlocked Cells

CommandBars & Menus

• Add The Speech Controls To The Ribbon
• Identifying CommandBar Images
• Creating Custom Menus
• Developer FAQ - CommandBars
• CommandBar Calculator

UserForms

• Pasting An Image To A UserForm Control
• Displaying Help
• General Userform Tips
• Selecting A Directory
• Displaying A Progress Indicator
• Importing And Exporting Userforms
• Handle Multiple Userform Buttons With One Subroutine
• Filling A Listbox With Unique Items
• Displaying A Menu Of Worksheets To Print
• Creating A Color Picker Dialog Box

VBA Functions

• Extracting An Email Address From Text
• Quantifying Color Choices
• Determining The User’s Video Resolution
• Identifying Unique Values In An Array Or Range
• Getting A List Of File Names Using VBA
• Looping Through Ranges Efficiently In Custom Worksheet Functions
• Undoing A VBA Subroutine
• Determining The Last Non-empty Cell In A Column Or Row
• Multifunctional Functions
• Some Useful VBA Functions