Macro not working excel 2016

[knuttybuddy]

Hello,

I have a code that I want to use

Please Login or Register  to view this content.

However when I put it int excel, the code will show up under my workbook or sheet, however it will not be found when I try to run it.

I noticed that when I take away the text between () that it shows up but I need the (ByVal Target As Range) to work

Moderator's note: Please take the time to review our rules. There aren't many, and they are all important. Rule #3 requires code tags. I have added them for you this time because you are a new member. --6StringJazzer

[6StringJazzer]

If a macro has parameters you cannot run it from the Run Macro dialog because there is no way for you to provide the parameter values. It has to be called by other code.

In the case of Worksheet_SelectionChange, it is automatically called by VBA every time you select another cell on that worksheet.

[knuttybuddy]

Hello,

Where would I run this code then? I am very new to this.

[Zer0Cool]

2 parts here.

As mentioned, if the code is Event code or has parameters you cannot run it manually. Also a private sub or function will not show in the macros dialog to run.

What is it you are trying to do with the code, whats your goal?

[knuttybuddy]

Thank you Zer0Cool! I actually got it working. However, I ran into one more small issue with my overall goal.

I trade currencies/Forex and I am working on plotting the co integration of two currency pairs. Basically I want to continually add the most recently FX prices but keep the number of cells constant. I only
want 2 days worth of 1 minute date, or the most recent 2880 1 min prices. I already have an automatic feed into my excel that updates my prices. However, if for example I use the code and I input a price into cell 5, that price will stay
and the first price in the series will be deleted, and it will continue like that so my prices are always the 5 most recent. However now when I add a formula to cell A5 to be = to the cell that has my automatic price update it will update once
but then the price moves up like it should and the formula disappears making my automatic update worthless.