ManUBlueJay
Active Member
- Joined
- Aug 30, 2012
- Messages
- 320
- Office Version
- 365
- Platform
- Windows
I have a table 2 cols wide like a diary with a date for every day of the year, the second Col would be for an entry.
Cell A1 is the header row named date, Cell B1 is notes , Cell A2 =Jan 1 2021, cell A3 to A366 =the cell above plus 1. Cell B2 to B366 is blank.
So A3 would be Jan 2 2021...........
All looks good.
There are days where I would like to make another entry on the same date.
I would like some code that would insert a line below the active row but keep the same date.
When I use the code "ActiveCell.EntireRow.Insert" it inserts a row below but because the table col A is the above row +1 it will put tomorrows date in vs the active cell date.
Any help would be appreciated.
Cell A1 is the header row named date, Cell B1 is notes , Cell A2 =Jan 1 2021, cell A3 to A366 =the cell above plus 1. Cell B2 to B366 is blank.
So A3 would be Jan 2 2021...........
All looks good.
There are days where I would like to make another entry on the same date.
I would like some code that would insert a line below the active row but keep the same date.
When I use the code "ActiveCell.EntireRow.Insert" it inserts a row below but because the table col A is the above row +1 it will put tomorrows date in vs the active cell date.
Any help would be appreciated.