"jenny_gurl" wrote
in message ...

ok this is like one hell of a situation..

i want a code such that when an entire row is selected and colored
green, after it is colored, a particular cell in that row gets the
value "1"

what i mean is for eg, if i select row 9 and color it green, then "1"
should automatically be entered in Cell "J9". And when i select Row20
and color it green, J20 becomes "1"
Waht i basically need is for the cell in column "J" of the selected row
to change its value to "1"........ Can this be done! I basically use
this at work to both track the day's job as well as to sort.. and
everytime i color a row i need to manually enter the "1"........

somebody help!!!!!!!!!!!!!!!
anyone with the code pls email me if possible at
' ((mailto: )


--
jenny_gurl
------------------------------------------------------------------------
jenny_gurl's Profile:
http://www.excelforum.com/member.php...o&userid=27504
View this thread: http://www.excelforum.com/showthread...hreadid=470179


another alternative:
Copy/paste the accompanying macro to your personal workbook and assign it to
a custom toolbar button - clicking it turns entire row your currently in to
bright green and assigns that row's column:J to 1

Sub make_row_green()
With ActiveCell.EntireRow.Interior
.ColorIndex = 4 'bright green
.Pattern = xlSolid
End With
Range("J" & ActiveCell.Row).Value = 1
End Sub

-- jefgorbach at aol