dynamic range

I am getting a Run-time error '1004':Application-defined or object-defined error in copy/paste section of my code and I can't figure out why it is doing that. The last thing I tried was to add Cstr to the ranges. This macro is pulling information from one sheet and putting it to another, the...

Hi all. I can think of at least two other ways to do this. I can sort the columns so I know the column number I can find the cell, select the column, create a named range and sort on that. And I'm sure there are many more. I'm curious why I've never seen a range starting with ActiveCell and...

Hello! :) I am attempting to create a dynamic code to create a Pivot Table. I run multiple reports at work and each needs the same Pivot Table, so I'm trying to save myself some time. The issue I'm encountering is the SourceData. I cannot designate a particular Table because that will change...

Hi, how do I display selected columns from a dynamic range in a table, make changes in the table and insert the changes back into the worksheet? Thanks for any help David

Hi, I have a datasheet where the value in column A is repeated several times, columns B-G are different uses and specifications for the item in column A, I want to populate a userform with all the rows (A-G) where the value in column A is the same. Column A is sorted so all the duplicate values...

Hello everyone its been a while since I asked for help but I am trying to create a dynamic list, maybe I should use a table, on one worksheet (something that can grow or shrink in # of rows over time) and have that dynamic list available on several other worksheets in dropdowns so that when an...

Hi, Apologies if i am making a mistake or not following some proper protocols to post here. I am new to the forum and new to VBA but I am a quick learner. Need to ask if there is a way (without defining a variable) to replace the hard coded key range in the following code? I have a worksheet...

The following code of mine is not running: Sub Blank_Cell_Alert() Range("A2").Select Range(Selection, Selection.End(xlToRight)).Select Range(Selection, Selection.End(xlDown)).Select Selection.Name = "MyRange" ActiveSheet.Name = "MySheet" If...

Hello, I have two columns of data. The first column is time and is monotonic. The second column has data that is sinusoidal in nature. If I determine the time when there is a zero axis crossing, going from negative to positive, I can calculate the period of the signal between any two of...

Hi, I have encountered the following problem: I have a huge set of data (experimental measurements), which I have gathered to Excel so, that the data I'd like to plot in a graph is in every 8th column (first data series I'd like to plot is A30:B50, second I30:J80, third Q30:R70, and so on). I...

Hi, I've been searching to find a solution for my problem for about a week now. Can you please help me on this. I've a vba code to hide a number of rows based on a selection (Yes or No) in a cell. I've another code to add rows in a table above those rows. Every time a row is added in a table...

I have this table where where each column is defined in the Name Manager How do I pull a value (e.g. Region) into a variable, using the names I defined? I'd like to loop through the Regions column, this is what I'm trying: For i = i to lrow If Region = "Quebec" Then do something...

I have the following data in a Pivot Table in column C: Value 10 20 30 40 50 60 70 80 90 100 Grand Total: 550 I would like to create a dynamic range that references only the last 5 records of the Pivot Table: 60, 70, 80, 90, 100. The formula I'm using is...

End Sub Hi all, I'm trying to write a macro where i need to find the column header 'dec-26' in row 4 and extend the date till 'dec-31', i.e. add another 60 months and autofill the newly created cells so that the contents/formulas remain intact. I wrote a small part of macro using 'record...

I am using dynamic ranges to make an area chart so that there is a cliff instead of a slope down to zero. It is mostly working but I haven't figured out how to have the cliff go up from zero if it doesn't start on the first point on the x-axis. If I use a dynamic range then it simply shifts...

Hi Everyone, I'm working on a Rent Roll for a Real Estate Underwriting Model. In included growth rates in my model, which have different start dates depending on when a lease is rolling over. Since I'm multiplying my base rent with a rate and want to increase the base rent with the same growth...

Hi There, I've looked at many posts on this subject and unfortunately I cant seem to use them to stitch together a solution, so hope this new thread doesn't annoy people. I have a workbook with just one worksheet in it, called 'Template_data'. The number of rows in this could change, so I...

Hello again! I have a dynamic chart based on a named range. It displays the percentage of the subject (specific column) of all papers (each is a line) listed on the range, named "main_tab". If it matters the "main_tab" range is also "dynamic" (not a fix range, but uses OFFSET and COUNTA...

Hello all, I have gone through every link I can find on the subject, and simply cannot find an answer to my problem. I consider myself pretty decent with VBA, but this one has had me stumped for three weeks. I have an OLAP pivot table that has a filter for Order Numbers, and a slicer to...

Hi Gang, I want to change this: =SUMPRODUCT(--ISNUMBER(SEARCH({"A1","A2","A3"},C1)))>0 to be a range like A1:A10 instead of "a1", "a2", "a3". However, if none of the cells in the range A1:A10 match C1, yet are empty, it will still return TRUE for some reason.