I still can't get it to work properly. It keeps saying the date can't be
found, even though it is there.

Can you post the exact code I need?

My data looks like this:

A B C D E
1 16-Aug 17-Aug 18-Aug 19-Aug 20-Aug
2 data data data data data



""Peter Huang" [MSFT]" wrote:

Hi Jason,

If you want to find in the Row 1, you can use the syntax below to get the
Row 1.
Dim o As Range
Set o = Sheet1.Rows(1)

And then you can use Macro provided by Gord.

If you have any concern, please feel free to let me know.

Best regards,

Peter Huang

Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.