Don’t have an account yet? Register yourself now and be a part of our community!
Looked like a question. You said that your code didn't work.
I was just placing my ideas not asking.
Please help me on below code. When I run this code I haven't get any error, but at the same time not getting any result too.
'If date in coloum C is less than today and cell in coloum E is blank (in the same row), then fill that blank cell with "my text" in coloum E.
Dim rng As Range
Dim sh As Worksheet
Dim lastrow As Long
lastrow = Range("C" & Rows.Count).End(xlUp).Row
Set sh = ThisWorkbook.Worksheets("Entry Page")
'Set the range in column C you want to loop through
Set rng = sh.Range("C2" & lastrow)
With Worksheets("Entry Page")
For Each Cell In rng
'test if cell is empty
If Cell.Value < Date And Cell.Offset(0, 2) = "" Then
'write to adjacent cell
Cell.Offset(0, 2).Value = "My Text"
You should ask your question in the VBA Forum. Read the Forum Rules first and use Code Tags
Hello Roy,I tried to start a conversation with you but it was not possible.Maybe could you please delete the excel file I shared here Dynamic Urserform, I will upload another file.Thank you
If you will find a few minutes can you change/tell me what I should change in code ?Use Macro on Teams/Sharepoint/Onedrive
Don't ask questions here, post it in the relevant Forum
Hi...need your help with multiple dependent combobox. I have 3 combobox and if any one of the 3 is selected based of the selection the other 2 should get refreshed.
I'm re-writing the web site at the moment. Message me here for now
Hello. I tried to send you a message in the contact section of your website but it doesn't work
I know what XLOOKUP is, I just wanted to be sure that you had Microsoft 365
Ah! now I understand about the code button (Spinning my noob propeller). Xlookup is new and comes with Office 360.
Hi Roy, I read the rules (twice) but obviously must be missing something; my apologies. I'll read them again and see if I can work out what I'm missing. Thank you for your time and the solutions to provide, they make great reading, and it really helps a self taught noob like me.
I'm new to this website. I had a question on VBA and created a thread which I posted. It is basically autofiltering the data pivot tables to display only 6 months at a time. I hope you could assist?
Please help me again if you have some time Compare row of data from different workbooks using another workbook - excel vba
The Thread is not locked, you have a reply
Its seems my thread is disable, and under moderator approval.
Pls can you unlock.
It doesn't look to be locked to me.
I saw this note:
Newly created posts will remain inaccessible for others until approved by a moderator.
I think it is waiting for admin to confirm payment has been received.
Okay many thanks and problem is solved.
Hello sir!Can you help me with this?Insert cell text adjacent to checkbox.caption cell text
About the Op here COPY AND PASTE
( The original macro comes from the first link below )
This OP is a very , very unique case. I never met anyone like him, and I have a reputation of getting through to the poor communicators better than most.
He had an original solution, which worked. He missed that, and went on to go around in circles for a few weeks at various duplicated cross posts.
This is a typical example of how things often go with this OP…..
He appears to understand or read almost nothing of what is ever posted for him..
He looks in a reply for a macro. Sometimes he runs it, sometimes he doesn’t, sometimes he copies it wrong.
If he does not get exactly what he wants, ( what he wants is something which no one can ever know ), he posts some gibberish. Then,
He looks in a reply for a macro. Sometimes he runs it, sometimes doesn’t, sometimes he copies it wrong.
If he does not get exactly what he wants, ( which is what no one can ever know ), he posts some gibberish. Then,
If he does not get exactly what he wants, ( which is what noone can ever know ), he posts some gibberish. Then,
Eventually, whether he gets what he wants or not, there comes a canned reply, which may or may not be the last post, of the form ..“Thx for great help. Problem Solved Sir, Have a great day“…
( Currently, his main issue is that he cannot understand anything at all about the difference between an Excel File and an Text File and that is causing havoc with multiple cross duplicated posts everywhere. )
A very unique case. I sometimes wonder if he is real , or if he is some higher being, having been sent to „test“ us…
These are the cross post I have seen so far. There are probably a few more.
COPY AND PASTE
Thanks for letting me know. I have issued a final warning and will ban the OP if necessary. Usually, regular helpers will soon learn to ignore someone like this.
In this case, the biggest problem is the communication and the lack of him making any attempt to read and/ or understand what we write. I would favour a temporarily ban in this case, just my opinion. I temporarily banned him a few times. That helped get the message across. When he came back there was an improvement, all be it very small. Then he regressed. So I just banned him again, temporarily.
I think it is almost always better the devil you know. Just my opinion. If you ban permanently he will just come back in other names here and elsewhere to plague us all.
I know of over a dozen of his many forum names, mostly used where I am not, like here.
( I know also all his real identity and personal details in the meantime…. )
I recall we had one like this in the early days of Ozgrid. We actually didn't ban him but made his posts invisible, I don't know whether this is still doable.
I am not familiar with your current forum software. I have no idea. The previous vBulletin has a few easy options to handle these things, banning different periods, soft deleting – which I guess is the “Invisible” type option, to temporarily block the view of a post.
We no longer use vBulletin but I don't get involved with the Forum Software here
I was not aware of forum rules in the beginning and was little inconsiderate on those. I am totally new to this website and only yesterday accidentally visited the site via google search link. Really sorry for the inconvenience caused due to that. Going forward will follow the rules accurately.
I had attached a wrong file in "Hyperlink to deduct specific cell value in excel vba" before and now I have attached the correct file with Tables. Highly appreciate your assistance to sort my issue there.
This website is really helpful and user friendly! I was able to move forward with the toughest part of my project due to this site.
please accept my apologies Roy, I did read the forum rules when i joined. I shall observe them in future.
Not done intentionally.
Hi Roy. I figured that I had probably started my thread in the wrong area (VBA) , beings that my issue likely dealt with Excel settings. Actually my first statement noted this. Sorry for the injustice..I meant well.
In which case you should have asked a moderator to move it for you
Ok thanks Roy. I've never done that before as all of my previous questions have been regarding VBA. Would you mind doing that for me. I appreciate all of the help that you and your fellow moderators have given me
Thanks so much
And of course I appreciate all of the help my fellow programmers have provided
I've deleted the one with no replies. Rory is helping you with the other one.
Hello, thank you for your help. I replying to your question about why I reported on your wall. I was not looking for quicker help. I need it taken down. It breaks 0.00 % of my employers rules but my boss is pulling straws, and in going out of his way to find evidence I have done something wrong. As harmless as the thread is, I do not need anything that could possibly be used against me. And I would appreciate it if you removed this thread as well. Thank you
Did you explain this in your report. A message would have been more appropriate here.
Roy the post you closed of mine is a different code to the one posted on mr excll, plus i have removed myself from there as aliw keeps harrasing me, seems like she does it here as well. but this is a totally different question although it sounds the same.
The first one was hiding a column, this one is hiding when error happens, 2 different questions no?
so please unclose and ask aliw to stop harrasing me.
Sorry, but nobody is harassing you. If you join forums, then you agree to their rules. If you then choose to ignore those rules, the unfortunately you will be pulled up on it.
The answer is very simple: read and then abide by the rules. They are very similar from forum to forum, so it's not hard to do. Thanks.
I still want to know if you have read the Forum Rules and have any problems understanding them
Yes I have and I do understand them.
This is not a cross platform query - I will say it 100 times as code is different.
Aliw - did youe read through the code and see the differences? if you did before flanking this you would have seen the code it totally different as it come from a totally new excel spreadsheet i am busy with.
I can't compare the code because there is no link to the post provided
Hi Roy, can you remove the attachments I uploaded on this thread?
AutoFilter Multiple Sheets, Copy, New Book, Paste to Multiple Sheets
I realized that I did not remove potentially sensitive data from them. I'm happy to upload a cleaned version that is OK for public use.
OK, I don't think you can add them back
Thanks Roy. Can I just add a new reply and attach a clean version?
I've cleared them out for you. Just add a new post and I'll look at it for you. Might be later this week though
I forget to add the cross post link can you please .....
Today's post is a duplicate of yesterday's post which I locked. Have you read the rules yet and do you understand them?
The website is mine, Ozgrid is run by a team of volunteers.
I just want to say thank you for your website I downloaded the database zip file and will check it out when I have time too this week. you and your team are awesome.
Hi Roy, i added a test file. Can you assist with my query?
I have posted a thread regarding splitting files into multiple workbooks. can you please help me to find the code.
I recently posted an online thread asking to get me through a problem, can you take a look at it