What is the correct syntax to select all the cells in a sheet (so I can then
format the cells)? Manually, I would use shift-ctrl-end, selecting from A1
to the last cell.

With Cell A1 active

Range(Selection, ActiveCell.SpecialCells(xlLastCell)).Select

Regards
Rowan

"djh" wrote:

What is the correct syntax to select all the cells in a sheet (so I can then
format the cells)? Manually, I would use shift-ctrl-end, selecting from A1
to the last cell.

You don't usually need to select the cells to work with them.

with activesheet.usedrange.cells
.numberformat = "General"
end with

(If row 1 isn't used and if column A isn't used, it won't be included.)

With ActiveSheet
With .Range("a1", .UsedRange)
.NumberFormat = "general"
End With
End With

Will get A1 to the bottom right corner.

Or all the cells
with activesheet.cells
.numberformat = "General"
end with



djh wrote:

What is the correct syntax to select all the cells in a sheet (so I can then
format the cells)? Manually, I would use shift-ctrl-end, selecting from A1
to the last cell.

--

Dave Peterson