Macro to delete data for the cells specified

[balu.vasa]

hi all,

i wrote a macro to store the output in a worksheet based on dropdown selection. if i selects one value from dropdown the macro is getting trigered and the data is getting stored in a worksheet from the 5th cell value if i selects another value from dropdown the corresponding macro is getting triggered and the output generated is getting stored in the same worksheet by overriding the first output data .my output worksheet for 2 dropdown values is same so before overiding the data i want to clear the data from worksheet which is previously their in the worksheet. wat piece of code should i include..?

wat piece of code should i include in order to clear the data before storing data in the worksheet from 5th cell


regards,
Saikumar.

[Winon]

Hello balu.vasa,

It would depend on what you have, and what the code looks like. Maybe if you could upload a sample Workbook complete with your VBA project, to take out a lot of guessing, would make it much easier for us to promptly give you a ready solution.

[balu.vasa]

hi ,

iam unable to load the file

he is my logic
Sub plan1()
Dim wb3 As Workbook
Dim wksplan As Worksheet
Dim sh, sh1, sh2 As String
Dim count, i, j, k As Integer
count = 0
Set wb3 = Workbooks.Open("C:\Users\SONY-VAIO\Desktop\tracker\Jan.xlsx", True, True)
Set wksplan = wb3.Sheets(1)
Set wb4 = ThisWorkbook.Sheets(1)
k = 5
For i = 2 To 264
sh = wksplan.Cells(i, 2).Value
count = 0
For j = 9 To 45
sh1 = wksplan.Cells(i, j).Value
If sh1 = "Unplanned Leave" Then
count = count + 1
End If
Next
wb4.Cells(k, 1) = sh
wb4.Cells(k, 2) = count
k = k + 1
Next
End Sub

the above logc will calculate the number of planned leaves count and the output will be stored in the same active worksheet from 5th cell onwards

similarly i ran the similar logic but with some changes to above code for unplanned leaves.. so it will generate the output and will store in the same worksheet by overriding it.. i need a logic that will delete the data which is previously there in the active worksheet and will load the current output data to same worksheet