VBA code - verification of data for equality

[Radek1]

Dears,

I would like to kindly ask you for your advice regards vba code. I need to assure that use right data. As I'm just beginner, not sure how to proceed with that...
When push the button, data(text) in column A will be checked for equality. If all the same, run preview before printing. If not, pop up the message window and close macro.
Problem will be that no. of rows in column A will change every time...depends of filtered name. I just need to make sure that only 1 name is selected (for further processing of data)
Cells in considered / filtered range will be every time checked toward text / data in cell A2

A B C
1 Name
2 John
3 John -----> run preview for printing
4 John

1 Name
2 John
3 John -----> Pop up message box and close running macro
4 William

Many thanks for your help in advance

Radek

 

[Fluff]

Duplicate https://www.mrexcel.com/forum/excel...lls-range-contain-same-value-post5310791.html

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread.
Per forum rules, posts of a duplicate nature will be locked or deleted (rule 12 here: Forum Rules).