[SOLVED] INDIRECT function with COUNTIF

[TheRobsterUK]

I'm trying to use the INDIRECT function to build what would normally be a fairly straight-forward formula:

=COUNTIF(indirect("$K$5:$K$" &X1& ",V5")

In cell X1 there is simply a number which is the last used row on the sheet (determined by a bit of VBA). I've parsed the formula for the INDIRECT section and get:

$K$5:$K$275149,V5

So I don't see why this doesn't work. It should tell excel to count how many times the contents of cell V5 occur in the range K5:K275149, but no matter how many variations I try it won't accept the formula. Anyone got any ideas?

Cheers