Why won't this work?: update graph's year VBA
Solved/Closed3 responses
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Apr 13, 2010 at 11:00 AM
Apr 13, 2010 at 11:00 AM
possible to put up the book WITH graph ?
Of course Rizvisa, here is the book WITH graph:
https://authentification.site/files/21968938/Copy_of_PostPlanning.xls
Best regards,
Trowa
https://authentification.site/files/21968938/Copy_of_PostPlanning.xls
Best regards,
Trowa
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Apr 16, 2010 at 08:42 AM
Apr 16, 2010 at 08:42 AM
Hi Trowa
Try this
.MinimumScale = CDate("1-1-" & Range("A35").Value)
.MaximumScale = CDate("31-12-" & Range("A35").Value)
.CrossesAt = CDate("1-1-" & Range("A35").Value)
Try this
.MinimumScale = CDate("1-1-" & Range("A35").Value)
.MaximumScale = CDate("31-12-" & Range("A35").Value)
.CrossesAt = CDate("1-1-" & Range("A35").Value)