range1

My input data is in Range1 Range1: B2:G12; values are either of +ve or -ve values or zero or null, columns are contiguous. There is another ‘flag’ range which is below Range 1 i.e. below B2:G12 at B14:G14. B14:G14 is either of 100 or <>100 with a caveat that at a time, at the most, only one 1...

Hi All, Hoping you can help please. I have the below code, which use an array of data to autofilter another range of data: Sub CodeSample() Worksheets("Pending Raw").Select Dim range1 As Range Dim var1 As Variant Dim sArray() As String Dim i As Long Set...

Hi all Master of VBA I hope you can help me for the issue below. I tried several ways in my ability but it still doesn't resolve I have two ranges (1 row and unknown number of column) same size. We can call them is range1 & range2. For example: Range1 =...

Hi there, So I've been given a task to find and replace items in a spreadsheet with a range. Now I've had 0 experience in VBA before this, so I'm a bit confused. And could use some help. I will put it as simply as I can, because my brain gets confused when I go into the details of the task...

Hello, I currently have the following code: Dim ws as worksheet Dim range1 as range, RNG as range Set was =ActiveWorkbook.Worksheets("master") Set range1 =ws.range ("B10:B13") Set RNG =ws.range("C7") With RNG.validation .delete .add type:=xlvalidatelist, alertstyle:=xlvalidatelist, _...

The sumif formula has a sum range, criteria range1, criteria1 those are required fileds you can insert more criterita ( or 3, etc) i am wondering if it is possible that based on a combo selection if a sumif formula can have 2 criterials for on instance and based on a selection only have 1...

Hello Sorry for my english. I need help regarding below issue. I need to use vlookup in a closed workbook searching for a value from right to the left. Macro is working from left to the right but I need to search values from right to the left. I have something like this: Sub vlokup() Dim...

I am sure this has been asked before, but I can't find it. I am trying to take data from one worksheet and bring it into another. First I am trying to define name ranges in worksheeets 2 through 9 with the names Range1, etc to Range11. (Worksheet2 has a name "Trial23", Worksheet3 is...