Hello everyone,

I am working on a spreadsheet in Excel which has 3 fields in the left portion of the worksheet. Line one is a patients name, Line two is the insurance id # (social security # followed by 1-3 letters) and line three is a medical records number. On the left of those fields are information (dates and payment levels) to determine the facilities payment for each patient during different time periods of their stay. My problem is that I don't want to show zero values for the date section because when I need to print the report, not all of those dates will be entered. I do need to show zero values for the social security #, otherwise it will not print correctly. I attempted to use VBA code like this:

Private Sub Worksheet_Activate()
Columns("A:M").Select
Selection.EntireColumn.ShowZeros = True
End Sub

But it isn't working. Can anyone help me figure out what is wrong with this code??

Thanks!!! Sorry for being so new. I have been learning for only about 2 months.

HI,

     I think you should use conditional formating for this cause. it can do the task that you require both visually and through code. it is available in "Format" Menu. Try this one out, hope this will help

Tiyyob