Selecting all cells containing data in a spreadsheet

[chadski778]

Could I please have code for selecting any cells in my spreadsheet that contain data. It will be used in another macro. Thanks

 

[wigi]

Please be less vague, if you want to receive meaningful comments.

Is your data in tabular form? Are they scattered around the sheet?

Do you mean fixed values, or cells with formulas? And so on.

 

[VoG]

Perhaps

Sub Test2()
ActiveSheet.UsedRange.SpecialCells(xlCellTypeConstants).Select
End Sub

 

[prajul89]

Why don't you select every single cell in every Single Sheet

Sheets.Select
Cells.Select

 

[chadski778]

SubTest2() has done the job nicely. Thank you