Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.
Articles & Videos
Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.
I want to workshop, with a group of colleagues, some strategies to meet various objectives.
Some strategies exist and just need to be selected, and some new ones will be identified in the work…
How can I test the formatted excel values, and not the exact values?
A1 = 123.45
It appears formatted as 123
If A1 = wholenumber (Exactly) then it will be FALSE
If A1 = wholenumber (appears as F…
I need to create an Excel sheet that supervisors will be entering data into on a daily basis that will how many pieces were produced by process. These supervisors do not have any Excel experience so …
I am facing the issue while opening an Excel macro-enabled template(.xltm) file when I open from my application.
I have gone through this "http://stackoverflow.com/
I have a pc that was purchased from Dell with Office 2010 on it. I paid extra for Office 2010. It is registered and working fine. A person that was doing charity work for a church has quit the job and…
Is there a way to modify the default height of the drop-down menu boxes when using filters in Excel?
The default drop-down menus when filtering in Excel are so small that, without scrolli…
The list is one column with many rows. Many of the rows contain word, or words and numbers.
I am seeking a script that I can amend (i.e include different words if required) to be able to remove all w…
I have Excel 2010 & Excel 2016 both installed, but I need Excel 2010 as the default when I work with a file. I am using 2010 daily, but I am also evaluating Excel 2016. I am using Windows 7.
I have training complete/incomplete report in Excel that is a pivot table by Leader name and the people below that that have either complete or not complete their training.
I am wondering if th…
I think this may be a rather simple but irritating problem. I have two columns of numbers that I'm trying to make into, in the third column a ratio number. HOWEVER, while the formula I u…
in the Home tab there is a section Styles which has four boxes with different colors in there. I don't like any of them. I realize I can click one of the down-arrows and get to a bunch of different co…
Could anyone explain firstly why this code is causing excel to crash ? is it simple because the computer is so old.
Dim sws As Worksheet, dws As Worksheet
Dim lr As Long
Dear Excel Experts,
I am using Excel 2007 SP3 with Win 7 Pro (64bit) and I have noticed thatsometimes when I open an Excel Workbook the following window pops-up preventing me to work in the Workboo…
I need to get a total in cell O2.
I need to look for a not null cell in column M (starting with row 4) and where N is not null total the figures in column F (starting with row 4)
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a …
I need to search for a string in say column B, if that string exists, i need to update the cell in that same row in column D, with a value. How can i do this? I can't do it with a formula, because m…
I want to check the version details within Excel 2007. How?
I have a simple 2 column sheet in Excel. The Y axis is fine showing "count" and then showing a number scale vertically. However on the X axis, the horizontal labels show numbers 1 - 11. I want them to…
I currently control computer deployment through Desktop Authority instead of creating GP rules. I have a user that is currently using Windows 7 but has it and the software so modified it looks like W…
is there a way to disable recent documents in word 2010 and recent workbooks section in Office for entire domain users with a GPO? I know I can do this on a individual desktops via
I have just migrated from a surface 3 to a surface pro 4 using ZInstall Win Win. Moved everything really well but left me with a copy of Office Professional 2010 on the new computer that nee…
How can I loop through all files in folder and read all excel files and copy "sheet2" and copy it to Output excel file as new sheet. New sheet name will be the same as file name it copy from.
I recently installed Microsoft Office 2013 on a new computer and was disappointed to discover that Microsoft Office Picture Manager is not included in Office 2013. This article explains how to corre…
Introduction Perhaps more familiar to developers who primarily use VBScript than to developers who tend to work only with Microsoft Office and Visual Basic for Applications (VBA), the Dic…
Subodh Tiwari (Neeraj)
Kanpur University, Uttar Pradesh, India
13,960 points this week
Glyfada, Athens, Greece
9,800 points this week
crystal (strive4peace) - Microsoft MVP, Access
9,117 points this week
Joe Winograd, EE MVE
Greater Chicago Area, United States
6,798 points this week
6,616 points this week