Excel macro required

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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
 
Back
Top