This is a typical case of users seeing code they found and using it without understanding what they're doing. The most important thing I always tel...
You could (should) mention the Office version in your profile
Have you taken a look
Not without the data. The way it's now, it works at least the V2 has some more features You have to copy the vba contents from the sheet as well...
Hi Sherry, I went a little further I have not added comments explaining the code but this will do the job I only don't understand why you hav...
I took a look, just dimensioned the two missing variables and it works. I just made some minor changes to the VBA code and it still works
First of all the macro throws an error the moment you run it because you have not dimensiond all the variables. Another thing is that when you are ...
Good day, The code does not tell much seeing you have two conditions I suggest you attach the file (non sensitive data) with the macro to look at. ...
You should also include something to clear the area before a new one
See, when you try a little longe you get it. one more thing, if you want to make sure that the date text is your own language do the following: ( ...
And what's the maximum value you want?
Good to hear, Yes I have the VBA code for any variable day and more ' We can generalize this to holidays that are defined as the Nth Day of...
I understand your problem but, it works. It's a question of reading carefully to understand what is explaind in the link Here's a file with the ...
And so simple, I knew it must be something like that. Great, thanks.
Ciao Maurizio, Take a look here. Mother's day laike many other datesis a variable date, check this link How to calculate dates for holidays -...