post

Hi, I have replied to a thread i started last week, and it hasn't been posted, i did the first one about 11am AEST +10GMT and it worked fine, bu then i replied to another quote, i pressed submit, and had a meeting to go to. I came out of the meeting an hour ago and checked the thread and the...

Hi, Can some body help me to split the excel value. I have a list of address's in one excel and I want to split it into the normal address format. for eg. my current value is something like this, <tbody> Abraham , XXX HOUSE, yyyy POST PLACE 689121 </tbody> I want to split it like...

Hi I'm stuck. I have a table where I want to read the dates depending on country and row type. THEN - populate this on another table under the relevant date with a code. So here's my table I am reading from (sorry I can't paste it as a table for some reason?)...

as an old grey head approaching 70, I have decided to learn VBA. I have been grateful to this forum particularly in that Journey. Please forgive any error in protocols or procedures. I have a Workbook which has a BankRec Sheet which has cheque numbers in AA:DY with headings (Week1 etc) in Row 2...

I'm essentially new to Mr. Excel and am trying to post a question about an error I'm getting In what should be a simple line of code. Not sure where to begin -seems I am unable to post net threads in most forums. If you could please let me know where to begin.... Thanks in advance

Hi I am trying to take data entered from say B3:D3 and use a formula so that it will post into every 2nd cell on a different worksheet. So it would post to C7, E7, G7 etc Is this possible Thanks Sinead:)

Hello there, This might be a really dumb question, if it is, just tell me it is! As part of my job, I have to get the time and distance between two post codes and with over 200 to do, it's bit of laborious process! I used to literally copy and paste every post code into Google, I've improved...

Hello, If someone has helped out with a problem and given the solution, how do you post a Thanks or a Like on their answer? I see that some people have received Thanks or Likes from people but I can't seem to figure out how the heck the person did it. Jenny

Hi all, I'm working on a VBA Code which currently allows to display all items of the Listbox from my Userform, I would like to post a picture to describe what I'm writing, but don't succeed to paste any picture :confused:from my laptop. Any ideas ?

This post is somewhat similar to a previous post which I have not gotten a response yet. Since then I have figured out answers to my questions with the exception of this one. If I am wrong for doing this please let me know. Thank You Brief explanation:That being said, I have a workbook that when...

I have created this formula to look at data that is coming from an AS400, to sum up, production hours. I am getting a value error when I start using the if statement in the formula. Without IF in ReportB4...

When I first visit the forum, I see the article list. Then suddenly I am redirected to the login screen, and I can only return to the article list after about fifteen seconds. Ugh. Then often I'll answer a question, spending ten minutes, taking screenshots, etc. I click on Post Quick Reply or...

How do i post an xls file? thanks

Hi, Thanks in advance. Simple question, I see people post replies and have a Code: box with nicely formated VBA code (All tabs in) When I post it loses all its formatting. How do I post with a Code: Box? Thanks for replying.

Hello...I have downloaded VBHTML Maker so I can post code so it's easier to read, but I just saw that it does NOT work with Excel 64 bit (which I have on my machine). Is there another way I can easily post code to the forum without doing a straight copy/paste, thus making it hard to read...

I have written a Sub that I would like to post with some questions. I also have a workbook that calls that Sub to demonstrate how it works and illustrate the questions. Since attachments are not allowed, I would upload it to Dropbox and post the link. But what's the best way to do that? I...

Hello All, I referred to the earlier post from 2004 but didn't post my queries due to aging of the thread but my queries as same, so please help . Earlier Post : https://www.mrexcel.com/forum/excel-questions/67250-counting-number-times-cell-value-changes.html I tried using the VBA given in...

Hi, I tired to post HTML code here to ask help. But I don't how to post the HMTL code here. Please assist.

Hi, I am trying to replicate the behavior of an .xlsm file I have. When I open it, I have a custom tab showing. However, if I go into the "customize ribbon" section, it's not there. There also doesn't seem to be any macro running on the workbook open event. Also looked in quick access toolbars...

I looked and could not find how to edit an existing post, in hopes of making it read better, but cannot find that option. If you could point out where this button is or how to close out the post so I can retry would be appreciated. Much thanks.