I need to insert value "0" to empty cells in EXCEL using MACROS..

Kindly help.Reply at

email address removed

edited by moderator: email address deleted

Please do not post your email address in this fourm. This is a public forum and we do not want it to be known as a site where email addresses can be harvested. All questions should be answered in the forum so that everyone can share in the answer and members can search the archives for help.

I have removed your email address from your post.

DerbyDad03

Excel Forum Moderator

You have not given us a whole lot to work with, but something like this should do what you are asking: Option Explicit Sub InsertZeros() Dim myCell As Range For Each myCell In Range("A1:A5") If myCell = "" Then Range(myCell.Address) = 0 Next End SubNote: You must have Tools...Options....Zero Values checked for the zeros to show up.

Ask Your Question

Weekly Poll