- How to Capture if Spreadsheet is open in IE and not Excel
- Array Function help
- Dictionary
- VBA routine (101)
- Save file -prompt
- Comple Error Cannot Find Project or Library
- Passing Back Color to Interior Color
- Useful Comment Concerning Memory Read/Write Errors
- copy destination values
- Sheet name problem
- COUNTIF Multiple Criteria
- Import VBA Code in Excel-File ? (Export VBA Code to file)
- linking two workbooks with ODBC & the Excel Driver
- Update header BeforePrint
- Open files in different folders
- Code to select 'Disable Macro' when opening an EXTERNAL FILE
- Deletion of cells by next blank cell command??
- click event on listbox
- How do you create formulas using the date on the computer?
- column
- Opening CSV file with 69000 + rows in Excel using VBA
- Chart source data range
- Userforms
- sumif criteria
- How to Count String occurences
- Control Panel
- byte order reversal in spreadsheet
- Set Print Area programatically
- Create way to change data in list from another page
- enable macro message not appearing
- automation server/add-in installation
- How to: User Form to assign a user defined range to a macro variab
- VLOOKUP formula not updating automatically
- populate multicolumn listbox?
- Fixed sized printout XY-diagram
- How do I reference my current file in saveas function?
- Range Cut and Paste
- Userform Scrollbar
- Total Field Count
- excel: external data "data range properties" button dosent work
- one very, very bad line of code? Trim and chr(10)
- Unprotecting VBE Project to Make Code Changes
- How do I pass an array to a listbox?
- value to range
- Execute Events Based Upon Selected Cell
- append two worksheets with excel macro
- Macro for workbooks
- Email a Userform
- How Can I make excel go faster
- Deleting rows from a combobox
- Excel2002 - use sql statements?
- Print preview?
- selection bug treeview
- modeling offset of losses against profits
- Macro to Paste Special Row Heights
- Code Halt - prevents reset of the AutomationSecurity level
- UserForm_QueryClose questions
- Printing formating/range problem
- Moving section of cells clears instead!?
- how do you generate a report every 5 mins automatically and delete
- Can I use a defined integer in an OFFSET method?
- merge two worksheets with different columns and data
- VBA code to Autofill one cell to many rows below where row count will change
- Require draggable control within Excel
- Require draggable visual object in Excel VBA
- Dictionary - Add method parameters
- autofit row code
- option button-if else?
- Selecting worksheets into groups?
- Setting a variable using COUNTA
- Two-dimensional Named Ranges
- VBA Addin
- Error 1004 Method 'Add'of Object Sheets failed
- ID: 860 Please help!
- ID 860 PLEASE HELP
- More than 24 hours
- Forensic Spreadsheet Review
- Finding data
- Write a code with another code
- Re: Check Box
- Manipulating Data in a row
- Excel VBA - CopyFromRecordset (ADO) Problems with 107000 records
- Cell Watermark
- Re: CheckBox
- filtering data with a macro
- Copy & Paste visible cells only
- Widening Names Dropdown (Bob)
- Can't Change Font Colour
- Setting the Sheet on Woorkbook Open
- Define Names / RefersToRange
- Select Case Statement does not evaluate
- Setting "DisplayGridlines" Programmatically
- Application.GetOpenFilename
- Help: formula=auto copy from sheet1, A1 only if data in field E1 .
- Importing .bas files
- Batch Replace function for Large strings
- Open File Dialog Filter
- Extracting filename
- Searching for "not blank"
- How do I make a change in time into a number I can use to calcula.
- deleting cells in a range
- UserForms:listbox display problems
- Last Cell
- Moved code from worksheet to module
- programmatic generation of Enum To String functions
- Excel crash closing ADO connection object
- Retrieving the SQL query of the external data range
- Adding a Menu Item into a sheet as a button
- VBA Compile Error on Deployment
- MVP help
- Macro question
- My entire Excel worksheet scrolls down when I hit the enter key. .
- Question as to why this will not run?
- Flash a MsgBox
- loan amortization template
- search columns, set variable value
- Horizontal line on line chart
- Textbox/Userform question
- RTD, how do you stop/start it from pulling in data?
- Consolidate data from several worksheets via pivot table
- Using worksheet_selectionchange to prevent null cells ???
- workbook in IF statement
- Find/Replace based on CF result
- export excel data to a word template using a macro
- Autorecovery
- Reference Libraries
- Creating a "Smart" Autoshape
- Enable macros => HD/CPU issues- help! any ideas?
- Userform Question - is this possible?
- Whats the difference
- sheet name referencing
- Multic Column List Box - Can I add vertical lines to separate colu
- Is it possible to share Excel workbook with a remote user??
- Automation Question
- Macro to delete space in front of date
- Pick list on a sheet - multiple rows?
- Print Same Range on Multiple Sheets?
- Visual Studio .Net C# and Excel
- Find and Replace code in Sheet modules
- Pagebreaks problems - Urgent
- Evaluating a Range of Empty Cells with VBA
- Extracting worksheet index
- VBA code help for item tracking.
- Need Help - save sheet then hide when....
- Text Sum
- Application.Min - how to ignore zero value?
- DDE link cache in DDEML library - is it so?
- HARALD STAFF - CONCAT_IF
- Custom button & VBA function
- Invalid Picture Error when user clicks on toolbar
- How to use SUMPRODUCT in macro?
- PivotTable (blank) cells won't display NULL!
- UserForm determine WinXP windows style
- How do I Hyperlink to a hidden sheet in a same workbook ?
- Deletion of rows where a value is satisfied for all the sheets
- Extract and copy Rows where value is Greater than 0 (zero)
- User Form Questions
- average on qty
- change font of certain cells in row(s) when ColorIndex of Column S changes
- Using ADO to INSERT Named Range Values into DB
- Range Values into userform
- On Time
- form problems
- Ever heard?
- Call Macro when Cell within Range Changes
- Logical String Evaluation
- Chart from VBA
- Date question
- If...and... - can never get the syntax correct!
- Can never edit my projects, everything is always "read-only mode"
- Problem with Shape Names containing punctuation
- Copy to another sheet fails
- Excel file saved as hex values
- Using Date in InputBox for criteria in code
- Re-defining Ranges in VBA
- Select column cells to the left/right of active selection - an example
- DateValue Trouble
- Loop in Excel?
- Range problems...
- Further Userform questions
- Looping through listbox controls
- User Form Spin Button
- Autmatically remove filters from all worksheets
- "Ready"
- 429 ActiveX can't create the object
- Paste into a QueryTable
- Save Workbook without VBA code
- Timer Alarm
- cell address within formula
- Find Text and put total across from it
- Select rows and copy to another sheet.
- Hiding cell values for printing
- How to deal with Find when nothing is found
- Using 'Find' and 'FindNext' in vba
- Select specific Data from a cell
- formatting based on text
- Copy a sheet and rename it
- Using Public to Pass Variable
- Open JPG and determine pixel width in VB?
- fast and simple way to match up arrays
- Checking to See if Range Values Add up to 100
- Relative cells in different sheets in same workbook
- Delete a Sheet without dialog
- macro on tool bar
- Excel 2002 Object Model
- End Of Month
- Deleting Code in 'ThisWorkbook'
- conditional formatting ... shade cell ... older than today
- Delete Rows Cut
- Looping on Cells with $x$y
- Custom button on custom toolbar wants to re-load "Personal.xls"
- Open files in folder - skip if already open
- IS functions
- Automation Error
- Excel 2002 With WINXP on a dual processor system
- Excel 2002 recalculation while executing VBA Procedure
- counting colored cells when merged
- Not enough memory?
- Finding out whats Protected...
- Deleting Sheets
- Exchanging data between Linux and Excel
- Deleting Contents of Sheets
- Copy from one workbook to another
- autofill or copy & paste "till a value"
- Track changes
- VBA Function that mimics the Access Not Matching Query
- Time Gentlemen Please
- Macro keyboard shortcuts
- Programmatically generate name of functition to call
- using vba in excel 2003
- Cell change event
- Add-in.
- Macro filters on different length worksheets
- Performance Impact: By Reference or By Value
- New Function: ConcatenateIF
- GetOpenFileName method different in Excel xp/2003 from Excel 2000.
- How To Call VBA Code from Excel 4 Macro
- Macro / VB / Instert Date Question
- need help for copying among workbooks
- Or...Yet again!
- Re : Excel - Maximum of a Range Row-by-Row
- Commas in VBE Data Validation List
- Workbook Row Count Question
- Code to fix: 'can't find project or library'
- Pivot Table Totals Not Working
- Array Parameters as Variants Only
- resetting custom buttons for macro
- Large Concatenate
- Vlookup and no results with the =left(a1,4) option :)
- Please Help if You Can
- Schedule taskmanager via code?
- Convert listing of events with dates to calendar - Pls help
- Error types
- how to select range when no. of rows depends from text place ??
- Numbers 0000 will = 0 when converted to a csv file via macro
- Excel not working with .net (System.InvalidCastException: QueryInt
- LockWindowUpdate
- Query using Excel
- upload file name
- Copy from one workbook to another
- CREATING LABELS FROM 1 RANGE OF DATA
- Re: Runnig Excel without visible application
- EntireColumn and merged cells
- Excel 2000 v 2003 Macro & VBA Incompatibities
- Excel 2000 v 2003 Macro & VBA Incompatibility
- Excel 2000 and 2003 VBA and Macros Incompatibility
- Help with adding to a formula
- Data List Visible Rows
- VBA Efficiency Question
- worksheet change event?
- countrysettings
- hide / unhide columns
- How do I ensure that all the data is on one page when printing in.
- Export
- Whats the Point of Protecting VB Projects?
- Loop for a Complex Formula
- how do i set up a web excel worksheet to accept new data?
- PLEASE I NEED YOUR HELP
- Copy value problem... if "" then 0
- Comparing two ranges and extracting non duplicate data
- E-Mail Defaultdaten ergänzen
- Using a form to modify a list
- Re: Program line when charting variances?
- Documentation of Excel Object Model and calling it from VB.NET
- How can I get a negative time in Excel?
- Help Clear Function
- WorksheetsEnableCalculation
- Looping on Cells $x$y (continued)
- Copy some information from sheet1 to sheet2
- I need a formula I can't find in help.
- ControlTips not showing.
- How do I get a Check Box to set a value in a cell when is checked.
- Comperison Data
- closing active windows without saving changes
- #Value
- Xls protection?
- modeling offset of losses against profits
- Offsetting losses against profits
- negative numbers
- Save As Dialog
- running code after pasting data
- Forms Controls
- Write Text File
- Worksheet Change Event Problem
- Sub
- Having problems with a circular reference and the #VALUE! error
- Stop Copying at Specific Row
- Can't put common dialog control on a worksheet
- Return to Current Sheet in On (sheet activate) event macro
- Duplicate Values on Multipage form
- Pivot Table Field
- Conditional Format and VBA
- copy rows conditionally
- Copy ... Paste
- How do i allow users to edit a cell's contents, but prevent them from moving, cutting or deleting the cell?
- Object variable or With block variable not set?
- Command buttons and code - help!!
- Deleting element in Array
- Import a data using a command button
- i want a macro in execl to wait for an input from the user.
- User Defined Function for Wind Chill
- Problems Converting 1-D Array to 2-D Array
- Opening ,copying, access query resultsfrom Excel
- array to access
- xlAutoOpen and GetActiveObject
- How to protect option button?
- Can you freely write excel macros in C# yet?
- Excel Web Query using a QueryTable via HTTPS??
- PrintPreview doesn't work
- Find & Replace question
- NormInv performace in Excel 2003
- How do I open an aplication and run a file in that aplication use.
- Modify sub to output to new sheet instead of via msg boxes
- Excel changes celle when copying ?
- Minimizing/Compressing VB Code in Excel File ...
- How to have different columnwidth for same coumn in several parts within one worksheet?
- color hidden columns
- What properties show on icon mouse-over?
- userform-check data type
- LockWindowUpdate
- Formatting Performance
- Copying Sheets
- Code libraries usable in all of Office?
- global 'path' declaration
- Help with HLOOKUP Please
- UNDO in VBA code???
- External Query questions
- Rename Modules
- Execute code on server
- Worksheets not visible in Excel XP
- Clipboard.GetText
- SQL.REQUEST Returns Single Cell
- Pivot Table Year to Date
- Cumulative total
- Ending an External App from VBA
- VBA or no VBA, that is the question
- Code to close workbook
- Sheets Looping ignoring contraints
- Excel Workbook Address in VBA
- XMLs
- import XMLs
- import XMLs
- create entries on a listbox on a form
- Best VBA newsgroup?
- copy formula using vba based on row count
- Data validation - comma
- File Attributes
- Link multiple worksheets in one workbook to another workbook and .
- debug error
- Macro to rotate data in cells
- Saving Worksheets
- SaveAs using cell value
- Protect workbook?
- unable to set the FormulaArray property of the Range class
- Opening a non excel file using vb
- Saveas where file already exists
- Re: Sum in VBA
- Inhibit Cut (allow Copy)
- EXPORTING data from spreadsheet to SQL SERVER DATABASE
- Can I password protect VBA modules using a macro?
- Redefining pivot table source
- Macro problem on, Yellowed line - previous line or next line.
- Validation ComboBox Size or alternative....?
- Referencing Combobox with other cells in a different worksheet??
- Formulas for creating a muti-unit 12 mo. bugdet using a 1 store mo
- Run code remotely
- problem removing controls
- range picker / selector
- how to calculate time in a payroll worksheet
- how do I overcome this combobox 'bug'?
- Set worksheet range runtime error 1004
- Stop Debugging !!
- How do I print a hyperlinked document from a cell in excel
- How do I print hyperlinked documents from a cell in excel
- Programming MS Query
- Find empty cells
- Inventory added sub needed
- Problem with Macro working in new workbooks that I open
- Find end of list
- I need a simple formula
- Find last row
- Zero Values in a Pie Chart
- Excel problem with trailing spaces
- sumproduct in vba
- Removing commandbuttons on "save as"
- Curdir
- export data from MS Excel sheet to external database
- Time question
- Way to have VB code to filter on entries that have cell with today's date?
- Countif in multiple books
- ADO: Read Excel file that is in use (locked)
- Macro Warning in File w/o Macros?
- Match and Copy
- Excel Solver
- Refer to Worksheet Ranges in Code
- Create RangeNames
- Calculating a Grouped Weighted Average Rate
- Statistical functions not tied to Application.WorksheetFunction
- Change Message on Protected Worksheet
- Printing: Best Fit (1 Page Wide)
- Find end of list - new problem
- If Sheet exists, GOTHERE, else create it
- Search
- Sorting after subtotal
- all subtotals have summary except one
- ADO 2.7 & ADO 2.8 beforeprint
- sort list more than 3 keys?
- create named range in each sheet in workbook
- HELP! cant edit query
- listboxes
- Copy every nth row into a new worksheet
- Sort by Variables
- Project is unviewable
- Freeze cells from further calculation?
- Search Macro Help
- red point
- Sheet Information
- Multi Column ComboBox
- Code to mimic vlookup
- Replicating CTRL-click multiple row selection
- creating dependent list boxes
- insert new row & fill down
- Change event and calculate event
- Why am I losing macros that I create and store in PERSONAL.XLS?
- Drop-down menu in validation list too wide!?
- Drop-down menu in validation list too wide!?
- input box upon opening workbook
- Inventory a WorkBook
- optionbutton
- 1-variable Data Table w/ dependency on MS Query fails to update correctly
- Import text file contents based on path
- Late Binding issues when closing workbooks
- Copy and paste special, values not working
- Total a Variable Based on Another Variable Please
- Locked Sheet - Error msg to display to Users
- Top 3 numbers in a list
- Import data from Adobe Acrobat PDF Files
- how to add bullet list of text items in cell
- Pivot Table
- run a macro when file is open
- Stop Link Update
- Update spreadsheet from Listbox
- last row in sorted list
- Year to Date in Pivot Table
- worksheet saveas question
- No file when Save As is executed
- Workbook sizing
- Uncheck Check Boxes when Workbook Loads
- Combobox value does not change
- Open book, check for macros, close book
- quick cell fill/formatting
- vb problem
- Run macro if value in cell changes
- text formatting for msgbox strings?
- PAssing Values to Excel
- Print Dialog from VBA
- on error goto trouble
- Stop macro from saving changes
- Align text in adjacent Controls
- Import Dat from Oracle - pls help
- parameters not allowed in queries that can't be displayed graphica
- F2....
- Need data
- Using code to mimic a find and replace
- Application.Match
- If within an If...
- how to query an LDAP server?
- Wildcards in Excel VBA - HELP
- Still Macro Warning w/o Macros ...
- woking with date's
- error in getting system dates
- Store Information but not in a Workbook
- Excel user-defined functions.
- Searching dates
- How do I write an Excel macro to open a file using the CommonDial.
- Resolution change
- Exclamation message box opening Excel - Archive not found!
- UserForm Question
- Help with Excel table pasted in Word?
- ListBox2.AddItem ListBox1.Value becomes a String when being Integer?
- Count number of values
- set range
- Identifying the last number in a row.
- Macro programming in Excel
- avoiding select
- Linking MS dictionary as data into Excel
- Copy cells down
- Printing all Visible sheets
- diferrent Excel versions connection problem
- list box
- Macro Help!
- refer to a cell in another sheet
- Moving data to another spreadsheet...
- date calc returning #name?
- Userform Textbox - fundamental flaw
- Floating Point Functions
- Array Test
- center a message
- populate a different workbook
- Get Displayed Value Of a Cell
- Add dropdown on an event.
- Pivot Table problems
- Adding hyperlink after the existing data in the cell
- Adding hyperlink after the existing data in the cell
- Hiding Rows between Subtotal
- Hiding Rows within a Subtotal
- Hiding Rows between two Finds
- browserflags in registry breaking drop down box value
- Trendline Properties/Deletions in Excel VBA
- Need some help with Exit Event
- Copy Different Name References to New Workbook
- SumIf using two criteria
- windows file shortcut using vb
- IF Mytest.count>0 then VLOOKUP
- link to Access DB
- Find & Replace in Multi-Megabyte Strings
- Open XML string in Excel using C#
- Outlook Tasks assigned from Excel?
- References woes
- end subroutine
- Cell Protection Within a Worksheet
- Sorting Rows in VBA
- newbie redim question
- Detect selected chart point
- variable range automation
- Where is documentation for the C# Office XP/2003 Primary Interop Assemblies???
- Can't find object
- Reducing file size (for archiving, not active files)
- Arranging Windows
- Hide Unapplicable Ranges of Entire Rows
- Reduce file size by removing comments from code?
- What's it take for Canadian Application?
- Type mis-match error
- type mismatch error
- Close Current File Then Open New file
- modify the data in a report
- TextBox6.Text = Application.??????????(TextBox6.Text)
- Shapes disappear from Excel 2000 to 2003?
- I need to create a custom form in excel
- Refering to grouped ActiveX controls on Sheets
- Look up
- How to make a Case Function.
- import csv file
- run code in other workbook
- SpinButton Change Selection
- opening excel through visual basic
- Excel controlling Outlook
- Find Value <> 0
- Macro to run if cell empty
- Wildcard - help I'm stuck
- Pivot Table based on SQL Server query
- pain cell max and min
- MACRO Assistance Required
- Unprotect Sheet - Removal of standard Message
- Macro recording
- Cannot create excel file from .Net in Office 2000
- MACRO HELP REQUIRED PLEASE!
- Copy from CD
- Application.Max wierdness
- Macro
- usedRange
- Copy From CD
- How do I automate the deletion of a row containing today's date i.
- Removing code in 'This Workbook'
- Automation: Create Word file from Excel
- QUERY ABOUT DATA REQUIRE
- macro to alter worksheet code
- text align code XL2000
- Macro Help
- interrogating a workbook WITHOUT opening it from VBA
- Determine If An Application is Already Running
- Sort Method more than 3 cols
- Processor Can't Handle This Deletion Code -- Suggestions to Modify
- how do i select different printer trays using macros
- .column
- Summing the last records of every month.
- Open excel file, enter values, save & close
- Textbox Query
- Need help re Macro
- Does anyone have a Template for a Bank Reconciliation or Cash Rec.
- Does anyone have a Template for a Bank Reconciliation or Cash Rec.
- Is this possible...Filter list after user selects location
- Auto Date range and printing.
- buttons on forms
- Merge
- Row and Column from Used Range property??
- .Cells.SpecialCells(xlLastCell)
- How can I recover from an unsuccessful Find operation?
- Access Time Calculation
- Can't get Workbook_Open event to work
- Changing Cell Font and Color Issue,
- Using a Cube to store Histogram information?
- Copying Formats vs Formatting Programatically
- Convert to minutes and seconds
- changing active cell
- Autofilter Question
- Cell properties dialog
- Auto check list box
- Excel connecting to Teradata
- Problems entering Data validation Programatically
- filter by month
- need to extract data from a pivot table using variables instead o.
- Lookup?
- Selecting a range offset from a cell
- How do I permanently delete a macro?
- Multiselect listbox with check boxes
- Script vs Open_Event
- class module
- Textbox margin overwritten by auto-margin
- Excel Constant for Border All Around Cell
- overloading a function
- Search and Replace help
- Re: Checkbox
- SaveAs Dialog box
- Why won't this code run??
- linking cells in multiple workbooks
- color formating
- getPivotData
- textbox
- Macro for Page Setup - Repeat rows at top
- Use ADO to transfer data from open excel file to closed excel file
- Alert message during Activeworkbook.sendmail
- Template Placement
- EMBED("Forms.ComboBox.1","")
- Excel File Crashes Constantly
- type mismatch?
- How can I lookup cells that match a specific value and return all.
- find 10 max values in different sheets
- Problem with OLEObjects
- ZOrder of two forms
- When code runs...worksheet acts a little strange
- Troubleshoot XML Maps automatically generated by Excel
- Text Box has the focus
- X button on userforms
- Formula Help
- IF Formula to produce coloured statements
- Extract Data from Multiple worksheets
- Help with code please?
- Random
- Removing #NAME? from cells.
- Import HTML code from a text file.
- Excel VBA Assistance please.
- How do I print alternate worksheets in Portrait and Landscape?
- Spacing
- returning workbook name
- How to put a lock on a file
- Run An MSAccess VBA Function From Excel
- Protect Sheet - VB code to specify password
- Loading UserForm on start up.
- Worksheet_Change and range test
- problems with userforms
- Excel Cursor
- Help with Totalling Groups Please
- Help Inputting a Name in a Macro
- how to capture enter key inside a cell
- Loading Form on Startup II
- show file path in Print footers
- how appear open file dialog in access
- insert scanned image into text box
- insert scanned image into text box
- find item in list
- Worksheet.CustomProperties
- how to efficiently send many rows of data on a worksheet to the database using vba?
- is =if(K25=>K36,[SUM(K38:K39)],[SUM(K40:K41)]) ok?
- Update Form from spreadsheet
- Without a chart
- Connection using ADO
- Formatting Data
- excel userform serious problems
- Syntax for running a macro from an =IF function?
- button reuser on forms
- using array, Match, trying to eliminate duplicates -> how to return or translate result to a boolean?
- how to change (override) enter key behaviour in a cell
- Update data and Y error bars in a chart
- Testing for the presence of an AddIn?
- Problem with macro: 1004 error
- Printing Multiple Sheets -- Printer Forcing Landscape/Portrait
- Without a chart
- MoveAfterReturn command fails in Worksheet module
- Advancing to the next iteration of a loop?
- Menu Item check mark??
- How do I auto increment cells so that I may maintain a history?
- Need a msg box that displays time status or loading status
- Need a message box that displays loading time.
- Making Macros in Excel
- Multiple alignments
- Opening a workbook with a specified size?
- How does the type of variable affect code!!
- copying named cells into new workbook
- for each error
- Install RichTextBox Control
- user form & control properties
- populate list box
- Looking for a Black-Scholes Employee Stock Option valuatiion mode.
- Identify Cell by Column Header and ID in Col A (Track Changes)
- Populate
- Position Wordart in Page Center
- Disable "Sheet tabs" check box under [Tools][Options]-[View] tab
- email one sheet of workbook
- MoveAfterReturn fails because sheet is protected
- Successive Data Validation Lists
- weeknummer
- CommandBar Resize
- How to either write the macro or manipulate the function
- Complie Error- Argument not optional
- Index/Match for 2 columns?
- Controlling Access from Excel
- Search for bad email addresses
- A Macro to Delete Multiple Rows?
- Adding Times
- Print Preview
- Paste a hyperlink
- PrintQuality
- Excel should stop promping for OK every 10 seconds
- Lifetime of VBA variables
- Pop up windows
- Disable Macros in workbook programmatically
- End Excel Application
- Tabbing out of Blank Cell
- Help can not calc Sales Tax
- Excel programming
- RowLiner addin How to Start and Stop
- Macro's
- ControlSource
- Houw to Round
- Cannot select day on Calendar if ValueIsNull is True
- Comparing values in two columns and displaying missing values in n
- how to place values in custom header
- connect to MS SQL