Ark68
Well-known Member
- Joined
- Mar 23, 2004
- Messages
- 4,564
- Office Version
- 365
- 2016
- Platform
- Windows
Consider this range of cells in my worksheet
And this line of code:
grmcrew = "CRP"
rwcrewid = 14
I am looking to get a value of grmtime = "<10:45A"
Because B13:B16 is merged, is this why in testing, the value of grmtime I'm getting is empty? I was hoping that the cell offset by 1 column would be the value of the merged cell.
Thoughts for improvement?
WS 24-May-22.xlsx | ||||
---|---|---|---|---|
A | B | |||
13 | 44705003 | <10:45A | ||
14 | 44705006 | |||
15 | 44705034 | |||
16 | 44697036 | |||
CRP |
And this line of code:
Code:
grmtime = wb_data.Worksheets(grmcrew).Cells(rwcrewrid, 1).Offset(0, 1)
grmcrew = "CRP"
rwcrewid = 14
I am looking to get a value of grmtime = "<10:45A"
Because B13:B16 is merged, is this why in testing, the value of grmtime I'm getting is empty? I was hoping that the cell offset by 1 column would be the value of the merged cell.
Thoughts for improvement?