VBA code to run over many rows and show shapes if the area is being used,

richie247

New Member
Joined
Feb 3, 2017
Messages
14
Office Version
365, 2013
Platform
Windows
Many thanks for your help in simplifying the code,

it works perfectly

regards

Richie
 

DanteAmor

Well-known Member
Joined
Dec 3, 2018
Messages
7,856
Office Version
2007
Platform
Windows
I'm glad to help you. Thanks for the feedback.
 

richie247

New Member
Joined
Feb 3, 2017
Messages
14
Office Version
365, 2013
Platform
Windows
i have been asked to show what areas are in use during different times. i have taken the times out of the cells and converted them into time format and used column "F" to show true of false when i enter the time range.

the question is how can i stop the shapes being shown if it is not within the time.

at the moment it if the time is after the range it will not show which is good. but if the start / end time has expired it still shows.

any further help would be great
 

Forum statistics

Threads
1,078,283
Messages
5,339,281
Members
399,291
Latest member
Bdbd55

Some videos you may like

This Week's Hot Topics

Top