find date in range

**fryboy** · 10-03-2009, 11:09 PM

I have a macro for a fitness worksheet but everytime I run the macro it fails when searching for a date. It works by searching the date entered by the user against range "G4:L100" then will paste the user values below that date. Here is the code for the searching and copying of the cells: The different font is where I believe the problem is.

Please Login or Register  to view this content.

The date is entered as dd/mm/yyyy, then searched as a string but the macro will not find the date.

Is this code correct? Or is something missing. Thank you for your help in advance.

**Simon Lloyd** · 10-03-2009, 11:46 PM

This seemed to work for me, if it doesnt't work for you please supply a workbook so we can see what its supposed to be doing!

Please Login or Register  to view this content.

**fryboy** · 10-04-2009, 02:04 AM

I found this on the web and have tried to get it working but I do not know enough code to understand why it won't find the date. Thank you for your help and quick response.

**DonkeyOte** · 10-04-2009, 02:23 AM

In your sample file the date entered in B28 is 4th October 2009 - this is not within the date values of the table to the right - ie it would appear to be a date entry issue (using correct entry format)

**fryboy** · 10-04-2009, 04:28 PM

It will work with the first date, 04/10/2009. If you try any of the other values in the right side table the final part of the module will tell you the date you entered is not found. If you change the date to the number format to make sure the values are the same it will still not find the date.