variable array

Hello, First, I want to apologize if my english is not great. I am french and look forward to get tips from you for my project. My wish is to create a conditional format that is not fix to one same formula but a variable format which change for each column and each row... I can make it work...

Hi, I have searched for this to no avail, any help greatly appreciated: I run through several huge datasets in order to analyze some KPI's. The output is natural langage text. In the text variable that contains the full analysis, placeholder text e.g. 'xxSNITTxx'<snitt<'<name>, <total> etc...

Hi, I have a huge list looking like this (3 columns): <tbody> asset ID (A) Step (B) ID (C) 7148 03 LOOK 0 7148 01 MODEL 1 7148 04 RIG 2 7148 06 SETDRESS 3 7148 05 SHAPES 4 7148 02 TEXTURE 5 7147 03 LOOK 6 7147 01 MODEL 1007 7147 04 RIG 1008 7147 06 SETDRESS 1009...

I'm rather new to Excel macros, so please be patient if I'm asking for something that should be rather simple. What I'm attempting to do is recreate an RPG "inventory" of sorts with a UserForm in Excel VBA. So far, the way I've managed this has been by placing a ToggleButton underneath a...

Hi Everyone. I am writing a code to update a workbook. Part of this is to drag down formulas to the extend it reaches the bottom of a refreshed pivot table (used column E). I have used: With Sheets("Circuits") lastRow = .Cells(.Rows.Count, "E").End(xlUp).Row...

For i = 1 To 1000 If Sheets("Income List").Range("A" & i + 2) <> blank Then Range("A1:N&i").Borders.LineStyle = xlContinuous End If Next I have also tried For i = 1 To 1000 If Sheets("Income List").Range("A" & i + 2) <> blank Then Range("A1:N"&i).Borders.LineStyle = xlContinuous End If Next...

<tbody> I have a spreadsheet with 1000+ rows of data, that I want to filter down based on two separate columns of values. I know I can do this using the AutoFilter option, but I am trying to do this using an Excel VBA script which prompts the user for the values it wants to filter on...

Hey smart people. I have a column "A" of data and I want to select any cell in the column and run a macro that will select the next "x" number of cells below the current cell until I get to the cell that contains the word "Stop". Then I want the macro to start at the cell located 4 cells below...

Hi, I'm trying to set up a series of HLookups for a template we use to handle our quotations, acknowledgements, invoices etc at work. I've created the whole thing and have been asked to simplify how we search our reporting pricing. I want to create product codes for how long each contract is...

I am building a VBA search function across 3 product sheets (one at a time) for determining the next available size of packaging for a part (my attached example is available here VBA match 4 conditional values at once with Select Case. ). The search is based on 4 input criteria (length...

Hi, Made a big macro to collect cell data based on finding a text string, moving cell position down 3, across 1, and then selecting and copying all the rows with data in that column to another worksheet. Worked great until the next month when the new original data had the text strings in...

I am trying to cut a varying number of rows, user entered index n, and paste these data into the j'th column of a new sheet. Here are the relevant commands I have trying to do so; NOTE: "NAME" is just so I didn't have to type out the workbook name, I'm posting this on a separate computer not...

Hi there, I was wondering if anyone had any ideas on how to accomplish this. Currently, I have customer reports that I am creating macros for that analyzes the data on the report. The problem is the format of the report changes depending on which columns the customer wants to display...

Can you please help me with below: RANK (Cell Reference e.g. A1, Array reference e.g. A1:A10) Summary of Query: Need to derive row number in Array reference on basis of vlookup. Details: Basically I have list like below: Country Agent Amount India ABC 100 India DEF...

Hi All the below function is used in a table of many similar functions, The highlighted C is the main value changed to return the desired value. This works fine in all my calculations except when i exchange the C for a D. I have looked at the source data and anything else I can think of, but I...

Hi there, I have written a macro for a specific workbook to apply to multiple worksheets, I have about 30 other workbooks to apply this to and the sheet numbers will be different in each work book. All sheets that need to be formatted contain the word "plot" in the name. How do I set a variable...

I apologize if this is obvious or has been answered elsewhere (I've searched high and low and haven't come across it, even my manuals/books I am using to learn this stuff). I'm new to VBAs and macros. I'm trying to create a macro that will return the 50th percentile (median) of a column. I can...

1st post ever so be kind please. I created a macro that asks the user how many test forms they need of one type of test, then how many they need of another and so forth. When complete the macro spits out a workbook with X number of worksheet "Cats 01","Cats 02" and so forth, and then Y number...

I am using a linear regression array formula that uses a range of three columns, X, Y, and Yerror. Works great. However, the number of data points is variable. Is there a way to make the array formula detect the size of the range, or to ignore empty cells at the end of the range. The array...

I have an email challenge that I have not been able to overcome. I was using Sendmail but could not add anything to the body of the email. I switched over to the method below but have not been able to figure out how to use a variable in the .To instead of an email address. The email addresses...