VBA for highlight & extract cells addresss where harcode mannual entry [Archive]

View Full Version : VBA for highlight & extract cells addresss where harcode mannual entry

amartakale

10-04-2019, 06:31 AM

25217

amartakale

10-04-2019, 06:34 AM

Above attached sheet I highlight cells both tabs in yellow color where hard code numbers input. I want to find out that all cell where manually input hard code numbers in cell.
is it possible through VBA or any other option?

snb

10-04-2019, 07:44 AM

Lesson 2 Excel for Beginners.

amartakale

10-05-2019, 12:57 AM

Sorrry.....

p45cal

10-05-2019, 02:53 AM

Cells.SpecialCells(xlCellTypeFormulas, 23).Interior.Color = 65535

amartakale

10-07-2019, 02:55 AM

Hi P45cal Sir,

Can you explain me what I do "Cells.SpecialCells(xlCellTypeFormulas, 23).Interior.Color = 65535" from this.I am VBA leaner.

Regards
Amar

p45cal

10-07-2019, 03:05 AM

Single line macro.
https://www.ablebits.com/office-addins-blog/2013/12/06/add-run-vba-macro-excel/#insert-vba-code

amartakale

10-07-2019, 05:35 AM

Ok I will Check

amartakale

10-09-2019, 03:39 AM

Thanks Sir. Helpful link.