vba date & data formatting problem

  • Thread starter Thread starter jo11
  • Start date Start date
J

jo11

I have formatted the date as it should be but each time the macro i
finished I have to copy an empty cell and add it to each date row- if
write the code for this procedure in the macro it does NOTHING and
still have to do it manually!!!
What can I do???? :confused:
Furthermore(this is not the same cells as above) I am trying to ge
the green triangle in the corner along with the "!" to disappear bu
here again the macro has no effect on the sheet though I have recorde
the exact rutine????:confused: :confused: :confused:

Yours sincerely
 
Range("A1").Value = Range("B9") + Range("A1").Value

might provide some insights. It adds the value of B9 to the existing value
in A1.
 
I have tried what you proposed but I just get an error instead....It is
a formatting problem and the only way I can solve is manually add an
empty cell to the cell containing the date. I believe I have tried
everything - so if anybody could help me I would be eternally
greatfull!!!!!

Y:C:
J.N.
 
Back
Top