Stack Exchange Network

Stack Exchange network consists of 174 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Visual Basic for Applications; a subset of Visual Basic used in all Microsoft Office applications. Consider using this tag together with the tag for the specific application in question. Good questions on VBA generally contain some code and asks for solution of specific issues. Questions asking ...

0
votes
0answers
7 views

Cannot get VBA Outlook application object to work

I'm trying to write a program that lists the members of an Outlook email distribution list. I've found that VBA seems to have objects that could make this possible, but I haven't yet been able to get ...
4
votes
3answers
187 views

Count unique value ignoring Text in range

123 562 My Data 548 K166 You 1548 123 562 100 My Data 100 I want to count unique values by ignoring text in the above shown list. For this I've tried an array formula, {=SUM(1/Countif(,,,,))} but it'...
0
votes
1answer
29 views

Converting the units and values in cells to a standard unit

I have to interpret data for scientific reports. We report the data all in the same units. However, the lab sends the data in different units. For example the lab may send the results in ug (...
0
votes
1answer
34 views

EXCEL VBA: On open update links without prompt

I have a dashboard that others will use. When it is opened I want all links to updated. Without the prompt box appearing. I can suppress the update box with the below, but will this still update the ...
0
votes
1answer
35 views

Remove double-quotation when copying from cell

Problem: While copying a cell which contains 'script' from Excel into another program, double-quotation marks ("") are added automatically instead of single-quotation mark only ("). Also, at the ...
0
votes
0answers
37 views

Count number of unique comma separated values in an entire column [duplicate]

In Excel 2016, I have a column with cells that contain comma delimited strings. I am trying to count the number of unique strings in the entire column. I know how to count the number of unique comma ...
0
votes
1answer
15 views

Make outlook add a signature based on a certain value [duplicate]

So in outlook you can select an email address in the from field for a new e-mail. I was wandering, can I make outlook add a signature based on the value in the From field. So when i send on behalf of ...
2
votes
1answer
29 views

Merge data in two excel files

I have two Excel documents with AD user information that I need to merge to gather all information. One of the documents has information about AD groups and the names of the members of these groups. ...
0
votes
0answers
22 views

Checking a target cell depending on the value in another cell on the same row

I am trying to validate a cell input with two regular expression functions. The idea is if the value in column C is "L" then use one of the two functions. The problem is the message boxes are printed ...
0
votes
0answers
37 views

Print to PDF macro mysteriously stopped working

Since approximately one week ago, my print macro stopped working. Here is what it looks like: Function Create_PDF(Myvar As Object, FixedFilePathName As String, _ OverwriteIfFileExist As Boolean, ...
0
votes
0answers
27 views

VBA error on making different list validation depending on a cell`s value

I am trying to validate a specific column which uses a List validation. If (“Table (T)/ Line (L)” column = “L”) use a specific table, if (“Table (T)/ Line (L)” column = “t”) use another table. I use ...
1
vote
1answer
40 views

Calculating differences between two sheets (efficiency issue) [on hold]

Current setup to compare history on AR Financial Data: -Two excel sheets with identical headers Range: A1 to AL250,000 -On one of the sheets, we added 13 Columns, which have equations doing ...
0
votes
1answer
53 views

How can I count unique selections from multiple selections in a drop down list (Excel)

I would like to count the number of unique selections from a column that contains multiple selections from a drop down list. For example, column B3 contains, Monday, Tuesday, Wednesday The count ...
3
votes
1answer
36 views

Excel Outlook VBA Save Unread Emails to a Network Folder

I was able to build an Outlook VBA script in Excel that would save down the just the attachments of "Unread" messages in a specific Outlook subfolder to a folder on my network and then mark the ...
2
votes
2answers
31 views

Get file tags in VBA using variable file name

I'm using VBA in Excel to loop through a series of files and decide which ones to import. I'd like to decide which files to import using something like the file's tags, so that I don't need to open ...

15 30 50 per page