Hey guys,
I want to activate a sheet based on a cell value. So,I have a list lets say "JAN", "FEB", "MAR" etc and sheets with those exact names also. I thought something like this would work
Sheets(Cells(1, 1).Value).Active
but i'm getting an error "438" object doesn't support this property or method.
Thanks.