This should be very basic... i need to clear a cell based on a value in another cell
here is what i have
Sub clearcell()
If Worksheets(Sheet8).Cells(20, 3).Value = "Smooth" Then
`i need to clear cell C22
End If
End Sub
This should be very basic... i need to clear a cell based on a value in another cell
here is what i have
Sub clearcell()
If Worksheets(Sheet8).Cells(20, 3).Value = "Smooth" Then
`i need to clear cell C22
End If
End Sub
Please Login or Register to view this content.
it does not work for me and when i go to run the macro it says "subscruipt out of range"
i also added an end if
Maybe
VBA NoobPlease Login or Register to view this content.
_________________________________________
Credo Elvem ipsum etian vivere
_________________________________________
A message for cross posters
Please remember to wrap code.
Forum Rules
Please add to your signature if you found this link helpful. Excel links !!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks