union

Hello guys first post here, So, I have a list of automotive parts, their start of production, and the capacity of the line like this: Current Part W Part X Part Y Part Z July, 2016 August, 2016...

Hi everyone! I'm struggling with the following code which you can see below. It is totally a pain in the *** now. I really need some help. This code is a search tool which looks for criteria from every worksheet except the summary and the list. After the .Find founds the word, then the code...

Trying to use Union and ranges to speed up deleting empty columns, but going wrong somewhere with the code. I read here that deleting columns individually slows down performance significantly. Script speed can be improved by defining a "master" range to include all the ranges (columns) to be...

Hello people, Could someone explain following terms/declarations or whatever you call it: Const Union Concat Chr I did read some on Microsoft website but I didnt understood. Could someone help me? Thank you in advance

I am trying to paste some copied data from a group of cells on one sheet to a group of cells in another workbook. I keep getting the "Invalid procedure call or argument" error I am working with names from the name manager in both workbooks The error appears on the red area of code Suggestions...

Hello everyone, This is my first post. I couldn't find the right answer I want, that's why I am posting another select multiple range question. I've checked the forum and found couple of methods to select multiple ranges, but none of them worked for me. here is my question: This is my...

Should be simple but I'm stuck on this: I want to clean up large files by deleting all rows where certain cells do (or dont) contain certain values. I'm fairly new to vba, so I did what I usually do and cobbled up my script from posts here and on other forums, and then resolved the runtime...

Hello, I want to fill multiple Cells at once that are 5 columns off from each other, so I use Union(Cells(2, i), Cells(2, i + 5), Cells(2, i + 10), ...) = "Text" But the amount of cells is variable. Everytime we need a new set of columns, I need to change the code to implement them. What I...

I am trying to scroll through each row of a range and copying row to a new range that match a certain criteria. If each row matches the union works correctly. If there is a row that does not match the criteria then then next row that does match does not get joined by the union command -- even...

I am creating a financial forecast model that forecasts costs and revenues for about 15 departments; the costs change over time from inflation, volume changes and capital induced costs. I currently have about 45 tables, one for type of cost change for each department. I came across the following...

Hi. I have a spreadsheet the I wish to select multiple columns that are not continuous. The problem is, the columns to select may differ therefore, I do not know ahead of time how many arguments in a union that I need. Is there a method to dynamically define the number of union arguments...

Hello. I would like to check if selected cells is a union of several ranges or one solid range. I am sure there is a way, but did not manage to find it. Does anyone know how to do it?

Hello All, I have been working on project and have come to a halt because of code that isn't giving the needed result, I will explain below. This code copies only the first range (Range1) properly from cell ("B14:H" & Lastrow) but leaves out range2? Sub Copybook() Dim range1 As Range...

Hello All, I would first like to thank the MrExcel community for all the help in previous posts and future! I am working on code that uses the UNION function to coming ranges I have set and copy the selection, currently only the first portion of the union is firing? Any help would be much...

I have a range in VBA that says for example: (A1, A2, A3, A4, A6, A7, A8, A13, A15) Is it possible to merge that range together and simplify it into: (A1:A4, A6:A8, A13, A15) Note that the range covers cells from A1 to A15 but excluding some of the cells in that set. There is no specific...

Hello and thank you for your time and help, I am trying to create a function which would extract a subset from a given range depending on the values contained in another range. The final aim is to be able to use the Percentrank function on dynamically changeable groups <tbody> A B C D 1...

So I'm feeling better about what I know, I thought. (I tip my hat to all of you that have this stuff down.) Sub Shotgun() ' Builds the tee box array for a shotgun start in the TeeTimes page ' Reverse Shotgun starting with hole 1 and working backwards ' Par 4's & Par 5's have two groups - Par...

Hi forum members, I am obviously lacking in the VBA knowledge department, and am trying to create a summary sheet consisting of data that is collected from five other worksheets in the same workbook. On the sheets the data is being collected from I am checking various named ranges for the...

Hello, I'm trying to select the same cell and a blank cell multiple with a UNION(). Is this possible? Here's a summary of my code: Dim c Dim Rng As Range Dim blankC As Range Set blankC = Range("XFD1048576") Set Rng = Union(Cells(c.Row, 1), Cells(c.Row, 4), Cells(c.Row, 2), _...

I have an working range which I can define (at any particular point) and wish to CLEAR the rest of the WS of any possible formatting, borders or other leftover content. Is there a function to exclude my working range from the entire WS or what excel thinks is the "UsedRange" (vs the real...