Search : in
By :

VB formatting of excel array by date

ilyaasam, on May 31, 2009 1:33:31 pm BST 
 Report this message to moderators

Hello,

I need help with a visual basic code in excel.
I am trying to validate rows in 2 sheets. If column 6 is a date from two days before the current date, the whole row needs to be copied to a third sheet.

the current code i'm using looks like this
If Cells(rwindex, 2) <> "" And Cells(rwindex, 6) = "" Then

Currently this copies all the rows where column 6 is blank into a third sheet.

I dont have a problem with the copying bit, but what i am trying to say is
And Cells(rwindex, 6) > today()-2 then copy...

Are there any suggestions as to how i can get this to work?

Thanks,

Configuration: Windows Vista
Firefox 3.0.10

Best answers for « VB formatting of excel array by date » in :
Verifying date format in PHP ShowVerifying date format in PHP There are several ways to check the format of a date in PHP; the simplest method is to make use regular expressions. To confirm a date format DD/MM/YYYY, where the days and/or month can be given as...
Excel tips : How to insert date in a cell ShowExcel tips : How to insert date in a cell Below are some tips on how to insert date and time in an excel cell for a specific purpose:- To insert current date, press CTRL ¯+ ;¯ in the chosen cell. To insert current time, press CTRL¯+...
Connect a database (MDB) to excel Show[VBA] Connecting a database (MDB) to excel Below is a tips of how to connect an Access database (MDB) in an application excel Add reference Microsoft DAO object librairy X.X In a general module (eg Module1) paste the code below...
Download Simply Contacts Database Show
Download Date Reminder Show
Download LiveProject Free Project Viewer ShowLiveProject is an application of visualization of file mpp free. LiveProject introduces no degradation of the file mpp during exportation in format Excel or html. With LiveProject, you will be able to print your own documents. The use of LiveProject...
Formatting - Formatting a hard drive ShowBefore trying to understand formatting, you first need to understand how a hard drive works. Many people do not distinguish low-level formatting (also called physical formatting) from high-level formatting (also called logical formatting). Even...
Ask your question Reply
They need your help