# xlf QandA series

**VBA** Visual Basic for Applications :: Excel

**Dates :: Holidays advanced filter:**- is there a way to create a list of trading days from a table of public holidays?**Excel window :: Fit to 720p:**- I need an easy way of setting the Excel window to 720p resolution for upload to YOUTUBE**Numbers :: ATP covariance code:**- our team is trying to develop a VBA version of the ATP covariance dialog box. Where do we start?**Numbers :: Count decimal places:**- I want to count the number of decimal places in a text string. What VBA code do I need?**Numbers :: Implied volatility, Goal Seek and multiple options:**- how can I estimate implied volatility across multiple options using Goal Seek without selecting individual instruments?**Numbers :: Monte Carlo: function**- why does my Monte Carlo based option pricing function show two different values in the function arguments dialog box?**Numbers :: Decimal place KB shortcut:**Count decimal places: - is there a keyboard shortcut to change decimal places from the keyboard?**Numbers :: Floating point precision, and cell formats:**- Why does the logical expression formula**=0.1=(1.2-1.1)**return FALSE?**Numbers :: Trailing minus numbers**- A UserForm TEXTBOX INCLUDES THE USUAL NUMBER VALIDATION TECHNIQUES, YET ACCEPTS A NUMBER WITH A TRAILING MINUS SIGN. HOW CAN THIS BE?**Worksheets, Ranges and Arrays :: Vector to array**- how do I write the VBA code to link an array to a vector source?**Worksheets, Ranges and Arrays :: Worksheet: name exists**- how can I tell if a worksheet name already exists in the workbook?**Worksheets, Ranges and Arrays :: Worksheet: sort**- how do I sort worksheets from a range list index?**Worksheets, Ranges and Arrays :: WS VBA range array comparison**- WHAT IS THE DIFFERENCE BETWEEN A RANGE AND AN ARRAY IN BOTH EXCEL AND VBA?.

**Ask** a question

**Ask a Question**- send a QUESTION to the xlf QandA series