Showing posts with label VBA. Show all posts
Showing posts with label VBA. Show all posts

Wednesday, March 28, 2007

Finding the last data cell in Excel 2007

Using VBA use the Range.SpecialCells Method such as

RCount = ActiveCell.SpecialCells(xlLastCell).Row
CCount = ActiveCell.SpecialCells(xlLastCell).Column
ActiveCell.SpecialCells(xlLastCell).Select