Forum Discussion
Wardd
Nov 21, 2025Occasional Reader
Search for a date in a row does not work in VBA with ".find" when column is too narrow
I have a row with dates (row 3) and a cell with a date (C7) I want to get the column where this date (C7) is in that row3 This is my code: Sub find_date() Dim datum As Date ...
m_tarler
Nov 21, 2025Bronze Contributor
for what it is worth, the actual Find function in the spreadsheet (ctrl-f or home -> editing group -> find) works (fails) the same way.