Ark68
Well-known Member
- Joined
- Mar 23, 2004
- Messages
- 4,564
- Office Version
- 365
- 2016
- Platform
- Windows
I'm having an issue wrapping my head around this very basic problem. I am simply trying to find the next unoccupied cell in a range (AJ1:AJ8). My code below results in an error "Object variable or With block variable not set." It could be because all cells in that range are currently empty.
Code:
with ws_thold
drow = .Range("AJ1:AJ8").Find("*", , xlValues, , xlByRows, xlPrevious)
end with