I have been working on an excel macro and have come across an issue that doesn't make sense to me. I have on two of my sheets, (Sheets("Printing Sheet") and She
I downloaded a macro from Get Digital Help: Sub AddText() Dim Lrow As Single Lrow = Worksheets ("Sheet 1").Range("B" & Rows.Count).End(xlUp).Row+1 Workshee
I am trying to scape data from a web table. I login to a website, which gives me access to a web table. That table contains a hyperlink column (Id) like the exa
I created a custom folder on outlook with name “MyTemplate” and inside that folder an email message with subject Auto Plan ( It is a template email
I am trying to validate the active workbook is the proper workbook from the proper folder in our shared drive. Otherwise, the user will save data and it will no
I have an Excel file with more that 5 columns where cell values are TRUE or FALSE. If the cell value in every column is TRUE then in 6th column cell enter "No c
Dear VBA and Excel Gurus, I have a series of data in one column of excel sheet and i want to identify peaks and troughs in that data set having % utilization va
I'd like to create an Excel sheet, where in one column there is a link to a website like this: Link in column A where there is a MAC add in that url that chang
How do I add an item from an Excel file to a SharePoint list? I cannot use Access as an additional step here. Within Excel 2019 I run a macro and part of it sho
TL;DR: Need macro to quickly toggle File > Options > Advanced > Reminders > Play reminder sound setting In certain meetings I need to keep Outlook r
I had my constant string defined as the cell, like this: Const LID_LIFTED As String = "A19" Everything seemed to be fine, but as I convert batch stuff from P
I am using Word Interop to calculate the number of lines present in a Table Cell. The Cell in question is shown below (Special characters enabled for clarity).
I am trying to color the cell when condition is met and valid value for package of a product is found in another column in a different sheet. There is a problem
I need to copy information from one sheet (labeled Testsheet), copy it to the next available empty row on the third sheet (Testsheet3), then rearrange the colum
I need to find the earliest & latest dates for certain table entries. A link to a diagram of the table. The premise is that every time an entry has a desire
I grabbed someone else's code and tried multiple different functions to make it fit my needs. I use a Word document for PLC reports. I'm trying to take selected
I have a code in VBA that I've always used to open Internet Explorer, copy the information on an specific website and than paste in a cell. The issue now is tha
I don't understand some parts in the following code: For i = 2 To UBound(a, 1) txt = Join$(Array(a(i, 3), a(i, 4)), Chr(2)) If Not dic.exist
The context is that I have a boatload of data dictionaries for various data bases strewn across multiple Word document files. Those files hav
Is it necessary to develop an interrupt mechanism for IDEA?