vary

Hi Is it possible to create a code that color every second Row with e.g. RGB: 221, 235,247 Two pages in the Workbook, "Data" and "FrontPage", should not be colored. The size ofthe Range on the sheets to be colored can vary in number of rows Range to be colored always starts at "A7" Regards Jorgen

Hi Experts, In one of the cells i have the below formula : ActiveCell.Formula = _ "=""Hi," & Chr(10) & "" & Chr(10) & "Good Day!" & "Please confirm the PO# "" & A2" What i need is, the last A2 in the formula is not constant i want to use somethig like A & i where "i" will vary. So...

Have a SS that has a ton of lines, would like a button that would jump to the next cell that does not have text. It can vary each time though. Thanks

Hello, I want to create a macro that looks for blank cells in row 12 of a daily Excel-based report I generate. When it finds one, I want to select every cell in that column starting with row 11 and going down until the same row as a cell in Column A that contains the text "Total Unapproved...

I appreciate any help you can offer on this, In column A i have a product code, i want to copy this down into the blank cells below until i hit the next product number and repeat until no more product numbers. The blanks spaces in between can vary and the product numbers can vary also. Thanks...

Hello, I am looking for a solution preferably with formulas or in vba. Need something to be able to calculate the cycle times in column 8 below by subtracting the finish time from the start time for each cycle. The cycles vary in cell row ranges so I'm not sure how to go about this. Thought of...

I want to write a function where the first argument is mandatory (the year) but subsequent arguments vary from no arguments to as many as entered. Is that possible? I don't want to write: Public Function MyFn(Year, Optional Loc1, Optional Loc2, Optional Loc3, Optional Loc4, Optional Loc5...

Hi, I have a line of text that contains numbers. I only want to extract the first set of numbers. Example, the text in cell A1 will always say "Deposit Black PB 500.00". There will always be 2 spaces after PB, however the amount will vary, from say 1.00 to 50000.00. I only want to extract...

Hello! I couldn't find any answers by googling the following question, and am hoping you guys can help me. My problem is this: In A column I have identidy numbers. They can vary from being one to several dozens in the column. In column B I have a certain type of number, it can vary from 1 to...

I'm trying to create a warning formula to tell me if C2 is within 2.25 of the value of A2 divided by 2. I think it will be an IF AND combination but could be wrong. To explain further here is an example; if A2 is 110 and C2 is any number equal to or between 52.75 and 57.25; basically if C2...

I have 17 columns A to R. I want to use the TREND function to enter values in column R, starting at row 3. I have the following code successfully for rows 3 to 39: sub test() dim lastforecastmonth as long lastforecastmonth=cells(rows.count, "A").end(xlup).row range("R").select for I=0 to...

Hi Two things - in the below code . I have just recorded a macro to get this . 1, Is there a neater why to do this and 2, The start cell is static but the to cell can vary (j2 static. j50 can vary ) is there a way to acheive this with out having to alter the code every time...

If i have a row like this: <tbody> Oct-2017 Nov-2017 Dec-2017 Jan-2018 Feb-2018 Mar-2018 Apr-2018 </tbody> The contents of this row can vary - I want to be able to create a dashboard to copy the contents of this row and transpose to a column Is this possible?

Hi, I'm looking for some code that will select entries in a table based on the criteria in two cells and then copy the selected entries into another table. The two tables are on different sheets. Hopefully the pic below is fairly self-explanatory. So, in the example, the yellow cells in the...

Greetings, I would like to be able to copy a string value from one cell to another. The string value to copy will be located in the target cell after an "&" and go until the last character in the cell. The length of the string value will vary from cell to cell. Any ideas as to how something...

Hi All, I have a list of staff which varies from week to week and need certain elements amending such as changing the '/' to '-' for dates, replacing words and to minus 7 days from a date. - Firstly I need the date format changing from '/' to '-' starting in column F2 (the amount will vary...

Hello all, I think I asked for help with this in the past but I can't seem to find anything in my history. I need to take the last character in A1 and put it in B1. Can't use the MID function because the number of characters can vary. <tbody> A B 1 20A08D D 2 PR115 5 </tbody>...