Select constants

[sujittalukde]

Can a macro be provided for selecting cells (including hidden) in the active sheet which are :

1. Totally consants ie not used in formula either in same sheet or other sheets

2. Constants ie figures used in formula in the same sheet and/or other sheets

 

[Krishnakumar]

Hi,

This thread might help you?

 

[sujittalukde]

As I am signning off from office, on Monday I will check.