mattress58
Board Regular
- Joined
- Aug 7, 2013
- Messages
- 55
I need to adjust the code below. I need to set the first blank cell in column E as a perminent spot for later code. If E29 is the first blank cell I want FB = Range("E29") and not the first blank cell. I only want to use Range("E500").End(xlUp) to just find and set the cell in the beginning and then it never changes as data fills in column E.
HTML:
Sub Try
Dim FB as range
set FB = Range("E500").End(xlUp)