forum

Good afternoon - can someone please advise as to how I can do this? Regards Pete

Hello great guys from MrExcel, I have been lurking this forum forum for a few months as it has always been very very helpful. But today I have a problem that I can't get to solve. I have a list of addresses in column A, that aren't quite well structured. And I need to get their post codes in...

Hi everyone! First of all, I appreciate the help! I amworking on a project for work and have never used VBA before so everything I amlearning is from these forum and YouTube videos. We have a large spreadsheetfor work where anyone can put a PO request in. These requests include theindividuals...

Hello, I've been searching the forum to help me with my problem. I've managed to put a code together using the tips I have found on the forum. However, if I continue working the message keeps popping up. How do I make it stop? Thanks in advance. Private Sub Worksheet_Change(ByVal Target As...

Hello Friends! It can happen to everyone from time to time. When we post questions, help requests etc, some forum members are replaying with no answer or the problem is just above their skills. They are asking for some explenations and the post is getting more and more replays with no...

Hi Forum I would like to change a few cells that appear as negative numbers to positive numbers.

Hello all! I searched the forum for an answer to my question couldn't find an answer that worked for me but maybe I did not search properly. I am having a hard time creating a scatter chart that works for my data. Perhaps I should choose a different chart type but my boss has specifically...

Hi, I no longer receive email notifications, is this just my problem? Would appreciate help Thanks A

Is there a way to assign a unique key to records, after they have been sorted? I have code that currently reads the value of a cell in the last row and adds 1 to it. The issue is, I have to sort the same sheet, which will inevitably cause the numbers to become non-sequential. I was thinking...

Hello all Is there a difference or efficient way to find the last data in a column of the two. In the Forum I see both methods used. Sheets("Sheet1").Range("A" & Rows.Count).End(xlUp).Row Sheets("Sheet1").cells(Rows.Count, 1).End(xlUp).row

Please, if anyone can help after searching the entire forum ... I'm looking for a formula to find the least common numbers in range (in multiple columns!!!). The table below is an example how I found most common numbers and I would like to see how can I find the least common numbers in a similar...

Hello; Because of the CODE and HTML tags used for posting codes in the forum, the VBA code i have posted in the link below is not the same as i have posted. https://www.mrexcel.com/forum/excel-questions/1033472-extract-text-span-element-xml.html I tried to turn OFF and ON the tags but...

I already attempted making one using activeX and had a glitch (issue is in another forum thread), im just wondering if there is another way to go about it.

Hi, I'm new to this forum and signed up in the hope someone could help me with something I've been trying to figure out for hours without success, including going through the forum here, searching for IFBlank - maybe that's what I don't even need. My data set looks like below with Q1_round1...

Good Day All, Working on a custom staff schedule. I select the start and end time and it calculates the time worked using the MOD formula. In the time list I have also added VAC to reflect time off. However as it is obviously not a number or time, its returning the #Value !. <img...

Greetings, Seek for help to teach me how can I upload the Excel attachment in this forum? Thanking in advance. Wiz Lee

Hi Is there a Mac add in to copy cells, allowing HTML to be generated so post in this forum for others to see how to help solve my challanges

Hi How can i get a email address of selected name or names from outlook in excel through coding? <tbody> Contact Email ID ABC </tbody> I know this thread would be there in forum but i am not able to find it. Pleas help. Regards Meetz

Hi All. I want to fill Combobox with For Next, and here's an example of my code for i = 1 to 5 ComboBox1.additem i next i somehow, the output is not what I want it to be. should be 1,2,3,4,5 instead of 5 Can someone help me Thank you in advance sorry if thread like this, ever discussed in...

Hey, I'm trying to figure out how to upload an image from my computer to a forum. Any help. Thanks