Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I am trying to "future-proof" some code.
I currently have some code which returns the first and last dates in a specific column. This is fine, except that the column may change (was A, is now B, may change again). I have to modify the code as it is currently specific to column A. What is the easiest way to fing the column with Date in row 1? I know I can specify a range (eg A1:G1) then loop through to match the string, but is there a better way? -- Ian -- |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Find specific value in a string | Excel Discussion (Misc queries) | |||
Find a specific string in a cell | Excel Programming | |||
find cells in a range which equal a specific value | Excel Programming | |||
Find specific text in a string | Excel Programming | |||
Find specific text in a string | Excel Programming |