I'm running office 2010 and recently added visual studio pro 2008 (requried by a project I am starting). I've also kept up with Microsoft updates so I've made some of those too. How my excel VBA macros don't work. A snippet of code which stops with "application defined or object-defined error on the last line.
Range("end_end").value = activerows + 5
ActiveWorkbook.Names("Master").RefersTo = "=pricing!$f$6:$bn$" & LTrim(Str(activerows + 5))
ActiveWorkbook.Names("Dealers").RefersTo = "personal.xls!dealers"
noter = 0
pr = "$a$1:$bn$" & LTrim(Str(activerows + nr + 6))
ActiveSheet.PageSetup.PrintArea = pr
Code worked before but not now