range

Hi all, long time lurker first time poster. I am somewhat of a VBA newbie and am trying to write a script to assign values from one of my workbooks to a template workbook, however the data in the source file is non contiguous. The below script does not cause an error. however the data from the...

Hi, I have built a stock list for which part numbers are in Column B (ITEM CODE) and purchase price is in Column E (PURCHASE PRICE). Values increase over time therefore I require when an item is booked out to search for the most recent (lowest) value within Column E (PURCHASE PRICE), and add...

Hello All, I am trying to make a more generic way to create a XY scatter chart and add data to the chart. Here is some test code. Sub Test_Add_Series() Dim DataTab As String Dim PLTab As String Dim Xrange As Range Dim Yrange As Range Dim Trange As Range Dim Snu As Long DataTab =...

Hi all, Hopefully an easy question for you :). I am very new to VBA and I am currently fiddling in an already made document to try and understand what is happening. It is an Excel sheet where we want to copy data from various sheets into a single sheet. It starts with searching the input...

Hi, I want to apply the same data validation to a range of cells ("F8:F51") on worksheet"B". This validation is based on the value in cell "S3" also on worksheet"B" which is populated from a formula based on the value from a range "Unit" in worksheet"A". So for example if range "Unit" on...

Hi, I am trying to detect which cells contain text that is strikethrough, but my loop is passing over a bunch of cells without detecting the strikethrough text in them. Here's my Code: Private Sub FilterList() Dim ws As Worksheet Dim rngCheck As Range, rng As Range Dim lastRow As...

Hi all. Here's a head-scratcher for you all... I have linked to an example workbook in Google Sheets below (unfortunately I don't have Excel on my home PC). Basically I have one worksheet - "Sheet 2" - with a bunch of data. I have another worksheet in the same workbook -"Sheet 1" - that I need...

Hi, CDEFG1Var AVar Bexpected result...

Hi, Sample of 100+k rows data: DEFGHIJKLM1MaxBIBexpected result :231.207021.207024Max Exist41.207021.2067551.207021.2088961.207021.2030271.207021.2070281.207031.207031Max X91.207031.20701101.207061.207063Max X111.207061.20702121.207061.20705131.207061.20702141.207021.20699151.207241.207246Max...

Hi, Sample of 100+k rows: FGHI1Bexpected result...

I have a file for tracking where certain loans are while I maintain them. I use sum() and count() formulas to help me make sure I have everything. But what happens is after some time of deleting rows the range in the formulas no longer captures all the data and they need to be readjusted...

Hi How do I create a dynamic named range which I can use in an email macro so the updated range (will only change the number of rows down but not the number of columns ) can be copied and pasted into an automated email generated in outlook? Thanks! James

I have some data in a spreadsheet, and have used VBA to create a dynamic range object from this data like so: Dim ws As Worksheet Dim rng As Range Set ws = ThisWorkbook.Sheets("Sheet1") Set rng = ws.Range("A1").CurrentRegion I am new to VBA, so I don't know exactly what this range object is...

How you check if non contiguous selection is on more than 1 row and more than 1 column. In this case, don't continue macro. In image below, grey cells represent selection. Tried to test using below but don't get the expected answer. MyRange.Rows.Count MyRange.Columns.Count

All, I decided to make my first post a fun one. I am working on some code to essentially find any cell in a given range that has text and append .01 to the end of it, but need to skip any cell that is blank or null. Currently this is working ok, except when it skips a blank cell lets say row...

Hello. New to this board. I found some code that compares two worksheets (sheet 2 with sheet 1) to determine if there are any differences in the rows. The code works perfect for highlighting the entire row. If there is a difference in the row on sheet 2, it is highlighted in red. Instead of...

I am making a bracket for basketball teams by region. I select the winner of the game based on a list referencing the named ranges you see pasted below. I pull data from multiple web queries into each regional bracket and have many formulas. Because of this, its quicker to copy the sheet and...

I made a small change to simply skip/remove F4, F20:F24, F94:F101 from the original working rangeBudget as shown below. Original rangeBudget array on Line 43 no error, works. Modified rangeBudget array on Line 39 gives error. Range F81:F:90 on the Months sheet is the last highlighted range...

Hi, I have a formula that looks up the last value in a range. This formula is =LOOKUP(2,1/(L2:BI2<>""),L2:BI2) I would like another formula to look up the 2nd last value in a range. Could someone supply this for me please? Thanks in advance

Hi, I am wondering if there is a Multiply function that replaces the SUMIFS? Basically the formula will look for 3 critertias and will return 4 different values. In a SUMIFS formula it will add the values however I need each of the 4 values to multiply. Example 2, 3, 4, 5 in a SUMIFS will return...