Hi All,
Below macro is working fine and deleting the data till the last row in the excel , could you please help me if the same macro can delete ony the data in a range F6:F4009
Sub testdelcells()
Windows("Chan.xlsm").Activate
Sheets("Test").Select
With ActiveSheet
.AutoFilterMode = False...