I need to insert value

October 12, 2010 at 06:33:20
Specs: Windows XP
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

See More: I need to insert value

Report •

October 12, 2010 at 07:53:01
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.

Excel Forum Moderator

Report •

October 12, 2010 at 07:57:59
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
End Sub

Note: You must have Tools...Options....Zero Values checked for the zeros to show up.

Report •

Related Solutions

Ask Question