function in VBA - automatical usage question

[Marcin Zmyslowski]

I have created a function in Visual Basic which have such a structure

public function function_count_working_hours(worksheetname as string;
parameter1 as string; parameter2 as integer) as string

I have a problem with parameter2. I have a lot of cells where I have to put
it, but in each cell I have to put another
number. I couldn`t fill in series in where this paramater2 will have values:
1, 2, 3, 4, 5 depending on number of cell.
for example:
Column1
----------------------
AA1
AA2
AA3

that is:

Column1
---------------------------------------------------------
function_count_working_hours("03.2004";"C";1)
function_count_working_hours("03.2004";"C";2)
function_count_working_hours("03.2004";"C";3)
and so on

How to fill in this parameter2 to make it growing automaticaly?

Thankx a lot
Marcin

 

[Frank Kabel]

Hi
try something like
function_count_working_hours("03.2004";"C";ROW())
and copy down

 

[Marcin Zmyslowski]

function_count_working_hours("03.2004";"C";ROW())

and copy down

Thank you a lot, that`s what I wanted.

Big regards
Marcin