Sheet showing another sheet over the top??

[dillyoh]

I have a dashboard type workbook that has buttons I press which I use to navigate between sheets.

On the main dashboard there are a few numbers which I have used vbscript to type.

For some reason when I navigate to other sheets these numbers show through from the main dashboard sheet.

I dont know how to add a screenshot in here.

Some of the code where it adds data to the main Dashboard sheet (which is what's showing through on the other sheets)

For some reason all seems fine switching between sheets but as soon as I make an edit on the sheet some of this data from the Dashboard sheet seems to come through. If I alt-tab to another application and come back it corrects itself.

Dim PolDate    PolDate = Worksheets("PoliceVetsDue").Range("A2").Value
  Sheets("Dashboard").Select
  Range("M40").Select
        ActiveCell.FormulaR1C1 = PolDate

 

[NdNoviceHlp]

I'm guessing using selection is your problem. Trial....

Sheets("Dashboard").Range("M40").FormulaR1C1 = Worksheets("PoliceVetsDue").Range("A2").Value

HTH. Dave
Note: Using .FormulaR1C1 requires that a formula be passed to the range. It should look something like....
.FormulaR1C1 = "=(D1 + C1)" as an example