currentregion

Hello All, I have this code below that selects the CurrentRegion in a pivot table/cache. How can I add one row to the current region in the below code? ActiveSheet.ChartObjects("Chart 1").Activate ActiveSheet.PivotTables("PivotTable2").ChangePivotCache ActiveWorkbook...

I have a copy button that is supposed to copy a range but only the cells that contain data and I'm currently using CurrentRegion but that doesn't ignore the cells that are blank with formulas in them. The formulas go from A1:H44 but columns A through H are merged so it's really just A1:A44...

I have a workbook that is generated by an online portal. When I try to find the last cell in the data I notice that the column is actually blank yet Excel is acting as if it must contain data. Thus Range("A1").CurrentRegion includes two columns to the right of my data that are completely blank...

Hi everyone. I have code that succeeds in expanding the current selection (CurrentRegion) to include one more column. It does that great. But when I added in lines (4) and (8), i get a error 404. Heres what I got: Private Sub CommandButton3_Click()Set Rng = Range("L5").CurrentRegion...

Hello, I am trying to set up a page which holds the info of all workers that worked on a specific given date per Team (Painter, Carpenter, ..) All workers are in a sheet which holds name, start and end date of contract, etc .. And which team they were assigned to. So far I have come up with a...

Hello there, I need to sort by multiple columns in a worksheet where the worksheet name, column locations and used range will change every time. I have the below code but it's not sorting so I know that I've missed something.... I think it might be the range variables that I set and then use as...

Hi All, This is really frustrating me: Trying to set a current region within a vlookup. Never done this before. Data in "test 1" sheet is somewhat dynamic: rows are variable; columns are set to 12 (A:L). Thought CurrentRegion would do the trick. And maybe it still could but referencing it into...

I have the following macros on the Sheet code of one pivot table which works great for refreshing, selecting entire pt to print and also resizes if anything changes on the pt. I am including both sets of code below Here is my issue, when I copy this data to another sheet and modify the sheet...

The following code does not allow the 'CurrentRegion' to be selected and 'Set'. I believe it has to do with the pasting does not retain focus of the table that 'Database' creates. Range("Database").Copy Range("A2800").PasteSpecial Paste:=xlValues, _...

The code accomlishes its purpose. But, the OBJXL (excel object) is orphaned and refuses to be destryoed with Set ObjXL = Nothing Any suggestions would be welcome Without the OBJXL qualifier in front of .Range - it is an error. With the qualifier: <OBJEVCT Set Not Variable Block With or>...