brothertruffle880
asked on
Excel VBA - Testing a cell for any type of content
I would like to test my currently active cell for any type of content and if it has content (words, numbers, punctuation, etc.) I'd like to generate a message box saying "content"
I would then like to go to the bottom row of that region. (If I were doing this with the keyboard, I would press the END key and then the DOWN key This would take me to the bottom cell of my current region.
I would then like to go to the bottom row of that region. (If I were doing this with the keyboard, I would press the END key and then the DOWN key This would take me to the bottom cell of my current region.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Would this work to test for any value inside of a cell? (i.e. alphanumeric or punctuation?
if istext(activecell.value) then msgbox "you have junk to clean up!"
end if