Macro Copy/Paste to chart

[Jiptastic]

I use the record macro feature a lot since I don't really know any VBA. I need to be able to copy a Vlookup formula and paste it to all rows below until the adjacent columns are blank. Normally you can just double-click the bottom right corner and it will automatically apply the formula to the spaces below until the bottom of the chart. But when recording a macro this double-click trick does not transfer to the correct command. Instead it refers to the specific cells, which means the macro won't adjust to the size of the chart.

Any solutions?

[Jiptastic]

Bump. No reply.

[Andy Pope]

Probably because nobody can understand your question.

You may have more luck if you post a workbook example with information that shows start and finish data sets and explain why copying down alone does not suffice.

[Jiptastic]

I have attached an example. The Macro pastes the Vlookup formula to the rows below but it does not know when to stop pasting.

[Andy Pope]

The workbook contains no code and the data on the worksheet contains no formula.

Not sure how that helps.

[Jiptastic]

Andy,

I had to delete out some of the information because it's proprietary to the company I work for. Shoot, I thought it was an easy question that could be answered with one quick command. I don't see why an example is necessary with this one.

When you double click on the bottom right corner of anything it automatically pastes to all cells in the row below until the bottom of the chart. There has to be a simple command for this, but the macro recorder doesn't pick it up.

[Andy Pope]

Please Login or Register  to view this content.

I cleared the contents of C6 downwards. I then double clicked C5 to fill the range C5:C18 with "Akinaw Bulcha".


It probably is something simply but without know exactly what you are using and with the layout of the data you have we can only guess.
The main reason for the cells beyond the table of data populating is that the cells around actually contain formula even if the results of the formula are not displayed.

[Jiptastic]

Yes I need something that will autofill to whatever range necessary depending on the size of the chart. It should be more like
Selection.Autofill Destination:=Range("C5:C?") Perhaps it's not as simple of a command as I imagine.

[Andy Pope]

Using the column to the left of the activecell to determine end of data.

Please Login or Register  to view this content.

[Jiptastic]

Andy, Thanks that looks like what I need. When I get back to work on Monday I'm excited to try this. I have many macros that could benefit from this.