Web Development

Ask something
Discussion Locked

Date from Worksheet for name in VBA

0 helpful
3 replies

by patquinn52

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I saw an article the other day and lost it. I need to set up worksheet titles that have the date in them using VBA code. I can concatenate text with a date but the date is the number format, not the date format I need. Date shows appropriately in cell I want to pull from.

3 replies

by kpennington

Don't know if you still need this but if you read the cell contents as .Text
eg: ThisWorkbook.Sheets("SheetName").cells(rownumber,colnumber).Text
This will return the cell contents as a string

Regards

by patquinn52

I did as the poster suggested, though I got an earlier answer that stated the same thing, and it worked. Thank you for your answer.

This discussion is closed to new replies.