yes it is possible



SeriesRanges = Range("'DataCollection'!A1505:BR1505")

try


strCol = "BR"
intRow = 1505


SeriesRanges = Range("'DataCollection'!A1505:" & strCol & intRow

-----------------------------------------------
~~ Message posted from http://www.ExcelTip.com
~~View and post usenet messages directly from http://www.ExcelForum.com

~~Now Available: Financial Statements.xls, a step by step guide to creating financial statements