Thread: Macro to Return Row, then move over and select up to
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Karin Karin is offline
external usenet poster
  
Posts: 125
Default Macro to Return Row, then move over and select up to
Hi, (Excel 2003) I'm writing a macro to format a report. I want to Find
"Grand Total" and then move over to column K, highlight up to K3 (absolute)
and fill with gray. How do I do that? Thank you. (FYI: The length of the
report will change, and Ctrl End actually goes past the end of the report.)
Reply With QuoteReply With Quote