how to find the column number in vba to use as a variable

[KORT]

Hello

i`m trying to find the column number in sheets "STATESTIK" to use as a variable B

the value in "RESULTAT" "B2" is today date
the dates 01.01.2010, 01.02.2010, 01.03..... is in sheets "STATESTIK" row "5"
at the først day in a month i want to copy the value in sheets "RÅDATA" "D2" to "STATESTIK" (A, B)

if i define the variable B = f.ex 5 it works

how can tell vba to retun the column number of f.ex 01.01.2010 in sheets "SATESTIK" ROW "5"

Please Login or Register  to view this content.

[KORT]

can somone please help ?