Hello,

An Excel 2007 file was converted to the 2010 version and after running the Code Compatibility Inspector add-in, some items were tagged as "Removed". I was hoping someone would be able to provide help in the form of alternative codes for the following findings, since the url provided by the VBA inspector add-in was not much of a help:


MODULE: Sheet11
FUNCTION: commandbutton4_click
LINE: 19
TYPE: REMOVED
ITEM: [mso]ODSOFilter.Column
URL: http://go.microsoft.com/fwlink/?LinkID=215358
CODE: activewindow.scrollcolumn = range("gen_years").cells(1, 1).column



MODULE: RollDataForward
FUNCTION: rollforwarddata
LINE: 188
TYPE: REMOVED
ITEM: [mso]OfficeDataSourceObject.Columns
URL: http://go.microsoft.com/fwlink/?LinkID=215358
CODE: rangemax = .range(sheetcode & "_range" & j).columns.count


Thanks!