What's new

Closed Vba clear cell contents with value

Status
Not open for further replies.

Kenkoy015

Honorary Poster
Established
Joined
Jan 1, 2014
Posts
508
Reaction
95
Points
220
Guys pa tulong po about dito

gusto ko sana i delete yung cell na may "B0" sa column H

Ano kaya code para dito

yung parang ganito kaso ayaw gumana
Range(H1, H6000).Value = ("*B0*").clearcontent

wala akong masyadong alam sa macro.

Salamat
 
dapat siguro TS isa-isahin ang values ng H1 hanggang H6000 at silipin kung may BO. Kung may mag positive, dun kailangan i-execute ang clear command.
Need mailoop yun 1 to 6000 tapos If statement para makita kung may BO sa bawat isa
Sana makatulong yun flow. Di na ako masyadong familiar sa commands ni macro
 
Status
Not open for further replies.

Similar threads

Back
Top