VBA: Find a column by its date
Hi,
I am just learning Excel and VBA again after some years with other tools.
Now I have a task that I have already solved to a good part.
Right now, I have the value I want in a variable and I just have to paste that in the "adressee_table" in a specific row (fixed value depending on the type of value) and a specific column (dependent on the date, the date is across the entire table in line 3).
I always have yesterday's data, so my macro should always look for the column with yesterday's date in line 3 and just paste the variable in that cell.
I guess I need that FIND command, but I don't know the exact syntax and what I have to write in the parameters and I haven't yet got fluent in using the integrated help.
Can anybody tell me how to do that?
Thanks a lot!
Best regards,
Officer_Bierschnitt
|