i need to find the last coulmn and in that i have to insert a label "score"
into it..

for eg , last col is L1 the in L1 the cell value s "score"

i need to do n macros

kindly help me

try something like:

Cells(1, Columns.Count).End(xlToLeft).Offset(0, 1).Value = "score"

Hope this helps
Rowan

raja wrote:
i need to find the last coulmn and in that i have to insert a label "score"
into it..

for eg , last col is L1 the in L1 the cell value s "score"

i need to do n macros

kindly help me