Thread: Find Date in range and scroll down to next row
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
tomjoe tomjoe is offline
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?
Reply With QuoteReply With Quote