Hi Forum Friends
I need to find ALL occurrences of a date on a worksheet,
but could not find a macro on our forum.
I found this macro on the web. Unfortunately I can't find
out why it does work.
Many thanks for your correction.
Please Login or Register to view this content.
Al
Last edited by aljanga; 12-09-2009 at 10:09 AM.
A filter would work to find all instances of a specified date, if you could supply some sort of working sample somebody may be able to help you better.
Hi there,
If its just at a glance...maybe something easy on the eye such as conditional formatting may do the trick. Just set your formatting for a specific date, change the cell colour and then copy the formatting to the whole worksheet.
HTH
Hey thompsy121
try something like..
Please Login or Register to view this content.
Hi Pike
Thanks for your code.
Dim r As Range, ff $ - gives a Compile error, which I cannot fix.
To clarify; the dates I'm looking for are in Columns P and every column 13 offset to the right. I want to inspect the calculations that contain the date i.e. the find has to stop on each date found. I have a sample sheet with dates on p48, p94, x92, bl148 etc. but do not know how to attach it to this post.
Regards
Al
matie..try changing ff$ to ff
gota go will look in later
Hi aljanga
tested this one
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
,
Bookmarks