vba "&"

Good afternoon, The below code only adds the worksheet name to column cell range D2-D5 regardless of what text is in cells D2-D5. Can I get your guidance to amend the code that if there is a word "Category" or "Store" in column D that it adds the worksheet Name and _with the cell value which...

hi I'm new to vba and I'm trying to write a code that will delete duplicate rows if say values in column C match up. But I want to delete the row that has the earliest time stamp heres an example. <tbody> Number time stamp round device 5 16/6/22:39:44 5 15 4 16/6/22:39:44 2 16 8...

Hi, I am still new to excel vba and I am asking for your help. I have tried to query soccer league tables for different leagues but I don't know how to use loops. I want to query tables for different leagues (those with home and away) and put then on another sheet one after the other(skip one...

The problem I am having with the following code is that I am not able to select the values one after the other. I always have to go back to empty cell value before I can select the other value. For example; if I select "1st' it displays the required info and hides the columns that are supposed...

Is there a function or a way to add bits together like you can by using "&" in vba? without having to go into VBA