(VBA) Search and find certain text in a column, add the number from the neighboring column to the end of the text

[zack8576]

Hello, I am new to this forum, and new to VBA.
I need to write a VBA script that can search column K and find text "C BOX(6"WALL), and add the number that is located in column L on the same row to the end of the text.
How can I do this? Any help is greatly appreciated !

 

[zack8576]

Option Explicit is a habit you should get into - it forces you to declare all variables you use throughout your code. This helps avoid many errors. To demonstrate, using the code in post #5, remove the

c as Range

bit and try running it again.

Wow, so when I use Option Explicit, and a variable is not define, VBA actually tells me that this is not defined. that is awesome, so it would be a good practice to have this at the beginning of ALL the macros?

 

[kevin9999]

Wow, so when I use Option Explicit, and a variable is not define, VBA actually tells me that this is not defined. that is awesome, so it would be a good practice to have this at the beginning of ALL the macros?

Absolutely.

 

[zack8576]

Absolutely.

Alright, thanks a bunch !

 

[kevin9999]

You're welcome Zack, and thanks for the feedback

 

[zack8576]

You're welcome Zack, and thanks for the feedback

Kevin you have no idea how much I appreciate your help.. Your skill in VBA is very impressive
I have one more questions posted below, which is the last VBA hurdle I need to clear on this company project
With your tremendous knowledge in VBA, you might know the answer to this one too...

VBA change cell values based on the text in one column and a number in another column

Hi, I am very new to VBA. I need to modify some of the values in column D based on the text in K and the number in L. We will use column K to determine the type of item, and use the number in L to determine which range this number falls in. It then pulls the correct item# from the master.xlsx...

www.mrexcel.com