hi
not sure if i understand fully your request.
what constitutes the activerow? the row with the cursor in it?

Range("A" & Activecell.row).value = "X"

this will put an X in column A of the row the cursor in it.

Regards
FSt1

"Ben" wrote:

Hi,

Can someone please help me with the VB code to put an X or an asterisk in
column A to indicate the activerow?

I'm running Excel 2003 from work and cannot utilize any downloaded add-ons.
I found several helpful posts instructing OP's how to highlight the entire
row using VB, in my case I just need a distinct mark in column A.

Thanks in advance,

Ben