Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro Help In Excel | Excel Discussion (Misc queries) | |||
Closing File Error | Excel Discussion (Misc queries) | |||
Macro to close excel | Excel Discussion (Misc queries) | |||
passing arguments from an excel macro to a word macro | Excel Discussion (Misc queries) | |||
Excel macro that opens new MS Word file and pastes data as a pictu | Excel Worksheet Functions |