Hello All,
I would like to clear contents of a cell range whose row count is dynamic.
this is the code i have written:
Dim lastrow As Integer
'count no of filled rows first.
Set sht = Worksheets("LTE_Best Server by RSRP")
lastrow = sht.Cells(sht.Rows.Count, 2).End(xlUp).Row
Worksheets("LTE_Best Server by RSRP").Range("A2", "B" & lastrow).Select
Selection.ClearContents
but the above code is not working,
any advice would be appreciated.
Thanks
Syed
I would like to clear contents of a cell range whose row count is dynamic.
this is the code i have written:
Dim lastrow As Integer
'count no of filled rows first.
Set sht = Worksheets("LTE_Best Server by RSRP")
lastrow = sht.Cells(sht.Rows.Count, 2).End(xlUp).Row
Worksheets("LTE_Best Server by RSRP").Range("A2", "B" & lastrow).Select
Selection.ClearContents
but the above code is not working,
any advice would be appreciated.
Thanks
Syed