Thread: Identify Current Row for ActiveCell
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jim Thomlinson[_3_] Jim Thomlinson[_3_] is offline
external usenet poster
  
Posts: 983
Default Identify Current Row for ActiveCell
Why select...

ActiveCell.EntireRow.ClearContents

HTH

"COL H" wrote:

I am in need of a sample VB code for Excel that will allow me to identify the
current row for the ActiveCell. Once I have the active row - I will
"Selection.ClearContents" the entire row.

Thanks for any help you can provide.

--
Regards

Mark H
Reply With QuoteReply With Quote