[RESOLVED] excel 2007 macro - set vpagebreaks

i found this code on the internet. can't get it working. i'm trying to set the first vertical page break (counter = 1), to range W1 (pgbrColumn = W).

vb Code:

Set ActiveSheet.VPageBreaks(Counter).Location = Range(pgbrColumn & "1")

whats wrong with my code?