usedrange

I am successfully creating a pivottable based on usedrange for a source table that has varying columns and rows. How can I use VBA to select all available fields to add to the report? Right now it comes up with the "Available Field List" so I manually check the all of the available fields, then...

I am receiving an error message "Constant Expression Required" from the following code: num_xmitters = ThisWorkbook.Worksheets("Instr List").UsedRange.Rows.Count Dim TransmitterArray(1 To 4, 1 To num_xmitters) As Range I do not feel that this range is varying since the used range on...

Hi Experts, I have converted some different code found on the site to do what I want but have two small issues I hope someone can assist me with. Basically what I want to do is find a blank set of cells within a column between to values then copy the top value to all cells (then continue...

Is there a way in VBA to bind a chart to a cell area? I am looking for a way to have my chart included in my UsedRange pickup of a copy. That is then pasted to a primary sheet.

I have a worksheet with a unique number in column A "NumberList" and other columns of data. Autofiltering is on. I need to filter the worksheet on column 13, then copy the contents of displayed cells in column A to another worksheet. In 2001, Dave provided an elegant response to a similar...