Error with Macro and referencing another sheet

[anoble1]

I have a module that runs an update. I would like for it to run some code on another sheet then jump back to the module.
I keep getting a Compile error. Sub or Function not defined. I must be using the wrong Call on the TargetUpdate

Please Login or Register  to view this content.

Here is what I am trying to get ran from the TargetUpdate on sheet1

Please Login or Register  to view this content.

[6StringJazzer]

Make TargetUpdate Public (it is Private).

Also when you call it you must provide the argument value for Target.

[anoble1]

I made the change to public. What do you mean by "provide the argument value for Target"?
I am now getting this after I run. Expected Sub, Function, or Property

[TMS]

Put TargetUpdate in a standard module, or try Call Sheet1.TargetUpdate. I'd go with the first option. And you need to pass the Target range to the called subroutines.

[anoble1]

Put TargetUpdate in a standard module, or try Call Sheet1.TargetUpdate. I'd go with the first option. And you need to pass the Target range to the called subroutines.

I changed it to this: Still getting an error Argument not optional.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

[jolivanes]

my_macro should also be without double quotation marks.

[TMS]

Still getting an error Argument not optional

Yes, because you're not passing the Target variable when you call the subroutine. Looks like it can find it now because it wants the parameter you promised it.

[6StringJazzer]

my_macro should also be without double quotation marks.

For a call to OnTime, the name of the macro to be called must be in double quotation marks.

[6StringJazzer]

Please Login or Register  to view this content.

TargetUpdate requires a single argument, which is a Range. You are not passing any argument. Your call should look something like

Please Login or Register  to view this content.

But CAUTION you have not explained what you want your code to do so I actually have no idea what should really be there.

[jolivanes]

Re Post #8. (6StringJazzer)
I was not aware of that at all. Thanks for clearing that up for me.