Excel macro required
 

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

Excel macro required
 

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



In article ,
"pcor" wrote:

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

Excel macro required
 

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


"JE McGimpsey" wrote:

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



In article ,
"pcor" wrote:

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