Please, help me to clear content on cell C1 if A1 is empty and clear content C2 if A2 is empty, et seq.
Please, help me to clear content on cell C1 if A1 is empty and clear content C2 if A2 is empty, et seq.
try this:
Please Login or Register to view this content.
if you want VBA to look at all rows where there is a value in columnC.
Run macro from the worksheet that you want to amend.
Please Login or Register to view this content.
If a response has helped then please consider rating it by clicking on *Add Reputation below the post
When your issue has been resolved don't forget to mark the thread SOLVED (click Thread Tools at top of thread)
or another way
Please Login or Register to view this content.
One more:
Please Login or Register to view this content.
@JOHN H. DAVIS - elegant code.
But it will not clear contents in ColumnC if there are values in columnC below the last row with values in columnA.
@Kevin# - this will:
Sub putritersenyumz()
Range("A1:A" & Range("C" & Rows.Count).End(3).row).SpecialCells(4).Offset(, 2).ClearContents
End Sub
@igormigor, @Kevin# & @JOHN H. DAVIS
Thanks so much. Your codes work for me. For JOHN H. DAVIS & Kevin# your codes are what I want.
You're welcome. Glad to help out and thanks for the feedback and the reps.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks