LinkBack URL
About LinkBacks
Works for me.
Run the macro and search for time.
EDIT: Confidential file removed
Works for me.
Run the macro and search for time.
EDIT: Confidential file removed
Last edited by Andy Pope; 06-11-2008 at 07:55 AM.
Hi Andy,
Sorry it doesn't work for me. When I run the nmacro and search for time it takes me to a line within the macro. Can you advise further, please.
Kind regards
Keith
It would help you posted the line in the macro it takes you to.Originally Posted by Keith Burgess
It works fine. The code finds any row where a cell contains "time2 and highlights it.
Hope that helps.
RoyUK
--------
For Excel Tips & Solutions, free examples and tutorials why not check out my web site
Free DataBaseForm example
Hi Guys,
Below is the line in the macro it takes me to when I run the macro and ask it to search for time. I am using MS Office Excel 2003?
Hope this helps.
SearchRng.Offset(1).Resize(SearchRng.Rows.Count).EntireRow.Interior.ColorIndex = xlNone
Kind regards
Keith
Last edited by royUK; 06-11-2008 at 04:00 AM.
Is the sheet you are searching active, i.e. the one open?
Hi Roy,
Many thanks for your reply. Yes! the sheet is active and open in fact it is the only worksheet in the workbook.
Kind regards
Keith
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks