I assume you mean the cell is "" instead of " " as I would think a " " would work.
Change x=1 to:
![]()
if isempty(range("A1")) then x = range("A1").End(xlDown).Row else x=1
I assume you mean the cell is "" instead of " " as I would think a " " would work.
Change x=1 to:
![]()
if isempty(range("A1")) then x = range("A1").End(xlDown).Row else x=1
Pauley
--------
If I helped with your issue, I'd appreciate a rep bump (hit the '*' icon to the bottom left of this post).
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks