VBA to select values

[KenC53]

I have a macro that selects a range going down from A2 to the last row with values and the over right to the last column with values. The code selects all cells with formulas, even those returning no value leaving the cell blank. how do I change the macro to slect only the cells that have values returned and not those with only formulas entered. The last cell in column A with values is row A96 but this macro selects down to row 150 because there are formulas but no values present. Here is the macro:

Please Login or Register  to view this content.

Ken

[snb]

Please Login or Register  to view this content.

[KenC53]

Forgive me, I'm a newbie. Do I add this to the existing code or completely replace the existing? I've tried both ways and neither gets past this line.

[TMS]

If you need to select the cells, add .Select to the end and replace your current code.

In most cases, if not all, you do not need to select cells or ranges.

I'd guess that's why snb didn't include it. ;-)

Regards

[KenC53]

I get an error message that No cells found after replacing with this code.

[TMS]

Please post a sample workbook.

Regards