Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Sub DeleteSemester()
Range("N1:AR100").Cut Cells(305, "N") Dim lr As Long, x As Long lr = ActiveSheet.Cells(Rows.Count, 1).End(xlUp).Row x = lr - 5 ActiveSheet.Rows(x & ":" & lr - 1).Delete Range("N300:AR400").Cut Cells(1, "N") End Sub How can I make this marco so that if the last row in columns A:M is row 6 or less it does not run. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Marco | Excel Programming | |||
Marco Help | Excel Programming | |||
Marco Help | Excel Discussion (Misc queries) | |||
marco help | Excel Programming | |||
help me with this marco | Excel Programming |