Jim,
Agreed. I used the the sample to illustrate how one could get the
row number. I accept using your solution is "more" correct but one day he
might one the row number ...!.
"Jim Thomlinson" wrote:
If the current selection includes more than one row (your code is selecting a
single cell so not a problem), then your code will clear the contents of more
than just the activecell row. This could be what COL H wants but it is not
what was asked for... Up to COL H to decide.
HTH
"Toppers" wrote:
Range("a2").Select
MsgBox ActiveCell.Row
Selection.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