colinlegg.wordpress.com
Deleting Rows With VBA | RAD Excel
https://colinlegg.wordpress.com/2012/11/29/deleting-rows-with-vba
Long Worksheet ActiveX Control Names. String Art Add-In v1.1 →. Deleting Rows With VBA. November 29, 2012. A few years ago I posted a series of VBA samples on a forum which outlined different ways to delete rows in an efficient manner. The series proved to be very popular and, since that forum is now in decline, I’m going to resurrect those notes on here. The topics covered are:. Delete Rows If Cells In A Certain Column Are Empty. Delete Rows If Any Cells In The Row Are Empty. Is a single cell then the.
colinlegg.wordpress.com
Who Has My Workbook Open? [C#.Net] | RAD Excel
https://colinlegg.wordpress.com/2015/02/11/who-has-my-workbook-open-c-net
ActiveX Controls Not Working On Worksheets. Delete Rows If All Cells In A Given Range Are Empty →. Who Has My Workbook Open? February 11, 2015. I had to update a C# project this week so it can check if someone has opened (and locked) an Excel workbook. Identifying the actual culprit is surprisingly hard to do – there’s nothing useful in the Excel object model itself – but there’s a really neat solution posted by Steven over at StackOverflow. RAD Developer Microsoft MVP - Excel 2009 - 2014. Who Has My Wor...
colinlegg.wordpress.com
Office 2016 Public Preview Now Available | RAD Excel
https://colinlegg.wordpress.com/2015/05/05/office-2016-public-preview-now-available
2015 Microsoft MVP Virtual Conference. Naughty Sorts →. Office 2016 Public Preview Now Available. May 5, 2015. Microsoft has announced on its Office blog that Office 2016 is now available for public review. Here are some useful links if you want to get involved:. Office Blog 2016 Public Preview Announcement. Instructions To Get The Office 2016 Preview. Participate in Office 365 Community Forums. Participate in MS Answers Office 2016 Consumer focused forums. Office 2016 Preview Known Issues Wiki. VBA: Und...
colinlegg.wordpress.com
RAD Excel | Page 2
https://colinlegg.wordpress.com/page/2
Newer posts →. Stop MSForms.Frame Scrollbars From Resetting On Focus. September 5, 2015. I’ve been doing some more work on my dynamic grid control – which mostly comprises of. A feature of a. Control with scrollbars is that when it gets the focus the scrollbars’ positions reset themselves. Here’s some quick and dirty code you can put in a userform’s code module to see what I mean:. Event to be raised when the scrollbars are reset, the first thing I did was refactor the code so it subscribed to that event:.
excel2013.info
How to create a table with Power View in Excel 2013
http://www.excel2013.info/powerview/power-view-create-table
Business Intelligence for all. PowerView – a BI application. Power View – Create table. Power View – Create a chart. Power Query – Automatic update. Connection to an API with Power Query. Uarr; Return to PowerView – a BI application. Power View – Create table. Creating a table with Power View is easier than creating a Pivot Table. So if you don’t feel comfortable with Pivot Tables it could be a good idea to start with Power View. Create a Data Model. Create your first table in Power View. Download the fo...
excel2013.info
New Functions - Excel 2013
http://www.excel2013.info/new-function
Business Intelligence for all. PowerView – a BI application. Power View – Create table. Power View – Create a chart. Power Query – Automatic update. Connection to an API with Power Query. Excel 2013 comes with 50 new functions, which brings the total number of Excel functions to now 458! 27/03/2014 at 19:05 (UTC 2). Link to this comment. I know very well the formula i need! And a like to introduce typing my self to the cell with no problem! It’s urgente for me! Can you help me? I really appreciate this!
excel2013.info
Timeline Excel 2013
http://www.excel2013.info/timeline
Business Intelligence for all. PowerView – a BI application. Power View – Create table. Power View – Create a chart. Power Query – Automatic update. Connection to an API with Power Query. The timeline is a new tool added for the pivot table. With it, you can easily select a period of dates in your pivot table. Format of the slicer. Filtered on a value. To illustrate use of timelines, let’s say you are managing a big database with Excel in a company of house rentals. And also the date. Format of the slicer.
excel2013.info
PowerView - a BI application - Excel 2013
http://www.excel2013.info/powerview
Business Intelligence for all. PowerView – a BI application. Power View – Create table. Power View – Create a chart. Power Query – Automatic update. Connection to an API with Power Query. PowerView – a BI application. PowerView is a new add-in for Excel 2013 Pro Plus. It is the best tool ever use to Excel as a BI application. To install PowerView in Excel 2013, Go to menu File Options. Select the Add-ins menu and in the dropdown list. Press GO …. Check the option Power View. View page ». Creating a table...
excel2013.info
Major update of Excel 2013
http://www.excel2013.info/major-update
Business Intelligence for all. PowerView – a BI application. Power View – Create table. Power View – Create a chart. Power Query – Automatic update. Connection to an API with Power Query. Laquo; Discontinued features in Excel 2013. By Frédéric LE GUEN. For more information on the content being included in this update, please read the official announcement on the Power BI blog. Leave a Reply Cancel reply. Your email address will not be published. Required fields are marked *. You may use these. Except whe...
excel2013.info
Power Query - Presentation
http://www.excel2013.info/power-query
Business Intelligence for all. PowerView – a BI application. Power View – Create table. Power View – Create a chart. Power Query – Automatic update. Connection to an API with Power Query. Power query is a new tool to improve your importation of data in your spreadsheet. What is Power Query? Import without Power Query. Import with Power Query. What is Power Query? Power Query is a new add-ins for. Excel 2010 and Excel 2013. There, you select COM Add-ins. In the dropdown list and you press Go. When you imp...
SOCIAL ENGAGEMENT