instance

Hello, How can select a range of cells and apply a format to it using VBA? For instance, let's say I want to take range B12 to D12 and remove all borders it has and then apply the border only to the top and bottom of the cell? In the code, I need to specify that the row is a variable. My...

Hi all, I have a pivot table. Below is a snap picture from it. What I need, is an e-mail to be sent if a unique date (for instance 2017-12-12) have more than two equal times (for instance 13:45). If not possible, I would at least need to have a color indicator that highlights those rows...

Hi guys and gals. So I am having trouble coming up with a solution to my problem. The scenario I have is an auto populating form based on one key cell. I select the serial number and the rest of the form fills out based on that selection, all of this work fine, until I get to the point that I...

Below code works perfectly: Sub ExportToPowerPoint() 'early binding Dim ppApp As PowerPoint.Application Dim ppPres As PowerPoint.Presentation Dim ppSlide As PowerPoint.Slide Dim SlideCount As Long ' Reference instance of PowerPoint On Error Resume Next ' Check whether PowerPoint is running...

I haven't worked with pivot tables since Excel97 (?) so aside from losing my feel for how to solve this issue, I'm also not sure if I had ever done anything like this before. Here's the issue... This is an abbreviated mockup of the data: (sorry, I can't post attachments) <tbody>...

I have been using excel 2016 for over a year. Recently, it started opening in separate instances. Therefore, none of my macros will run as they cannot look against separate instances. How can I force it to go back to opening in the same instance. Just to clarify, I am not speaking of...

I have data laid out as below, I need a formula that will count how many cells contain data please. Excel 2010 <colgroup><col style="width: 25pxpx" https:="" www.mrexcel.com="" forum="" usertag.php?do="list&action=hash&hash=DAE7F5""...

Hi - have a new laptop and after the reinstall of Microsoft Office... when I open my excel files through Windows Explorer they open in separate instances. Every file opens in a new instance. they uses to open in the same instance. I can get them to open in the same instance by opening one file...

Hi there! I have a series of content data (blog posts, social media posts, etc) that has been tagged according to content. For instance, for each blog post, it is categorized as one or more of the following: Wineries Educational/Info tips Recipes Crafts Events Seasonal Each post can have up to...

Good Morning, I have the below code Sub firstandlast() Dim FCol As Integer Dim lCol As Integer FCol = ActiveSheet.Rows(1).Find(What = "Store Number (Location)", LookAt:=xlWhole, SearchDirection:=xlNext, MatchCase:=False).Column lCol = ActiveSheet.Rows(1).Find(What = "Store Number"...

Good Morning. I have a sheet with three columns (well more but only three are relevant) Col A is Task Col B is Staff ID Col C is competency level (1-3) Depending on the task picked the result can be from 0 rows to 5000+ This data is extracted via macro from a larger sheet with multiple...

Hi, I am running into a strange problem and I haven't been able to find a suitable solution to it. I have a macro which I am running a text-to-columns on a column filled names and ID's sandwiched together like this: 465E10^JONES, JOHN. The text to columns work fine with the consistent ^...

Friends... I query some data from a URL via Excel, and observed incorrect values being returned on occasion... Correct: On an instance browser shows 872,1830.8,1832.95,1829,1832.35,3711 at the target url And excel retrieves 872,1830.8,1832.95,1829,1832.35,3711 Incorrect: Another...

I’m sure this is possible but I just cannot figure it out. In a workbook I have several worksheets. In these worksheets the same range (for instance B2 to F10) is filled with values. Let’s say numbers from 1 to 9. I need to create a new worksheet that collects, in the same range, the value if...

I have the following class event such that if another workbook opens up then it opens up a new instance in excel. However, some of the documents we use have a notification that asks the user if they want to open as read only or not on open. The problem is when one of these documents is open my...

Hello people In my worksheet I'm looking to delete duplicates found in Column A. I'm finding that with the delete duplicate option it removes all but the first instance by default. Is there a way of reversing this so only the last instance is kept? Thanks in advance.

Hello, I've posted this question on Ozgrid because I cant upload my file to this site and screen shots dont help in this instance: Need help with Vlookup not working The question is: Can someone please take a look at the attached file to see if you can figure out why the Vlookup in column...

Hi all, I want to put a sum formula in a cell but I want my formula to depend on the value of another cell. So for instance: A regular sum formula with relative reference looks like this: ActiveCell.FormulaR1C1 = "=SUM(R[-2]C:R[-1]C)" However, I want to change the -2 value that I colored...

Hi, I have a vb script on various users computers which links to an excel workbook as read only. On open this workbook creates an ado recordset and connection object. Through various tools inside the workbook the macros will connect to an access database and read or write to it and then close...

Hi there, I'm trying to build a model that will modify the cell references dynamically. I tried to play around with this manually and did some searching and could not find what I was after. Basically what I'm trying to do is if I'm for instance trying to calculate the average of the last 150...