AlexanderBB
Well-known Member
- Joined
- Jul 1, 2009
- Messages
- 2,072
- Office Version
- 2019
- 2010
- Platform
- Windows
This gets me every time.. looking at the worksheet Cell I see 2:15
But reading Cells(row, Col) in VBA results in 0.09375. I think this is because the cell is formatted to suit a different data type.
Is there a solid way to get "2:15" ? I tried CStr but no change.
But reading Cells(row, Col) in VBA results in 0.09375. I think this is because the cell is formatted to suit a different data type.
Is there a solid way to get "2:15" ? I tried CStr but no change.