Michael M
Well-known Member
- Joined
- Oct 27, 2005
- Messages
- 21,821
- Office Version
- 365
- 2019
- 2013
- 2007
- Platform
- Windows
Okay, it's Sunday and my brain has been frozen....
I simply want the last populated cell in a Range of cells in"E7:E64"
All cells have the formula =IF(B8="","",IF(D8<>"",E7-D8,E7+C8)) dragged down to E64, but As each line "A" to "D" is populated, so does "E"
So if I am down to say A20:D20....I want the value of E20 returned using VBA....please !
I simply want the last populated cell in a Range of cells in"E7:E64"
All cells have the formula =IF(B8="","",IF(D8<>"",E7-D8,E7+C8)) dragged down to E64, but As each line "A" to "D" is populated, so does "E"
So if I am down to say A20:D20....I want the value of E20 returned using VBA....please !