Excel macro required

[Guest]

Hi All
Need a hand please...
Will someone tell/show me how to write a macro that will do the following\
In EXCEL I want the macro to: go to I1(Col I at the very top). Then type in
the words
"NEW" then copy this word all the way down to include all the lines that
have information.
Thanks

 

[JE McGimpsey]

This partly depends on how you define "all lines that have information".
If all rows that contain data have a value in column A, then something
like this is one way:

Public Sub NewInColumnI()
Range("I1:I" & Range("A" & Rows.Count).End(xlUp).Row).Value = "NEW"
End Sub

 

[Guest]

I can only say one thing......PERFECT.
Thansk... I guess that was two