Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I am trying to get the time (lastlap) from Worksheet (A Grade) when i know it
is located in the nth column (lapcol) and the nth row ridercell.row. I have checked that the row and column co-ordinates are right but I don't think this code works. It is returning 0 when it should have been the time 0:00:10. Is it something to do with the number being in a time format. LastLap = Sheets("A Grade").Cells(riderCell.Row, LapCol).Value Thanks again |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Code to send email to address within selection in Excel workbook | Excel Discussion (Misc queries) | |||
Copy Selection - Transpose Selection - Delete Selection | Excel Discussion (Misc queries) | |||
TIP: Dynamic chart selection without code | Charts and Charting in Excel | |||
Running code on a drop down selection change | Excel Worksheet Functions | |||
limit cell list selection based on the selection of another list | Excel Worksheet Functions |