variable criteria

Hi, I have a workbook where the sheets change name depending on cells values in a master sheet but if there are no cell values i want the sheets to hide. Just wondering if anyone could help as im new to VBA Thanks Jack

Hi Guys, I hope you are all well and had a great holiday season. I was wondering if anyone can help me. I would like to know how to add a new variable to the code below that I am using for a holiday request form. That would say that If Team X is entered allow 2 people off and if Team Y Is...

Hi Everyone, I'm building a random name generator for a series of charity prize draws and I'm having a few problems perfecting my code. Basically, I have some VBA code that will search through a single column of names (column a) then select a name at random from the list before displaying the...

I am trying to write some simple VBA that will find a range of cells on one worksheet, to go to another worksheet to paste values of that range based on another range of cells. The method I’d like to adopt to reference the ranges is Range(Cells(R,C)),as it seems to provide the flexibility I...

Hello, Im trying to populate cells using a an index match function within VBA, I know how to do this with in a cell but cant seem to get it to work in vba. The code segment below is what i have so far, the underlined part is the line i am haivng trouble with. Thanks for help it would be much...

Hi I am very new to writing VBA's and am stupped on getting this macro right, I need to do the following: - When the value in a cell in column C changes compared to the cell value above - a blank line needs to be inserted between the different values - then I need to copy the values from the...

Here's a challenge: I'd like to sum the differences between two columns (B-A) but only for those rows where column B's value is greater than Column A's: <tbody> A B 1 6 5 2 7 7 3 5 7 4 5 8 </tbody> So my desired formula would produce '5' for this array, summing the difference...