Good morning, I with defime LastMonth as an integer and comprae the month(cell value) to the lastmonth I would however attach a sample file with...
Hi Joanna, You like many others make the serious mistak of adding sample files with external links like this one to you farsightingconsultingltd.sh...
Use Cells(I, 27).Text instead
You can take this up in the conditional formatting too, It itá a non-working day (I am assuming a Holiday) then you give it the color you want.
Hi Roger, you should keep in mind when attaching a file with data links you make sure they work for others. We do not have access to the connection...
Hi Riny, I'm just curious. When I expand the Formula bar to see a large formula it always 'remembers' the last size. I have one file where the f...
Just an update: time was out of my hands so could not work on my idea. Will try to work on it and update ASAP
If I remember correctly there is a limit around the 10000 rows to display it in the dropdown list Thta has nothing to do with your question but jus...
I suggest you take a look here Find merged cells - Microsoft Support A little advice: AVOID merged cells if you can it's a P in the A when ...
I added a conditional formatting rule the explanation is in the other worksheet next to the list Holidays Hope this is what you're looking for
I suggest you name the holidays you entered as named range and do a lookup using the value in row 5 and if found then that column is a Holiday
First of all the file you sent me has a for me unreachable link (C:VolumesOMS_DIRDirectoryBackupMarch2023 2 copy.xlsx) so the value in column O in the...
I'd like to help but cannot download the file, just see text and pictures but I need the file to help. Login to dropbox is denied
Have you solved it?
Hi, I hope this makes sense: Sub sendmultiple() Const mailTemplate As String = "C:Usersbarnes22AppDataRoamingMicrosoftTemplatesVOC.oft" Const m...