New User having trouble with Zero Values
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()
Selection.EntireColumn.ShowZeros = True
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.