r.offset0

Hello, first time posting...I borrowed a bit of code to create a search box in cell B1. This allows me to search in the Range for a keyword, and it returns matching rows. I would like to know how to expand this, in order to search for two or three keywords. Thank you! Sub...

Hi, having trouble with this one basically i have a column (J) of cells with the following formula =IFERROR(INDEX(B2:$B$10000,MATCH(I2,F2:$F$10000,0)),"") and i want to write values into all the cells that are blank something like: Sub test() Dim r As Range For Each r In Range("J2:J10000")...

I have the following already performing the concatenation of the columns I need, and its working flawlessly, however I need to insert a period "." in between each concatenated item (addresses) but I'm new to Evaluate & having difficulty. Every time I try to put & ""."" & it gives me a #Value...

Below is my code to take a range and place onto another sheet. What i'd like to do is to put the range in an array, and then do the calculations in the code, rather than just copying the range from one range to another. The code below works, but i'm relying on the calculations from the...

Hello all, I'm new here and need a bit of help please (new to VBA Excel) I'm trying to get the following code to work but cant work out how to go from one stage to the next Private Sub Worksheet_Change(ByVal Target As Range) 'First name entry (cell D), time & date auto entered (cell A & B)...