Hello, I am asking you for help because I can not deal with it. I am aware that this is nonsense but still ... :) I need a VBA code that checks if there is a specific value in the given column, for example 1 and if it does something like doing it (eg opening a different file and copying the...

Maybe try searching through CtrlF? In VBA it will be like this: Dim r1 as Range Set r1 = Range (C1, Range (C1). End (xlDown)). Find (Search) If r1 Is Nothing Then 'not found ...

And the If-Then-Else statement does not work?

Thanks for the answers! kinggustav, works ) Thanks again.

Excel VBA: Find Specific Value in Column and Perform an Action after Condition Met

| New topic

#1 16246590 02 Feb 2017 00:09

gr3krk gr3krk

Level 9

» |

Post #1
16246590 02 Feb 2017 00:09

Hello,
I am asking you for help because I can not deal with it. I am aware that this is nonsense but still ...

I need a VBA code that checks if there is a specific value in the given column, for example "1" and if it does something like doing it (eg opening a different file and copying the indicated values - I have done and works ... I just need to condition) and if not it goes on to the next part.

Thanks in advance for your help.
Greetings.
ADVERTISEMENT
#2 16246737 02 Feb 2017 08:08

adamas_nt adamas_nt

Moderator of Programming

» | Helpful post? (+3)

Post #2
16246737 02 Feb 2017 08:08

And the If-Then-Else statement does not work?
ADVERTISEMENT
Helpful post

#3 16247567 02 Feb 2017 14:48

kinggustav kinggustav

Level 27

» | Positive voted Helpful post? (+6)

Helpful post
Post #3
16247567 02 Feb 2017 14:48

Maybe try searching through "CtrlF"? In VBA it will be like this:
Dim r1 as Range
Set r1 = Range ("C1", Range ("C1"). End (xlDown)). Find ("Search")
If r1 Is Nothing Then 'not found
...
#4 16249023 02 Feb 2017 23:54

gr3krk gr3krk

Level 9

» | Topic author Helpful post? (+2)

Post #4
16249023 02 Feb 2017 23:54

Thanks for the answers!

kinggustav, works ) Thanks again.
Create an account, log in and become active in a forum and ads will not appear. You will receive points by participating in discussions.
Join this discussion.

Install the application

Didn't find an answer? Ask Artificial Intelligence

*I agree to send the question to OpenAI, Anthropic PBC, Perplexity AI, Inc., Kagi Inc., Google LLC - owners of language models in order to prepare the best response. The companies may monitor and log information entered into the form.

*I agree to publicly display my question and answer. The question and answer will be publicly available to everyone. The process may take a few minutes. Upon completion, you will be redirected to the page with the answer.

Wait...(2min)

| New topic

Report a violation of the law

Excel VBA: Find Specific Value in Column and Perform an Action after Condition Met

Didn't find an answer? Ask Artificial Intelligence