Livin404
Well-known Member
- Joined
- Jan 7, 2019
- Messages
- 743
- Office Version
- 365
- 2019
- Platform
- Windows
I'm trying to add data "DATE:" to an offset in a formula. The end result would be "DATE: WEDNESDAY NOVEMBER 18 2020".
For briefness I only included a couple of lines which I believe where the edit should go. I tried using different variations of adding this piece
with "&", and it either errored out or inserted "DATE:" and ignored the actual date.
For briefness I only included a couple of lines which I believe where the edit should go. I tried using different variations of adding this piece
Excel Formula:
.Resize(1).Offset(-1).Value = "DATE:"
VBA Code:
For x = .Areas.Count To 1 Step -1
If x > 1 Then .Areas(x)(1).EntireRow.Insert
With .Areas(x)
.Resize(1).Offset(-1).Value = .Value
.Resize(1).Offset(-1).Replace "(*", Year(Now), xlPart, , , , False, False
.Resize(1).Value = "DESTINATION"