Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can someone help me with this marco
Not familiar with marcos can someone tell me what I did wrong. Or even better
and help make it right. Sub DeleteSemester() Dim lr As Long, x As Long lr = ActiveSheet.Cells(Rows.Count, 1).End(xlUp).Row x = lr - 5 Range("BI2:BO26").Copy Cells(200, BI) ActiveSheet.Rows(x & ":" & lr - 1).Delete Range("BI195:BJ195").Copy Cells(2, Y) Range("BI195:BJ195").Copy Cells(2, BI) Range("BI195:BJ195").Delete Range("BM195:BO195").Copy Cells(2, AK) Range("BM195:BO195").Copy Cells(2, BM) Range("BM195:BO195").Delete End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Marco | Excel Programming | |||
Marco Help | Excel Programming | |||
Marco Help | Excel Discussion (Misc queries) | |||
help me with this marco | Excel Programming | |||
marco | Excel Programming |