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.
