Search results

As common with Excel no response from the OP.

Quick question as I'm about to go out for the day. Are you ignoring leap years? Other than that unclear as to the problem as it appears to be simple arithmetic with a few tests for dates, shouldn't be too difficult in code. Brian

Doc You make appear that our parents deliberately lied to us, well I'm sure mine didn't. My parents would have been brainwashed just as the previous generations, and after rudimentary education both left school at 13 to spend the rest of their lives working long and hard with little or no time...

As I understand it Tom does not want to run any code if he selects the wrong shortcut. Having determined the active sheet name he should compare this with the name stored in the macro and act appropriately, ie run the macro or issue a message and exit. I never ran against Activesheet but always...

I agree and that is a comment I have made in a previous thread, it also applies to the Brits in the med area, and does not effect peoples perceptions. Brian

Most of the Americans I have come across outside of America, whether in Europe or Asia have been loud and arrogant, my daughter who holidays in Central America says the same, those I have met in the US. have been polite welcoming and generous. Brian

I have suggested that instead of going to Spain each year Col goes to the US , hires a car or motorbike and meets some Americans , those you meet in America are very different to those you meet "doing Europe " or elsewhere come to that, it's like judging Brits by those you meet in the bars of...

I no longer have Access to try but you should be able to build Or codetails is null at the end of your criteria or maybe start with CoDetails is Null or Brian

Just looking at the logic and not any wider issues shouldn't you be using Date() rather than Now(), or does the time come into the thinking? Brian

You could write code to loop through the date range using weekday to identify the days you require. There might be a smart way to do it from just knowing the first day in the range. Brian

Like does not return nulls, you will have to check for them.

Oh, I don't think we need to start a second gun thread, the existing one has already shown that the Americans don't trust their government to not enslave them, and that many , if not most, don't understand the second amendment. Brian

As I was reading this thread whilst having breakfast the news was on the TV ,( who says blokes can't multitask :D ) there was a news item about Obama visiting New Orleans , it painted a different picture to that by Col. Of course we can't possibly know the truth from thousands of miles away. Brian

When you click on Queries to see the list of questions, top left there is a button label New Thread, clik on that to start a new thread. Brian

I did say that, and also that I thought that it could be modified, try replacing sht by Sheets("yoursheetname").Range("A:C") or ("A1:C9") or whatever BTW it is normal to Dim lastrow as Long Brian

I've also seen this LastRow = sht.cells.Find("*",searchorder:=xlbyrows,searchdirection:=xlPrevious).Row Where sht is the reference to the worksheet, I'm sure that it can be modified for a range but have not done it. Brian

Namliam's code only finds the last row with data in column A if my memory is correct, it been a long time. A Google search does reveal many hits, this one also lists the pros and cons. http://www.rondebruin.nl/win/s9/win005.htm Brian Apologies to Namliam I didn't read his code carefully...

I really don't see how this fits into the discussion on discrimination. Brian

Pardon Brian

If you count the number of records in each group , with say Count(Sup_STAT_DTC) , in Q1 then in Q2 select only where this is >1 then you will get only the records with duplicates. Brian