PatrickW1907
New Member
- Joined
- Sep 3, 2022
- Messages
- 18
- Office Version
- 365
- Platform
- Windows
Hi
I've been using vba for a little while and still a novice. I have a spreadsheet where there are a list of dates in column A the date changes every 8 rows i.e. 1 to 8 = 31/08/2022 9 to 16 = 01/09/2022 . I'm looking at automation and want to code a macro that will find the bottom row with data in column A and change the bottom 8 cell values in column A to today's date. I cannot seem to find any useful info I imagine it will be last row -7 and something with the value property but appreciate any help or sdvice from anyone.
Kind regards
Patrick Wood
I've been using vba for a little while and still a novice. I have a spreadsheet where there are a list of dates in column A the date changes every 8 rows i.e. 1 to 8 = 31/08/2022 9 to 16 = 01/09/2022 . I'm looking at automation and want to code a macro that will find the bottom row with data in column A and change the bottom 8 cell values in column A to today's date. I cannot seem to find any useful info I imagine it will be last row -7 and something with the value property but appreciate any help or sdvice from anyone.
Kind regards
Patrick Wood