CasualDabbler
New Member
- Joined
- Oct 29, 2018
- Messages
- 19
- Office Version
- 2016
- Platform
- Windows
Need the following 2 items please
Item 1
If a cell in a range (D4:D2000) has a value entered, the cell at Target.Offset(0, 5).Value = "09:00" and subsequent values "17:00", "09:00" etc
Sheet is a work in progress and may have other columns inserted, so can the solution factor easily changing target ranges.
I.e. I set the initial target "MonOpen" and the rest flow from that cell
Target.Offset(0, 5).Value = "09:00"
Target.Offset(0, +1).Value = "17:00" etc
Item 2
If a cell in a range (D4:D2000) has its value cleared I need to clear the corresponding adjacent range. As per above sheet is WIP, looking to set the start of the range and just enter a width value
Thanks
Item 1
If a cell in a range (D4:D2000) has a value entered, the cell at Target.Offset(0, 5).Value = "09:00" and subsequent values "17:00", "09:00" etc
Sheet is a work in progress and may have other columns inserted, so can the solution factor easily changing target ranges.
I.e. I set the initial target "MonOpen" and the rest flow from that cell
Target.Offset(0, 5).Value = "09:00"
Target.Offset(0, +1).Value = "17:00" etc
Item 2
If a cell in a range (D4:D2000) has its value cleared I need to clear the corresponding adjacent range. As per above sheet is WIP, looking to set the start of the range and just enter a width value
Thanks