| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
IF function (copy cell) in a macro
How do I change the code so it will copy the content of column B to column C?
A B C Dog 2007-10-22 Cat 2008-02-02 2008-02-02 Cat 2008-02-11 Here are the codes: Dim LastRow As Long Dim wks As Worksheet Set wks = ActiveSheet With wks LastRow = .Cells(.Rows.Count, "A").End(xlUp).Row ..Range("K2:K" & LastRow).Formula _ = "= IF(A2=""Cat"", B2, "" "")" End With Thanks, Aline -- Aline |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Is there a macro i can use to copy a cell +1 | Excel Discussion (Misc queries) | |||
| Macro copy function | Excel Discussion (Misc queries) | |||
| copy name from active sheet to cell - using macro or function | Excel Worksheet Functions | |||
| Using macro to copy a part of a cell content to next cell | Excel Discussion (Misc queries) | |||
| If than copy function / Macro | Excel Worksheet Functions | |||
Threaded Mode
