**Question description:**

*This user has given permission to use the problem statement for this blog.*

I want to check if the value in the excel activeCell is "Jan" and if this is so I want to check all the columns of the row

Solved by G. H. in 20 mins

This is the chat thread from the real Excelchat help session. It contains no private user information.

Excelchat Expert
16/03/2018 - 10:24

HI

User
16/03/2018 - 10:25

ok

Excelchat Expert
16/03/2018 - 10:25

Hi

Excelchat Expert
16/03/2018 - 10:26

Do you wan to just check "jan" in column

User
16/03/2018 - 10:27

yes

Excelchat Expert
16/03/2018 - 10:27

ok

User
16/03/2018 - 10:31

can i write code

Excelchat Expert
16/03/2018 - 10:31

no

Excelchat Expert
16/03/2018 - 10:31

i have create this formula

Excelchat Expert
16/03/2018 - 10:31

=MATCH("jan",1:1,0)

Excelchat Expert
16/03/2018 - 10:32

does this solution is accurate

Excelchat Expert
16/03/2018 - 10:34

Thank you for using GO IT PRO

User
16/03/2018 - 10:34

i want to use VBA for this

User
16/03/2018 - 10:35

because for other columns under Jan i need other checks

Excelchat Expert
16/03/2018 - 10:36

yes

Excelchat Expert
16/03/2018 - 10:36

i think you are right

Excelchat Expert
16/03/2018 - 10:36

but due to policy i am only handle one question per session

Excelchat Expert
16/03/2018 - 10:36

now you have to come back again with VBA specification.

User
16/03/2018 - 10:36

ok thanks

Excelchat Expert
16/03/2018 - 10:37

thank you for using GOT IT PRO

**This is the output file from the real Excelchat help session:**

*This is an example of the expert help you can get. It contains no private user information.*