- Mar 23, 2004
- Office Version
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.
with ws_thold drow = .Range("AJ1:AJ8").Find("*", , xlValues, , xlByRows, xlPrevious) end with