VBA Ctrl + A Problem

Hi all,

I’m trying to incorporate code into my macro that selects all filled cells. After searching through the forums, I saw that

Sheets("Sheet1").Select
activecell.CurrentRegion.Select

can be used to select all of the filled cells in a sheet. This code works in the macro for the first sheet of the Excel document (“Sheet1”), but when I try to use it in the same macro for another sheet in the document with the code

Sheets("Sheet2").Select
ActiveCell.CurrentRegion.Select

the macro selects the same range of cells that was selected on the first sheet. Why won’t it select the new range of filled cells in Sheet2 instead of selecting the same range from Sheet1? I can’t figure out why it merely selects the same range from Sheet1..thanks in advance for your comments, ideas, and suggestions.