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
Posted by at
Labels: ,

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)