LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 21
Default Find Date in range and scroll down to next row

I have a sheet(1) frozen in A4.
Want a code to do the following:

Sheet(1)
Range(k:k)
If date = today
then select row
font.color. index = 15
scroll down to next row (next row and below visible).

How do I solve?
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Find Last cell in Range when range is date format default105 Excel Discussion (Misc queries) 5 July 7th 09 03:11 PM
Find a date in a range Jorge Ribeiro Excel Programming 2 February 20th 09 11:36 AM
Find within Date Range MrRJ Excel Discussion (Misc queries) 4 November 24th 08 06:56 PM
How to find date in a range? hideki[_21_] Excel Programming 1 November 26th 05 04:16 AM
Find date and copy range based on that date avzundert Excel Programming 2 November 25th 04 10:31 AM


All times are GMT +1. The time now is 11:05 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"