currentregion in vba

Hi everybody. I've been tinkering with a small code section using the Currentregion and trying to offset a case based on it What I was hoping for, was a currentregion.rows.count = x, lets say 10. Then for each of those 10 rows, it would apply the cases below on offset(0,12) and (0,13). I...

Hi All, I have a table that needs to expand to another column, and I know that cell "b3" is a part of that table. I know that: Range("B3").CurrentRegion.Select will select the entire table, but how should I go about expanding it one more column? Thanks a ton, Bill

Hello, I'm working on a program recently to automatic generate graph based on a set of data. However, I am facing some issues now as I need to select Column A and Column C to setSourceData for my graph as shown below View image: table 1 I'm using CurrentRegion property to select the a table...

Hi Folks Currently in my formula, I am using: Set src = ws.Range("B3:C3").CurrentRegion.Offset(1, 0) Set dest = wssum.Cells(Rows.Count, 1).End(xlUp).Offset(1, 0) src.Copy Destination:=dest I need to change the 'currentregion' to just the data in B3:C3 (down to the end of the...

I have only one column i.e. A with some values and I wanted to select the column using currentregion property. I tried the code below, but it could not select anything. Is there any mistake? Range("A1").currentregion.select Of course, I know the other way to select is using code...