This is probably insanely easy, but it's driving me mad. I'm trying to select a cell that's been data validated to a list (so it's a cell that has a scroll down to select more cell value options). I'm using the standard
Sheets("Expenses").Select
Range("D8").Select
A = ActiveCell.Value
Range("D9").Select
C = ActiveCell.Value
Is there any way to select a cell that's on data validation list?
I can always re-route the string in that cell to a different cell that's not data validated, but if there's a streamlined solution, that would be wonderful.
Thanks,
Cami
Bookmarks