position

What's the easiest what to determine the position of a range within another range via VBA? In my case, I want to know what column (not the column number) a range falls within another range? For example: Range("C1") in Range("C1:G1") Range("N1") in Range("L1:O1") I would like to know that C1...

I have a spreadsheet that lists all of our candidates by name and the corresponding manager. It also includes the position number they are interviewing for. On a separate sheet, I have the position number in cell i7, I'd like $j8 to show the candidates name. If there have been 10 interviews...

Hello everyone, I have a macro that I wrote that duplicates a selected range at some position in my worksheet. The position is selected based on informations given by the user through an UserForm's ListBox. This macro works well and I would now like to determine its runtime depending on the...

I have a comment box that displays in a very bad position on my Excel 2016 Spreadsheet. Even when I move it under the Edit Comment Function, when I hover over the cell, it still displays in the the comment box in the original position. Is there anyway I can lock the comment box in the location...

Dear All, The code above replace my font Size and Apart from this I need to align to the below mentioned position . Please help me to incorporate this code Sub changeFont() For Each aSlide In ActivePresentation.Slides For Each aShape In aSlide.Shapes If aShape.Type = msoTextBox Then If...

I have made a spreadsheet for my supervisor and he wants the ability to insert a custom signature file at the bottom of a sheet using the browse dialogue box. I already have two buttons that enter a signature each. The signatures are in the right position. Sub cmdJakeSig()...

Hello, I am needing to rank a table that has columns for Names, Point Totals, Avg Race Position, and Avg Qualify Position. The ranking should be by largest point totals, however if there is a tie, the first tie breaker would be by lowest avg race position, and if still a tie, by lowest qualify...

After a year as a temp (it was supposed to be 2 months) I am moving on, going back to Purchasing, this time at a Level ! Trauma Center. The project I did and re did and re did is now ready for prime time. To all the wonderful folks who answered my questions and showed me the way, thank you from...

Hello, my vlookup did return a value however I thin it is lying to me. When I have a filer on the column and look for the value as a check, it does not appear. When I try a control f the value does not appear. I have not tried an index match yet. Is there a simple formula to locate the...

Hi, I have the following Excel Module that creates a new formula called Findword, Currently I have to press Alt + F11 and add it as a new module everytime I open up a new workbook, is there a way to save it in the background so it can automatically be used in every workbook <code class="vb...

Hi guys, I have a code to create a Pivot table. A piece of the code orders the columns in a specific order, but it used to fail if there wasn't values of some of the items, so I added the "On error resume next" statement. However, it seems not to be working. This is the code: On Error...

Good day, I am trying to find a way to jump to the “value” cell that my Vlookup is returning based on the “reference” cell. This is because I may wish to change this value and am looking for a way to get to it easily. The Vlookup formula used is...

Hello, can anybody help me with a solution to my problem. I receive a data set from a 3rd party that i have no control over the formatting of. I have my own sheet with various formulas that refer to data in the 3rd party sheet however the producer of the original sheet regularly changes the...

I have created a groupings of several userform objects. With VBA, how can I move that group of objects into a certain position of a userform frame? Some groups have upwards of 20 objects.

Hello All, I have 2 pivot tables based on the same range of data. There are reasons why these need to be separate for my use so they can not be combined. I am now introducing slicers to my worksheet. However, is there a way to make the position of my pivot tables dynamic based on the slicers...

Hi All, I have tried and failed to work out how to modify this recorded line of code to allow me to use variables. The line is based on reordering a pivot table hierarchical field into the order that I want. I’m doing this as I can’t use Custom Lists as the list far exceeds the limit allowable...

Data Set:Sheet1 (Table 'Alpha' on Sheet1!A1:B200) -ColumnA: Employee_Name (sorted A-Z) -ColumnB: Qualification_Code (01A, 01B, ..., 01Z) (Each employee has a single Code, but multiple employees have the same Code) Sheet2 (Sheet2!A1:C100) -ColumnA: Position_Title -ColumnB: Position_Code (01A...

Hi I've been looking at tutorials but can't quite get this to work.. I have a table with data set <colgroup><col><col><col><col><col><col><col span="2"></colgroup><tbody> CompanyID CompanyName Field Name Control Centre Position Field Source Country Code Country Name GDS 12345 ABC COMPANY...

I have a VBA code which i use to copy areas from excel sheets, into a powerpoint presentation as a linked image, and then resize and position correctly. While the code works most of the time, the code randomly returns the following error: run-time error '-2147188160 (80048240)'...

I have below columns and want to organise image urls from column B in columns D,E,F,G etc as per their position. How can I do this in bulk. Please help