Hi,

At work we often paste multiple reports into excel. These reports are always different sizes. I've created a search function which allows me to to identify exactly where the report has been pasted. The function also gathers information about where the report starts and stops. The problem I'm having is being able to use variables within the Vlookup function within Excel.

This is what I would like to do:


Dim Column1 as interger
Dim row1 as interger
Dim Column2 as interger
Dim row2 as interger
Dim Column3 as interger
Dim row3 as interger

{Program then assigns values to these varibles based upon the search conducted.}

then this is what I can't figure out:

What's the syntax for passing my varibles into the vlookup function?

' I've tried this, and it doesn't work.

=vlookup(cells(row1, column1), cells(row2, column2):cells(row3, column3),9,false)

How come this won't work?

What I'm hoping to achieve is a dynamically adjusting vlookup field based upon the inputs from the variables, but I can't seem to get the syntax correct.


Any help would be greatly appreciated!!



Thanx,


Angusrocks.