software

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
quot;NEWquot; then copy this word all the way down to include all the lines that
have information.
ThanksThis partly depends on how you define quot;all lines that have informationquot;.
If all rows that contain data have a value in column A, then something
like this is one way:

Public Sub NewInColumnI()
Range(quot;I1:Iquot; amp; Range(quot;Aquot; amp; Rows.Count).End(xlUp).Row).Value = quot;NEWquot;
End Sub
In article gt;,
quot;pcorquot; gt; wrote:

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

I can only say one thing......PERFECT.
Thansk... I guess that was twoquot;JE McGimpseyquot; wrote:

gt; This partly depends on how you define quot;all lines that have informationquot;.
gt; If all rows that contain data have a value in column A, then something
gt; like this is one way:
gt;
gt; Public Sub NewInColumnI()
gt; Range(quot;I1:Iquot; amp; Range(quot;Aquot; amp; Rows.Count).End(xlUp).Row).Value = quot;NEWquot;
gt; End Sub
gt;
gt;
gt;
gt; In article gt;,
gt; quot;pcorquot; gt; wrote:
gt;
gt; gt; Hi All
gt; gt; Need a hand please...
gt; gt; Will someone tell/show me how to write a macro that will do the following\
gt; gt; In EXCEL I want the macro to: go to I1(Col I at the very top). Then type in
gt; gt; the words
gt; gt; quot;NEWquot; then copy this word all the way down to include all the lines that
gt; gt; have information.
gt; gt; Thanks
gt;