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:
  1. Set ActiveSheet.VPageBreaks(Counter).Location = Range(pgbrColumn & "1")

whats wrong with my code?